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:
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)
Here is the log, without the Replace tag:
If needed, I can post my Actions tab, and anything else.
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.
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
[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
[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.