SpaceCommunist
Warlord
Hi all,
I've been working to update some of my mods on the workshop and I'm having a bit of trouble. Despite my best efforts, the mod(s, it's split in two) crash(es) due to some apparently unseen constraint failures.
Here's the text from the Database.log file:
Basically, what I'm dealing with right now is:
I've been working to update some of my mods on the workshop and I'm having a bit of trouble. Despite my best efforts, the mod(s, it's split in two) crash(es) due to some apparently unseen constraint failures.
Here's the text from the Database.log file:
[2142242.442] [Localization]: StartupErrorMessages.xml
[2142242.443] [Localization]: Input XML does not contain database entry tags. GameData, GameInfo or Database
[2142247.500] [Localization]: Validating Foreign Key Constraints...
[2142247.500] [Localization]: Passed Validation.
[2142247.513] [Configuration]: Validating Foreign Key Constraints...
[2142247.513] [Configuration]: Passed Validation.
[2142256.300] [FullTextSearch]: Initializing FullTextSearch
[2142256.732] [Gameplay]: Validating Foreign Key Constraints...
[2142256.745] [Gameplay]: Passed Validation.
[2142257.364] [Configuration]: Validating Foreign Key Constraints...
[2142257.365] [Configuration]: Passed Validation.
[2142257.417] [Database] ERROR: FOREIGN KEY constraint failed
[2142257.417] [Database] ERROR: FOREIGN KEY constraint failed
[2142258.306] [HallofFame]: Database found. Checking versions...
[2142258.308] [HallofFame]: Database is up-to-date!
[2142273.328] [FullTextSearch]: FTS - Creating Context
[2142282.306] [Configuration]: Validating Foreign Key Constraints...
[2142282.306] [Configuration]: Passed Validation.
[2142282.355] [Database] ERROR: FOREIGN KEY constraint failed
[2142282.355] [Database] ERROR: FOREIGN KEY constraint failed
[2142283.952] [Gameplay] ERROR: CHECK constraint failed: Districts
[2142283.952] [Gameplay] ERROR: CHECK constraint failed: Districts
[2142284.216] [Gameplay] ERROR: near ",": syntax error
[2142288.555] [Gameplay] ERROR: FOREIGN KEY constraint failed
[2142288.555] [Gameplay] ERROR: FOREIGN KEY constraint failed
[2142288.555] [Gameplay]: Validating Foreign Key Constraints...
[2142288.564] [Gameplay] ERROR: Invalid Reference on HistoricalAgendas.AgendaType - "AGENDA_SC_[spoilersnip]" does not exist in Agendas
[2142288.565] [Gameplay] ERROR: Invalid Reference on LeaderTraits.TraitType - "TRAIT_LEADER_SC_[spoilersnip]" does not exist in Traits
[2142288.578] [Gameplay]: Failed Validation.
[2142292.997] [Configuration]: Validating Foreign Key Constraints...
[2142292.998] [Configuration]: Passed Validation.
[2142293.044] [Database] ERROR: FOREIGN KEY constraint failed
[2142293.044] [Database] ERROR: FOREIGN KEY constraint failed
[2142293.599] [FullTextSearch]: FTS - Creating Context
[2142301.366] [FullTextSearch]: FullTextSearch - Shutting down
Basically, what I'm dealing with right now is:
- The District code (in "Districts") failed a "Check" constraint (never heard of that kind of constraint until now)
- There is a single syntax error in my Leader's data file (helpfully listed as "near ,", thanks a lot log file)
- In the same file as above, the Leader Trait and Agenda don't register as existing in "Traits" and "Agendas", despite being perfectly syntaxed and very visibly being in there (I copied and pasted other functioning mods' code for Traits and Agendas to check, still failed)
- Several different Foreign constraint failures
- In my leader's colours file, there were some alternate colour options (as this is for Gathering Storm). the Database.log file, however, listed an error for the file because "Alt1PrimaryColor does not exist in PlayerColors", despite clearly being listed in the Expansion 2 file and other functioning mods
- Previously, there were errors with my district and some related dummy buildings. I switched from using a "INSERT INTO w SELECT x FROM y WHEN z" to a "INSERT INTO w VALUES x" format and suddenly it worked out, despite me putting the same values in the code. This is particularly frustrating because one of these is a replacement for an existing district and the others are meant to be "duplicates" of existing buildings; I would prefer that the values for these dummies could adjust for their real/replaced counterparts