Error with TXT in XML

[Elmdor]

I've been working on a custom civilization. I've looked around and searched for a few days, and I've fixed several bugs thanks to these forums and various posts. But there is one problem I can't fix, and can't find a post that fies it.

All of my txt_key entries show up as the full string, not the appropriate text. I tried a fix I found at The 2K Forums , which was posted by a Firaxis programmer. The post is here:

Spoiler :

Another option would be to use the <Replace> tag in your XML as this translates to an "INSERT OR REPLACE INTO" SQL prefix. This tends to be safer since it will not result in errors if the key already exists and will ensure that your value is used.

In hindsight, the <Row> tag should probably translate into a "INSERT OR IGNORE" instead of a "INSERT INTO" SQL prefix in order to prevent such errors.

I've tried fixing it as if it were a duplicate entry, but this wasn't the case either. So I enabled logging, and here is what the log file says: (the SB in the tag was my testing for duplicate entry, and this log is with the Replace tag)

Spoiler :

[286623.273] Database::XMLSerializer (GameText.xml): Duplicate column names detected in <Row>. Name: Row, Value:
[286641.821] Validating Foreign Key Constraints...
[286642.009] Invalid Reference on Buildings.Help - "TXT_KEY_SB_BUILDING_SENTAI_DOJO_HELP" does not exist in Language_en_US
[286642.087] Invalid Reference on Buildings.Strategy - "TXT_KEY_SB_BUILDING_BARRACKS_STRATEGY" does not exist in Language_en_US
[286642.227] Invalid Reference on Buildings.Description - "TXT_KEY_SB_BUILDING_SENTAI_DOJO_HELP" does not exist in Language_en_US
[286642.305] Invalid Reference on Civilizations.Adjective - "TXT_KEY_SB_CIV_AZAI_ADJECTIVE" does not exist in Language_en_US
[286642.383] Invalid Reference on Civilizations.ShortDescription - "TXT_KEY_SB_CIV_AZAI_SHORT_DESC" does not exist in Language_en_US
[286642.461] Invalid Reference on Civilizations.Description - "TXT_KEY_SB_CIV_AZAI_DESC" does not exist in Language_en_US
[286642.539] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_ODANI" does not exist in Language_en_US
[286642.539] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_IMAHORI" does not exist in Language_en_US
[286642.539] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_KOGA" does not exist in Language_en_US
[286642.539] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_OMI" does not exist in Language_en_US
[286642.539] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_KOHOKU" does not exist in Language_en_US
[286642.539] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_EIGENJI" does not exist in Language_en_US
[286642.539] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_ECHIGAWA" does not exist in Language_en_US
[286642.539] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_KOTO" does not exist in Language_en_US
[286642.539] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_NISHIAZAI" does not exist in Language_en_US
[286642.539] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_IMAZU" does not exist in Language_en_US

Here is the log, without the Replace tag:

Spoiler :

[287496.691] constraint failed
[287496.691] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[287496.691] In XMLSerializer while inserting row into table Language_en_US('Tag', 'Text') with values (TXT_KEY_SB_CITY_NAME_SUKUMO, SUKUMO, ).
[287496.691] In XMLSerializer while updating table Language_en_US from file GameText.xml.
[287496.691] columns Language, Tag are not unique
[287512.182] Validating Foreign Key Constraints...
[287512.385] Invalid Reference on Buildings.Help - "TXT_KEY_SB_BUILDING_SENTAI_DOJO_HELP" does not exist in Language_en_US
[287512.479] Invalid Reference on Buildings.Strategy - "TXT_KEY_SB_BUILDING_BARRACKS_STRATEGY" does not exist in Language_en_US
[287512.650] Invalid Reference on Buildings.Description - "TXT_KEY_SB_BUILDING_SENTAI_DOJO_HELP" does not exist in Language_en_US
[287512.744] Invalid Reference on Civilizations.Adjective - "TXT_KEY_SB_CIV_AZAI_ADJECTIVE" does not exist in Language_en_US
[287512.822] Invalid Reference on Civilizations.ShortDescription - "TXT_KEY_SB_CIV_AZAI_SHORT_DESC" does not exist in Language_en_US
[287512.915] Invalid Reference on Civilizations.Description - "TXT_KEY_SB_CIV_AZAI_DESC" does not exist in Language_en_US
[287513.009] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_ODANI" does not exist in Language_en_US
[287513.009] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_IMAHORI" does not exist in Language_en_US
[287513.009] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_KOGA" does not exist in Language_en_US
[287513.009] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_OMI" does not exist in Language_en_US
[287513.009] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_KOHOKU" does not exist in Language_en_US
[287513.009] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_EIGENJI" does not exist in Language_en_US
[287513.009] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_ECHIGAWA" does not exist in Language_en_US
[287513.009] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_KOTO" does not exist in Language_en_US
[287513.009] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_NISHIAZAI" does not exist in Language_en_US
[287513.009] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_SB_CITY_NAME_IMAZU" does not exist in Language_en_US

If needed, I can post my Actions tab, and anything else.

 

[Spatzimaus]

[287496.691] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[287496.691] In XMLSerializer while inserting row into table Language_en_US('Tag', 'Text') with values (TXT_KEY_SB_CITY_NAME_SUKUMO, SUKUMO, ).

This one looks to be the problem. Post the exact XML syntax you're using for this one; you've probably just made a typo in that line.

If it's not that line, then the only way you're going to be able to help you is if you attach your mod's files to a post, zipped up, INCLUDING the .modinfo file. But let's check that one entry first.

 

[Putmalk]

Adding on to Spatz's post, if you put all of the text strings into one file, then if there is one syntax error the whole file will fail.

Shouldn't be too hard to fix, just scour for an oddity. Maybe two strings are marked the same name? That will cause it to fail as well.

 

[Elmdor]

Thanks guys! That was the one glaring error, and it fixed the majority of the TXT_KEY problems. I had two of the civs both using Sukumo as a city. It's tough to find enough different city names for a Sengoku era mod. :/