Help interpereting a Database file

Mikhaelstan

Chieftain
Joined
Dec 10, 2016
Messages
18
Hello everyone. I'm new to modding and currently trying to get what I've made to show up in civilization selection screen. I've looked at the Database file and I have the following errors.

'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'

While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values TXT_KEY_CIV5_UNITEDSTATES_FACTOID_HEADING, , ).
In XMLSerializer while updating table Language_en_US from file XML/Civilization.xml.
columns Language, Tag are not unique
columns Language, Tag are not unique


While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_CIVILOPEDIA_LEADERS_GEORGE_FACT_1, Like many Americans today, DUNSTAN had a fondness for ice cream - he even had a cooler installed in his house to better enjoy the treat., ).
In XMLSerializer while updating table Language_en_US from file XML/Leader.xml.
columns Language, Tag are not unique

If someone could provide pointers on what they are telling me and if they are the root cause for my aforementioned problem that would be great.
 

Attachments

  • Mike_Database.zip
    1.2 KB · Views: 43
TXT_KEY_CIV5_UNITEDSTATES_FACTOID_HEADING & TXT_KEY_CIVILOPEDIA_LEADERS_GEORGE_FACT_1 already exist within the game. You cannot attempt to re-define them by doing:
Code:
<Language_en_US>
     <Row Tag="TXT_KEY_CIV5_UNITEDSTATES_FACTOID_HEADING" >
          <Text>Blah de Blah</Text>
     </Row>
</Language_en_US>
You would have to use update structure to alter the <Text> to be used for tag-name TXT_KEY_CIV5_UNITEDSTATES_FACTOID_HEADING.

But if you are adding a new civilization, you really need to alter the name of the Tag to something new and original from TXT_KEY_CIV5_UNITEDSTATES_FACTOID_HEADING & TXT_KEY_CIVILOPEDIA_LEADERS_GEORGE_FACT_1.
 
Thanks for the reply. I've fixed the factoid problem but I still can't get my mod to show up in the selection list even when its an activated mod.
Below is the contents of the Database file, if someone could walk me through what it's saying and what I need to do it would be much appreciated.

Spoiler :

[75408.906] columns StrategicViewType, TileType are not unique
[75408.921] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[75411.296] no such table: ContentPackage.LocalizedText
[75411.296] no such table: ContentPackage.LocalizedText
[75411.296] no such table: ContentPackage.LocalizedText
[75412.328] no such table: ContentPackage.LocalizedText
[75414.265] columns StrategicViewType, TileType are not unique
[75414.265] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[75415.046] no such table: ContentPackage.LocalizedText
[75415.046] no such table: ContentPackage.LocalizedText
[75415.046] no such table: ContentPackage.LocalizedText
[75419.484] Validating Foreign Key Constraints...
[75419.484] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75419.484] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75419.484] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75419.484] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75419.484] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75419.484] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75419.484] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75419.484] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75419.484] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75422.062] Failed Validation.
[75422.515]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 7464072 77014144
PageCache: 6 12
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 7041888 64114344
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 6
------------------------------
[75422.546] Validating Foreign Key Constraints...
[75422.546] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75422.546] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75422.546] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75422.546] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75422.546] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75422.546] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75422.546] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75422.546] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75422.546] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75425.093] Failed Validation.
[75425.546]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 7465248 77014144
PageCache: 6 12
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 7043064 64114344
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 6
------------------------------
[75451.234] Database::XMLSerializer (XML/CivilizationB.xml): 'Row' or 'Delete' expected, got 'Text'.
[75452.062] Validating Foreign Key Constraints...
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75453.015] Invalid Reference on Leader_Traits.TraitType - "TRAIT_DUNSTAN_DECADE" does not exist in Traits
[75454.656] Failed Validation.
[75455.109]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 7483840 77014144
PageCache: 7 13
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 7057176 64114344
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 8
------------------------------
[75487.093] columns StrategicViewType, TileType are not unique
[75487.093] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[75487.859] no such table: ContentPackage.LocalizedText
[75487.859] no such table: ContentPackage.LocalizedText
[75487.875] no such table: ContentPackage.LocalizedText
[75492.328] Validating Foreign Key Constraints...
[75492.328] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75492.328] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75492.328] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75492.328] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75492.328] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75492.328] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75492.328] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75492.328] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75492.328] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75494.890] Failed Validation.
[75495.359]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 7474384 77014144
PageCache: 6 13
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 7047768 64120224
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 8
------------------------------

 
[75451.234] Database::XMLSerializer (XML/CivilizationB.xml): 'Row' or 'Delete' expected, got 'Text'.
[75452.062] Validating Foreign Key Constraints...
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75452.078] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[75453.015] Invalid Reference on Leader_Traits.TraitType - "TRAIT_DUNSTAN_DECADE" does not exist in Traits
[75454.656] Failed Validation.
[75455.109]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 7483840 77014144
PageCache: 7 13
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 7057176 64114344
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 8
First of all, you have multiple 'log-entries' linked in the spoiler, so I'm giong to assume this one was the one you meant since it contained some errors that specifically stood out to me.
The things marked in red are the errors that normally do not appear in the log-file. I'm pretty sure the other errors always appear.

The top one usually means that you forgot to insert <row> tags.
The bottom error means that you did not define 'TRAIT_DUNSTAN_DECADE", which in many cases means you made a typo somewhere.

I'd recommend you to disable all mods, and check the log-file, which then will contain all 'normal errors' (i.e. the errors that appear even without your mod).
Then enable your mod, and compare the new log-file to the old one. Every duplicate 'error' are the ones that are unimportant.
 
Top Bottom