Last resort before Windows reinstall -- fix my Australia

Joined
Apr 9, 2016
Messages
603
Hello,

so, I've almost given up hope at this point, but as this is the main modding hub for Civ VI, I thought I'd give it one last shot before I re-install Windows in order to get my Australia civ working. (For the record, I've reinstalled the game twice, verified the game files in Steam, and run some Windows system diagnostics that were suggested to me by 2K support -- all to no avail so far.)

The problem is simply that if I enable Australia and try to start a new game, at the point where John Curtin is supposed to appear and Sean Bean start his usual tirade about ancient beasts and whatnot, a small text ('Start Game') briefly flashes on the black screen, and then it's back to main menu for yours truly, ad infinitum.

Now, as the latest idea, and to start tinkering with modding as well, I tried to fix the issue by making a mod where I modify the game's database, based on my assumption that the problem lies there. Database.log seems to support this theory, with its reference to the Digger unit:

Spoiler Database.log :

[1095690.940] [Localization]: Validating Foreign Key Constraints...
[1095690.940] [Localization]: Passed Validation.
[1095690.952] [Configuration]: Validating Foreign Key Constraints...
[1095690.953] [Configuration]: Passed Validation.
[1095705.629] [FullTextSearch]: Initializing FullTextSearch
[1095706.472] [Gameplay] ERROR: UNIQUE constraint failed: Kinds.Kind
[1095706.472] [Gameplay]: While executing - 'insert into Kinds('Kind') values (?);'
[1095706.472] [Gameplay]: In XMLSerializer while inserting row into table insert into Kinds('Kind') with values (KIND_UNIT, ).
[1095706.472] [Gameplay]: In XMLSerializer while updating table Kinds from file Units.xml.
[1095706.495] [Gameplay] ERROR: FOREIGN KEY constraint failed
[1095706.496] [Gameplay] ERROR: FOREIGN KEY constraint failed
[1095707.409] [Gameplay] ERROR: UNIQUE constraint failed: Kinds.Kind
[1095707.409] [Gameplay]: While executing - 'insert into Kinds('Kind') values (?);'
[1095707.409] [Gameplay]: In XMLSerializer while inserting row into table insert into Kinds('Kind') with values (KIND_UNIT, ).
[1095707.409] [Gameplay]: In XMLSerializer while updating table Kinds from file Units.xml.
[1095707.434] [Gameplay]: Validating Foreign Key Constraints...
[1095707.447] [Gameplay] ERROR: Invalid Reference on OpTeamRequirements.AiType - "UNITTYPE_AIR_SIEGE" does not exist in UnitAiTypes
[1095707.447] [Gameplay] ERROR: Invalid Reference on OpTeamRequirements.AiType - "UNITTYPE_CIVILIAN_LEADER" does not exist in UnitAiTypes
[1095707.447] [Gameplay] ERROR: Invalid Reference on OpTeamRequirements.AiType - "UNITTYPE_CIVILIAN_LEADER" does not exist in UnitAiTypes
[1095707.447] [Gameplay] ERROR: Invalid Reference on OpTeamRequirements.AiType - "UNITTYPE_CIVILIAN_LEADER" does not exist in UnitAiTypes
[1095707.452] [Gameplay] ERROR: Invalid Reference on TypeTags.Tag - "CLASS_PUSHBACK" does not exist in Tags
[1095707.452] [Gameplay] ERROR: Invalid Reference on TypeTags.Tag - "CLASS_DIGGER" does not exist in Tags
[1095707.454] [Gameplay]: Failed Validation.
[1095708.161] [Configuration]: Validating Foreign Key Constraints...
[1095708.161] [Configuration]: Passed Validation.
[1095726.118] [FullTextSearch]: FTS - Creating Context
[1095735.301] [Gameplay] ERROR: FOREIGN KEY constraint failed
[1095735.301] [Gameplay] ERROR: FOREIGN KEY constraint failed
[1095735.301] [Gameplay]: Validating Foreign Key Constraints...
[1095735.315] [Gameplay] ERROR: Invalid Reference on OpTeamRequirements.AiType - "UNITTYPE_AIR_SIEGE" does not exist in UnitAiTypes
[1095735.315] [Gameplay] ERROR: Invalid Reference on OpTeamRequirements.AiType - "UNITTYPE_CIVILIAN_LEADER" does not exist in UnitAiTypes
[1095735.315] [Gameplay] ERROR: Invalid Reference on OpTeamRequirements.AiType - "UNITTYPE_CIVILIAN_LEADER" does not exist in UnitAiTypes
[1095735.315] [Gameplay] ERROR: Invalid Reference on OpTeamRequirements.AiType - "UNITTYPE_CIVILIAN_LEADER" does not exist in UnitAiTypes
[1095735.320] [Gameplay] ERROR: Invalid Reference on TypeTags.Tag - "CLASS_PUSHBACK" does not exist in Tags
[1095735.320] [Gameplay] ERROR: Invalid Reference on TypeTags.Tag - "CLASS_DIGGER" does not exist in Tags
[1095735.320] [Gameplay] ERROR: Invalid Reference on TypeTags.Tag - "CLASS_DIGGER" does not exist in Tags
[1095735.322] [Gameplay]: Failed Validation.
[1095735.439] [Gameplay] ERROR: near "INSERT": syntax error
[1095735.480] [Gameplay]: Validating Foreign Key Constraints...
[1095735.493] [Gameplay] ERROR: Invalid Reference on OpTeamRequirements.AiType - "UNITTYPE_AIR_SIEGE" does not exist in UnitAiTypes
[1095735.493] [Gameplay] ERROR: Invalid Reference on OpTeamRequirements.AiType - "UNITTYPE_CIVILIAN_LEADER" does not exist in UnitAiTypes
[1095735.493] [Gameplay] ERROR: Invalid Reference on OpTeamRequirements.AiType - "UNITTYPE_CIVILIAN_LEADER" does not exist in UnitAiTypes
[1095735.493] [Gameplay] ERROR: Invalid Reference on OpTeamRequirements.AiType - "UNITTYPE_CIVILIAN_LEADER" does not exist in UnitAiTypes
[1095735.498] [Gameplay] ERROR: Invalid Reference on TypeTags.Tag - "CLASS_PUSHBACK" does not exist in Tags
[1095735.498] [Gameplay] ERROR: Invalid Reference on TypeTags.Tag - "CLASS_DIGGER" does not exist in Tags
[1095735.500] [Gameplay]: Failed Validation.
[1095737.807] [FullTextSearch]: FTS - Creating Context
[1095737.991] [Configuration]: Validating Foreign Key Constraints...
[1095737.992] [Configuration]: Passed Validation.
[1095745.047] [FullTextSearch]: FullTextSearch - Shutting down

These are the lines that I put in my mod:
UPDATE UnitAiTypes INSERT INTO UnitAiTypes (AiType, TypeValue) VALUES ('UNITTYPE_AIR_SIEGE', NULL);
UPDATE UnitAiTypes INSERT INTO UnitAiTypes (AiType, TypeValue) VALUES ('UNITTYPE_CIVILIAN_LEADER', NULL);
UPDATE Tags INSERT INTO Tags (Tag, Vocabulary) VALUES ('CLASS_PUSHBACK', 'ABILITY_CLASS');
UPDATE Tags INSERT INTO Tags (Tag, Vocabulary) VALUES ('CLASS_DIGGER', 'ABILITY_CLASS');
Apparently there's still a syntax error in there somewhere, although I tried to get everything correct. I suppose this is a modding question as well, as I'd like to find out where I went wrong with my typing?

In any case even if I got the mod working as intended, it'd only be a band-aid fix to a more serious issue, because according to my understanding, re-installing the game should wipe out the database and remove any possible errors in it. I suspect it might have something to do with the Windows registry, which is why I'm thinking of re-installing my Windows at this point.

Before I resort to such drastic measures... Your take on it, modding dudes and dudettes of CivFanatics?
:help::coffee:

Regards,
stiiknafuulia
 
Have you removed the files from your "\Documents\my games\Sid Meier's Civilization VI\" folder when reinstalling the game ?
 
Have you removed the files from your "\Documents\my games\Sid Meier's Civilization VI\" folder when reinstalling the game ?
Thanks for your reply. :) Iirc, I did do that with the second reinstall, but I'm only 90 % sure. I'll reinstall again tomorrow and post the result (right now I should be asleep).

EDIT: I couldn't wait 'til tomorrow so I went ahead and reinstalled right away... And HOT DAMN! It actually WORKED!!! :eek: A BIG thanks to you, because this issue has plagued me for at least a month now and I almost went ahead and nuked my Windows on account of it... I might repost this advice on a few Reddit threads if I can still find them, because a few other people have been having similar issues as well. Anyway, now it's a choice between sleep and colonizing Australia on your very own (superbly) modded map... :mischief: This is a much more pleasant problem to have, so again, thank you! :thumbsup:

I do recall deleting the contents of the My Games folder before, but apparently I didn't do it together with a reinstall, meaning that the 'bad stuff' that caused this issue managed to persist in some form at all times (until now, that is). Makes me feel a bit stupid for making such a fuss about it when the fix turned out to be so simple. As I'm studying programming though, it's becoming apparent to me that the simplest fixes are often the ones that are hardest to find.
 
Last edited:
Also make sure there is nothing left in the "\Steam\steamapps\common\Sid Meier's Civilization VI" folder after uninstalling, in case you had installed mods directly there.
 
Sorry for the late reply but I just wanted to mention that just deleting the Cache folder located in "Documents\My Games\Sid Meier's Civilization VI" probably would have solved the problem without reinstalling the game.

Clearing the cache in Civ 5 solved a lot of different mod problems for me so I'm assuming the same situation exists in Civ 6. Hopefully that assumption is correct.
 
OK. Thanks for the information.
 
Back
Top Bottom