stiiknafuulia
King
- 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:
[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:
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?


Regards,
stiiknafuulia
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:
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?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');
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?


Regards,
stiiknafuulia