Installed Base & Modern age patch, using Vortex MM. Started new game. Suspected something amiss when only available Momentos where those I'd unlocked in base gameplay. Launch gave error: Gameplay DB Failed Validation. Located these error lines in the DB.Log. Please advise. [gameplay] ERROR: FOREIGN KEY constraint failed[2025-05-24 16:47:43][gameplay] ERROR: FOREIGN KEY constraint failed[2025-05-24 16:47:43][gameplay]: Validating Foreign Key Constraints...[2025-05-24 16:47:43][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "LAFAYETTE_MOD_COMBAT_ABILITY_DISTANT_LANDS" does not exist in Modifiers[2025-05-24 16:47:43][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "LAFAYETTE_MOD_COMBAT_ABILITY_HOMELANDS" does not exist in Modifiers[2025-05-24 16:47:43][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "AHUPUA_A_MOD_FOOD_BUILDING_CULTURE" does not exist in Modifiers[2025-05-24 16:47:43][gameplay]: Failed Validation.[2025-05-24 16:47:43][gameplay]: Rebuilding database.[2025-05-24 16:47:43][localization]: Rebuilding database.[2025-05-24 16:47:43][localization]: StartupErrorMessages.xml[2025-05-24 16:47:43][localization]: Database XML root elements must start with either <Database> or <GameEffects>.
1. Go to mod install folder (C:\Users\you\AppData\Local\Firaxis Games\Sid Meier's Civilization VII\Mods\modules) 2. open traditions.xml, delete the following line "AHUPUA_A_MOD_FOOD_BUILDING_CULTURE". I think it was 66, didn't check before lol 3. open leaders.xml, delete the following lines "LAFAYETTE_MOD_COMBAT_ABILITY_DISTANT_LANDS" and "LAFAYETTE_MOD_COMBAT_ABILITY_HOMELANDS". I think they were 67 and 68 iirc, but just read it to double check
make sure you delete the entire line and save. it should work
Thanks duffb, I did what you suggested and the game launched OK. However, in the setup screens the only selectable Momentos were still limited to those I'd unlocked through normal game play. Are you seeing the same?
The mods works well for the two first ages, but still crashes in the modern age. I was using Charlemagne and Great Britain, and then also tried with the U.S. Both get the validation error and crash to main menu.
Hello First thanks for this mod. Worked fine until today but now i can't create new game, could you update please.
Thank you
If that can hel you, i copy the error message from databse.log [2025-03-04 19:25:44][localization]: Rebuilding database. [2025-03-04 19:25:44][localization]: StartupErrorMessages.xml [2025-03-04 19:25:44][localization]: Database XML root elements must start with either <Database> or <GameEffects>. [2025-03-04 19:25:44][gameplay]: Rebuilding database. [2025-03-04 19:25:44][HallofFame]: UpdateAggregateDataPoints took 0.084428 seconds. [2025-03-04 19:25:48][gameplay] ERROR: FOREIGN KEY constraint failed [2025-03-04 19:25:48][gameplay] ERROR: FOREIGN KEY constraint failed [2025-03-04 19:25:48][gameplay]: Validating Foreign Key Constraints... [2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_HATSHEPSUT_URAEUS_MODIFIER_1" does not exist in Modifiers [2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_HATSHEPSUT_URAEUS_MODIFIER_2" does not exist in Modifiers [2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_BATTUTA_MERCHANTS_SADDLE_MODIFIER_5" does not exist in Modifiers [2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_BATTUTA_MERCHANTS_SADDLE_MODIFIER_6" does not exist in Modifiers [2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_ISABELLA_PADRON_REAL_MODIFIER_1" does not exist in Modifiers [2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_ISABELLA_PADRON_REAL_MODIFIER_2" does not exist in Modifiers [2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_TRUNG_DONG_SON_DRUM_MODIFIER_1" does not exist in Modifiers [2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_TRUNG_DONG_SON_DRUM_MODIFIER_2" does not exist in Modifiers [2025-03-04 19:25:48][gameplay]: Failed Validation.
I couldn’t use this mode because of the same issue. But now, I’ve fixed it. This can be easily solved. However, I’m not sure exactly how this fix affects the game. You might not be able to use this mode fully. Nevertheless, if you still want to use this mode, try modifying it as follows.
Try deleting the following lines in the mementos.xml file
Heya! 1st wanted to say thank you for making a mod for Civ7. I tried installing in the Mods folder but when I enable it in the main menu of the game, it causing the game to crash. I have just the base game and I was using the "Base Game" file. Am I missing something and did I do something wrong? Any other players got this to work for just the base game?
67 comments
I'd like to download this mod for version 1.0.1, but I can't find it in the archives.
How can I obtain it?
Many thanks.
[gameplay] ERROR: FOREIGN KEY constraint failed[2025-05-24 16:47:43][gameplay] ERROR: FOREIGN KEY constraint failed[2025-05-24 16:47:43][gameplay]: Validating Foreign Key Constraints...[2025-05-24 16:47:43][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "LAFAYETTE_MOD_COMBAT_ABILITY_DISTANT_LANDS" does not exist in Modifiers[2025-05-24 16:47:43][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "LAFAYETTE_MOD_COMBAT_ABILITY_HOMELANDS" does not exist in Modifiers[2025-05-24 16:47:43][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "AHUPUA_A_MOD_FOOD_BUILDING_CULTURE" does not exist in Modifiers[2025-05-24 16:47:43][gameplay]: Failed Validation.[2025-05-24 16:47:43][gameplay]: Rebuilding database.[2025-05-24 16:47:43][localization]: Rebuilding database.[2025-05-24 16:47:43][localization]: StartupErrorMessages.xml[2025-05-24 16:47:43][localization]: Database XML root elements must start with either <Database> or <GameEffects>.
1. Go to mod install folder (C:\Users\you\AppData\Local\Firaxis Games\Sid Meier's Civilization VII\Mods\modules)
2. open traditions.xml, delete the following line "AHUPUA_A_MOD_FOOD_BUILDING_CULTURE". I think it was 66, didn't check before lol
3. open leaders.xml, delete the following lines "LAFAYETTE_MOD_COMBAT_ABILITY_DISTANT_LANDS" and "LAFAYETTE_MOD_COMBAT_ABILITY_HOMELANDS". I think they were 67 and 68 iirc, but just read it to double check
make sure you delete the entire line and save. it should work
Or did I miss something?
PS. Thanks for all your work!
Ingame : it says “Content configuration validating failed”
database.log:
[2025-03-06 00:55:58][gameplay] ERROR: UNIQUE constraint failed: MementoModifiers.MementoType, MementoModifiers.ModifierId
[2025-03-06 00:55:58][gameplay]: While executing - 'insert into MementoModifiers('MementoType', 'ModifierId') values ('MEMENTO_FOUNDATION_EA_NASIR', 'MEMENTO_FOUNDATION_EA_NASIR_MODIFIER');'
[2025-03-06 00:55:58][gameplay]: In XMLSerializer while inserting row into table insert into MementoModifiers('MementoType', 'ModifierId') with values (MEMENTO_FOUNDATION_EA_NASIR, MEMENTO_FOUNDATION_EA_NASIR_MODIFIER, ).
[2025-03-06 00:55:58][gameplay]: In XMLSerializer while updating table MementoModifiers from file mementos.xml.
[2025-03-06 00:55:58][gameplay] ERROR: UNIQUE constraint failed: MementoModifiers.MementoType, MementoModifiers.ModifierId
[2025-03-06 00:55:58][gameplay]: Rebuilding database.
[2025-03-06 00:55:58][localization]: Rebuilding database.
[2025-03-06 00:55:58][localization]: StartupErrorMessages.xml
[2025-03-06 00:55:58][localization]: Database XML root elements must start with either <Database> or <GameEffects>.
[2025-03-06 00:55:59][frontend]: Rebuilding database.
[2025-03-06 00:55:59][frontend]: Validating Foreign Key Constraints...
[2025-03-06 00:55:59][frontend]: Passed Validation.
[2025-03-06 00:55:59][HallofFame]: UpdateAggregateDataPoints took 0.022275 seconds.
Edit. Fixed and working for me at least
TRAIT_MOD_ITSAPHARAHAB
toTRAIT_MOD_ITSARAPHAB
change that on the last line of civilizations-modern.xml and it'll work for modern ages again
- Never mind, it does with the patch
First thanks for this mod. Worked fine until today but now i can't create new game, could you update please.
Thank you
If that can hel you, i copy the error message from databse.log
[2025-03-04 19:25:44][localization]: Rebuilding database.
[2025-03-04 19:25:44][localization]: StartupErrorMessages.xml
[2025-03-04 19:25:44][localization]: Database XML root elements must start with either <Database> or <GameEffects>.
[2025-03-04 19:25:44][gameplay]: Rebuilding database.
[2025-03-04 19:25:44][HallofFame]: UpdateAggregateDataPoints took 0.084428 seconds.
[2025-03-04 19:25:48][gameplay] ERROR: FOREIGN KEY constraint failed
[2025-03-04 19:25:48][gameplay] ERROR: FOREIGN KEY constraint failed
[2025-03-04 19:25:48][gameplay]: Validating Foreign Key Constraints...
[2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_HATSHEPSUT_URAEUS_MODIFIER_1" does not exist in Modifiers
[2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_HATSHEPSUT_URAEUS_MODIFIER_2" does not exist in Modifiers
[2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_BATTUTA_MERCHANTS_SADDLE_MODIFIER_5" does not exist in Modifiers
[2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_BATTUTA_MERCHANTS_SADDLE_MODIFIER_6" does not exist in Modifiers
[2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_ISABELLA_PADRON_REAL_MODIFIER_1" does not exist in Modifiers
[2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_ISABELLA_PADRON_REAL_MODIFIER_2" does not exist in Modifiers
[2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_TRUNG_DONG_SON_DRUM_MODIFIER_1" does not exist in Modifiers
[2025-03-04 19:25:48][gameplay] ERROR: Invalid Reference on MementoModifiers.ModifierId - "MEMENTO_TRUNG_DONG_SON_DRUM_MODIFIER_2" does not exist in Modifiers
[2025-03-04 19:25:48][gameplay]: Failed Validation.
Try deleting the following lines in the mementos.xml file
"MEMENTO_HATSHEPSUT_URAEUS_MODIFIER_1"
"MEMENTO_HATSHEPSUT_URAEUS_MODIFIER_2"
"MEMENTO_BATTUTA_MERCHANTS_SADDLE_MODIFIER_5"
"MEMENTO_BATTUTA_MERCHANTS_SADDLE_MODIFIER_6"
"MEMENTO_ISABELLA_PADRON_REAL_MODIFIER_1"
"MEMENTO_ISABELLA_PADRON_REAL_MODIFIER_2"
"MEMENTO_TRUNG_DONG_SON_DRUM_MODIFIER_1"
"MEMENTO_TRUNG_DONG_SON_DRUM_MODIFIER_2"
I'm just planning to use it this way until the mod creator uploads a fully intact file.