Putting all Requirements in single file not working

[ITcore]

I don't know what I'm doing wrong. I have all the requirements in a single file. That file is given priority to load first. The requirements are listed as "RequirementSets", "RequirementSetRequirements", "Requirements", "RequirementArguments".

However, no matter what I do, it always fails to load. My database.log has pretty much every RequirementSet listed in Modifiers.SubjectRequirementSetId as not existing in RequirementSets.

I'm at a loss. The entire list of errors is below including one up top that I do not know how to find out.

[1623781.184] [Gameplay] ERROR: UNIQUE constraint failed: RequirementSets.RequirementSetId
[1623781.195] [Gameplay] ERROR: UNIQUE constraint failed: RequirementSets.RequirementSetId
[1623781.268] [Gameplay] ERROR: 5 values for 6 columns
[1623781.328] [Gameplay] ERROR: FOREIGN KEY constraint failed
[1623781.328] [Gameplay] ERROR: FOREIGN KEY constraint failed
[1623781.328] [Gameplay]: Validating Foreign Key Constraints...
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_INCENSE" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_SPICES" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_SPICES" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_IRON" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_HORSES" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_NITER" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_IRON" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_GYPSUM" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_MERCURY" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_COPPER" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_SILVER" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_GOLD" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_COPPER" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_MARBLE" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_COAL" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_OIL" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_URANIUM" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_OIL" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_ALUMINUM" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_ADJACENT_TO_STRATEGIC_REQUIREMENTS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "RESOURCE_IS_OIL" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_OASIS_REQUIREMENTS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "CIV_IS_MINOR_CIV_REQUIREMENTS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "CITY_HAS_HARBOR_PLOT_IS_COAST" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "UNIT_IS_NAVAL_MELEE" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "IMPROVEMENT_IS_MINE" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "UNIT_IS_RELIGIOUS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_IS_IMPROVED_WINE" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "CITY_HAS_COMMHUB_REQUIREMENTS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "CITY_HAS_AERODROME_REQUIREMENTS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "FEATURE_IS_RAINFOREST" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_PLAINS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_PLAINS_HILLS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_DESERT" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_DESERT_HILLS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "SUTAIO_CAVALRY_PLOT_IS_OPEN_REQUIREMENTS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "FEATURE_IS_RAINFOREST" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLAYER_HAS_STRONG_NAVY" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLAYER_HAS_SMALL_NAVY" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLAYER_DIFFERENT_RELIGION" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "REQUIREMENTS_PLOT_HAS_COMMERCIALHUB" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "REQUIREMENTS_PLOT_HAS_HOLYSITE" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "REQUIREMENTS_PLOT_HAS_HARBOR" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "REQUIREMENTS_PLOT_HAS_CAMPUS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "REQUIREMENTS_CITY_HAS_HOLYSITE_AND_CAMPUS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "IMPROVEMENT_IS_LUMBERMILL" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "IMPROVEMENT_IS_LUMBERMILL" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_IS_IMPROVED_JADE" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_IS_IMPROVED_JADE" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_DESERT_HILLS_REQUIREMENTS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLAYER_IS_AT_WAR_WITH_MAJOR" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "IMPROVEMENT_IS_FISHING_BOAT" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "NORWAY_HAS_COASTAL_CITY_REQUIREMENT" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_SNOW_REQUIREMENTS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_SNOW_HILLS_REQUIREMENTS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_STRATEGIC_REQUIREMENT" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "CITY_HAS_INDUSTRIAL_PLOT_IS_TUNDRA" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "CITY_HAS_INDUSTRIAL_PLOT_IS_TUNDRA_HILL" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "UNIT_IS_LIGHT_CAV" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "CITY_HAS_PALACE_REQUIREMENTS" does not exist in RequirementSets
[1623781.339] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "CITY_HAS_PALACE_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "CITY_HAS_PALACE_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "CITY_HAS_PALACE_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PASTURE_ADJACENT_TO_HOLY_SITE_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PASTURE_ADJACENT_TO_HOLY_SITE_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "CAMP_ADJACENT_TO_HOLY_SITE_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "CAMP_ADJACENT_TO_HOLY_SITE_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "QUARRY_ADJACENT_TO_HOLY_SITE_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "QUARRY_ADJACENT_TO_HOLY_SITE_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "DISTRICT_IS_ENTERTAINMENT_COMPLEX" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "DISTRICT_IS_AQUEDUCT" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_FARM_TAG_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_FARM_TAG_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "HOLYSITE_IS_ADJACENT_TO_CITY_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "HOLYSITE_IS_ADJACENT_TO_CITY_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_MINE_TAG_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_MINE_TAG_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_MINE2_TAG_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_HAS_MINE2_TAG_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "HOLYSITE_IS_ADJACENT_TO_CAPITAL_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "HOLYSITE_IS_ADJACENT_TO_CAPITAL_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_ADJACENT_TO_HOLY_SITE_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_ADJACENT_TO_ENCAMPMENT_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_ADJACENT_TO_CITY_CENTER_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_ADJACENT_TO_THEATER_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_ADJACENT_TO_NEIGHBORHOOD_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "UNIT_IS_MELEE" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_NEARBY_CAMPUS_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_NEARBY_COMMERCIAL_HUB_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_NEARBY_HOLY_SITE_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_NEARBY_THEATER_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_NEARBY_AQUEDUCT_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_ADJACENT_TO_COMMERCIAL_HUB_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_ADJACENT_TO_HOLY_SITE_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_ADJACENT_TO_THEATER_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PLOT_ADJACENT_TO_AQUEDUCT_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "CITY_HAS_SEWER_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "OPPONENT_IS_MELEE" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "LEGION_PLOT_IS_LEGION_REQUIREMENTS" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.OwnerRequirementSetId - "PLAYER_HAS_CAPITALISM_CIVIC" does not exist in RequirementSets
[1623781.340] [Gameplay] ERROR: Invalid Reference on Modifiers.OwnerRequirementSetId - "UNIT_IS_NAVAL_RANGED" does not exist in RequirementSets

 

[LeeS]

The top 5 error lines tell me you are getting a cascading effect from fatal errors in violating the unique constraint rules, and in a syntax error where you have 5 values stated for six column-names, which then leads to the foriegn key errors and the invalid reference errors because the game ceases to read anything more into the game's database from within a file once it hits a fatal error.

Also, attach the mod itself.

 

[ITcore]

I had thought the unique constraint error would be a requirement that is already defined in the base game but I haven't been able to find anything.

 

[LeeS]

Unique constraint errors mean you are attempting to re-add something the game already has for the same column (or combination of columns) within the table. In the definitions of the game's tables, a listing is made for each table as to which columns are "PRIMARY KEYS", like as with the definition of table RequirementSets:

CREATE TABLE "RequirementSets" (
		"RequirementSetId" TEXT NOT NULL,
		"RequirementSetType" TEXT NOT NULL,
		PRIMARY KEY(RequirementSetId));

The designation is made that all rows must have a unique setting for column RequirementSetId. Some game tables have two or more columns listed as "PRIMARY KEY": for these tables, the combination of the settings for the specified sets of columns must be unique to all other such combinations.

This line is violating the uniqueness rule because in the Buildings file there is already a row with that same exact designation for "RequirementSetId":

(	'PLOT_HAS_DESERT_REQUIREMENTS',   'REQUIREMENTSET_TEST_ALL'	),

Any violation of this rule causes the game to cease reading anything more from that file.

-------------------------------------------

In chasing errors that occur in SQL files it is necessary to compare the time-stamp of the error line from Database.log to that in Modding.log. Error lines with the same time-stamp between these two files mean the reported error in Database.log occured whilst the matching file shown in Modding.log was being conducted. In Civ6 this means that the line in Modding.log will generally be shown directly below a series of file-names that the game just attempted to load. Usually the last such file is where the error is located.

The error for 5 values for 6 colums appears to be in file Civilizations.SQL and is most likely a case of a missing comma or ' where needed to open or close a text-string.

--------------------------------------------

Most of the errors you are seeing in your database.log are as I suspected the result of "cascading", where a failure in one file causes other parts of the mod to fail (ie, there are references to things that never made it into the game's database), so you get the ERROR: Invalid Reference error in Database.log and get shunted back to main menu.

 

[isau]

Lee S provides some great advice.

Another alternative to checking timestamps is to create a debug table and write updates to the table after operations you think might be causing an issue.

I use one that looks like this. This table is created in the first file that loads in my mod:

-- Create a table for debugging
CREATE TABLE tblMyDebug
(
    DebugID text -- ID for the table,
    , x_Open text -- did the file open?
    , x_Close text -- did the file close?
    , Message text -- optional place for adding a message
);

(Please don't use the exact same table as I wrote here because that will create a mod conflict with other people who copy paste the code. Name the table something useful to you.)

You can add extra columns if you think they are useful. It's a custom table and can contain whatever you want it to.


Then throughout your mod, add lines like the ones below. The first text field I use as the name of the file that opened, but it could technically be anything (whatever is useful.) I add this line to start of every file to let me know the mod loaded it:

INSERT INTO tblMyDebug
    (DebugID,         x_Open, x_Close,     Message)
VALUES ('Quo_AA_Setup_Code',    '1',    '0',        '') ;

And this to the close of every file to let me know it closed:

UPDATE tblQuoDebug SET x_Close='1' WHERE DebugID='Quo_AA_Setup_Code';

You can also imbed updates anywhere in the middle of a file. I recently had an issue with a file that had over 2000 lines of SQL code. To help me track it down, I placed updates like this throughout the file:

UPDATE tblQuoDebug SET Message='Arabia' WHERE DebugID='Quo_AA_Setup_Code';


UPDATE tblQuoDebug SET Message='Egypt' WHERE DebugID='Quo_AA_Setup_Code';


UPDATE tblQuoDebug SET Message='Greece' WHERE DebugID='Quo_AA_Setup_Code';

You can then use a tool like Sqlite Studio to look up the status of all of your files with a simple SELECT statement that looks for your debug table.

Doing all of this takes a little time to set up but makes future updates easy. It's one of the checks I do before every publish of my mod.

 

[ITcore]

Thank you both, LeeS and isau. I really appreciate the in depth answers you both provided.