TXT_KEY not replaced

Deathoverride

Chieftain
Joined
Feb 5, 2017
Messages
9
Hi everyone !

I am new in modding. I have followed various tutorial to build my own civilization (including the "bible" on this forum). I managed to get everything working fine but I still have one problem I can't get rid off.

I mod in XML (+dds files) and all my TXT_KEY_BLABLABLA are not replaced in game just like if my GameText.xml is not taken into account. I put it "onModActivated=>UpdateDatabase" and first on list.
I checked all the keys in GameText.xml and all matches at least on time in other files (no key stand alone).

My game is in French, so I tested both <Language_FR_FR> and <Language_en_US>, and tried to update privatly on steam but still doesn't work.

I have no idea of what is wrong in the mod... Have you any idea ? (Or maybe a link for another thread which answer the question if I did not search well)


Code:
<?xml version="1.0" encoding="utf-8"?>
<!-- Created by ModBuddy on 1/22/2017 6:48:52 PM -->
<GameData>
    <Language_FR_FR>               
            <Row Tag="TXT_KEY_CITY_NAME_STGILLE">
                <Text>StGilles</Text>
            </Row>
            <Row Tag="TXT_KEY_CITY_NAME_NIMES">
                <Text>Nimes</Text>
            </Row>
            <Row Tag="TXT_KEY_CITY_NAME_AIGUEMORTE">
                <Text>AigueMorte</Text>
            </Row>
            <Row Tag="TXT_KEY_CITY_NAME_STLAURENT">
                <Text>StLaurent</Text>
            </Row>
            <Row Tag="TXT_KEY_CIV_RAGOR_ADJECTIVE">
                <Text>Ragorien</Text>
            </Row>
            <Row Tag="TXT_KEY_CIV_RAGOR_DESC">
                <Text>Ragoria</Text>
            </Row>
            <Row Tag="TXT_KEY_CIV_RAGOR_SHORT_DESC">
                <Text>Ragor</Text>
            </Row>
            <Row Tag="TXT_KEY_CIV5_RAGOR_TEXT_1">
                <Text>L'ordre de ragor remonte à la nuit des temps. Ce sont des survivants. Ils savent utiliser leur environnement pour s'assurer un avenir radieu. Doué dans la formation d'unités, ils disposent de soldats bien entrainés et d'un arsenal à toute épreuve.</Text>
            </Row>           
            <Row Tag="TXT_KEY_LEADER_BERTRAND">
                <Text>Bertrand</Text>
            </Row>
            <Row Tag="TXT_KEY_TRAIT_BATTLE_FURY">
                <Text>Melee, Mounted and Gun units can make 2 attacks per round.</Text>
            </Row>
            <Row Tag="TXT_KEY_TRAIT_BATTLE_FURY_SHORT">
                <Text>Battle Fury</Text>
            </Row>
            <Row Tag="TXT_KEY_UNIT_GAELIC_WARRIOR">
                <Text>Gaelic Warrior</Text>
            </Row>
            <Row Tag="TXT_KEY_UNIT_HELP_GAELIC_WARRIOR">
                <Text>This unit's ability to ignore terrain allows it to quickly rush into enemy lands.</Text>
            </Row>
        </Language_FR_FR>
    </GameData>


Code:
<?xml version="1.0" encoding="utf-8"?>
<!-- Created by ModBuddy on 1/22/2017 6:44:18 PM -->
<GameData>
    <Civilizations>
        <Row>
            <Type>CIVILIZATION_RAGOR</Type>
            <Description>TXT_KEY_CIV_RAGOR_DESC</Description>
            <ShortDescription>TXT_KEY_CIV_RAGOR_SHORT_DESC</ShortDescription>
            <Adjective>TXT_KEY_CIV_RAGOR_ADJECTIVE</Adjective>           
            <DefaultPlayerColor>PLAYERCOLOR_DARK_GREEN</DefaultPlayerColor>
            <ArtStyleType>ARTSTYLE_EUROPEAN</ArtStyleType>
            <ArtStyleSuffix>_EURO</ArtStyleSuffix>
            <ArtStylePrefix>EUROPEAN</ArtStylePrefix>
            <PortraitIndex>0</PortraitIndex>
            <IconAtlas>CIV_COLOR_ATLAS_LEGENDS</IconAtlas>
            <AlphaIconAtlas>CIV_ALPHA_ATLAS</AlphaIconAtlas>
            <MapImage>MapEngland512.dds</MapImage>
            <DawnOfManQuote>TXT_KEY_CIV5_RAGOR_TEXT_1</DawnOfManQuote>
            <DawnOfManImage>BertrandDOM.dds</DawnOfManImage>
        </Row>
    </Civilizations>
    <Civilization_CityNames>
        <Row>
            <CivilizationType>CIVILIZATION_RAGOR</CivilizationType>
            <CityName>TXT_KEY_CITY_NAME_STGILLE</CityName>
        </Row>
        <Row>
            <CivilizationType>CIVILIZATION_RAGOR</CivilizationType>
            <CityName>TXT_KEY_CITY_NAME_NIMES</CityName>
        </Row>
        <Row>
            <CivilizationType>CIVILIZATION_RAGOR</CivilizationType>
            <CityName>TXT_KEY_CITY_NAME_AIGUEMORTE</CityName>
        </Row>
        <Row>
            <CivilizationType>CIVILIZATION_RAGOR</CivilizationType>
            <CityName>TXT_KEY_CITY_NAME_STLAURENT</CityName>
        </Row>
    </Civilization_CityNames>
    <Civilization_FreeBuildingClasses>
        <Row>
            <CivilizationType>CIVILIZATION_RAGOR</CivilizationType>
            <BuildingClassType>BUILDINGCLASS_PALACE</BuildingClassType>
        </Row>
    </Civilization_FreeBuildingClasses>
    <Civilization_FreeTechs>
        <Row>
            <CivilizationType>CIVILIZATION_RAGOR</CivilizationType>
            <TechType>TECH_AGRICULTURE</TechType>
        </Row>
    </Civilization_FreeTechs>
    <Civilization_FreeUnits>
        <Row>
            <CivilizationType>CIVILIZATION_RAGOR</CivilizationType>
            <UnitClassType>UNITCLASS_SETTLER</UnitClassType>
            <Count>1</Count>
            <UnitAIType>UNITAI_SETTLE</UnitAIType>
        </Row>
    </Civilization_FreeUnits>
    <Civilization_Leaders>
        <Row>
            <CivilizationType>CIVILIZATION_RAGOR</CivilizationType>
            <LeaderheadType>LEADER_BERTRAND</LeaderheadType>
        </Row>
    </Civilization_Leaders>
    <Civilization_Start_Region_Priority>
        <Row>
            <CivilizationType>CIVILIZATION_RAGOR</CivilizationType>
            <RegionType>REGION_FOREST</RegionType>
        </Row>
    </Civilization_Start_Region_Priority>
    <Civilization_UnitClassOverrides>
        <Row>
            <CivilizationType>CIVILIZATION_RAGOR</CivilizationType>
            <UnitClassType>UNITCLASS_WARRIOR</UnitClassType>
            <UnitType>UNIT_GAELIC_WARRIOR</UnitType>
        </Row>
    </Civilization_UnitClassOverrides>
    <Civilization_UnitClassOverrides>
        <Row>
            <CivilizationType>CIVILIZATION_RAGOR</CivilizationType>
            <UnitClassType>UNITCLASS_MECHANIZED_INFANTRY</UnitClassType>
            <UnitType>UNIT_RUSSIAN_COSSACK</UnitType>
        </Row>
    </Civilization_UnitClassOverrides>
    
</GameData>
 

Attachments

  • Ragor civilization.rar
    2.3 MB · Views: 82
Thank you for your answer. It seems indeed there are a problem with de database. It say that some keys does not exist in Language_en_US (well this is why i am creating them basicaly).

Code:
[105596.640] columns StrategicViewType, TileType are not unique
[105596.640] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[105597.703] no such table: ContentPackage.LocalizedText
[105597.703] no such table: ContentPackage.LocalizedText
[105597.703] no such table: ContentPackage.LocalizedText
[105598.453] no such table: ContentPackage.LocalizedText
[105599.390] columns StrategicViewType, TileType are not unique
[105599.390] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[105599.937] no such table: ContentPackage.LocalizedText
[105599.937] no such table: ContentPackage.LocalizedText
[105599.937] no such table: ContentPackage.LocalizedText
[105602.843] Validating Foreign Key Constraints...
[105602.843] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105602.843] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105602.843] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105602.843] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105602.843] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105602.843] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105602.843] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105602.843] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105602.843] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105604.781] Failed Validation.
[105605.140]
-- SQLite Memory Statistics --
Memory Usage:
        [Cur]        [Max]
Malloc:        6242848        81350320
PageCache:    6        12
LookAside:    0        0
Scratch:    0        1

Static Buffer Overflows:
        [TooLarge]    [NoSpace]
PageCache:    5825904        67491816
Scratch:    0        0

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

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

Static Buffer Overflows:
        [TooLarge]    [NoSpace]
PageCache:    5827080        67491816
Scratch:    0        0

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

Prepared Statements:
Current:        6
------------------------------
[105662.015] columns Language, Tag are not unique
[105662.015] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[105662.015] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with  values (TXT_KEY_CITY_NAME_NIMES, Nimes, ).
[105662.015] In XMLSerializer while updating table Language_en_US from file XML/NewText/BertrandText.xml.
[105662.015] columns Language, Tag are not unique
[105662.640] Validating Foreign Key Constraints...
[105662.640] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105662.640] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105662.640] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105662.640] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105662.640] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105662.640] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105662.640] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105662.640] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105662.640] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[105662.875] Invalid Reference on Civilizations.Adjective - "TXT_KEY_CIV_RAGOR_ADJECTIVE" does not exist in Language_en_US
[105662.890] Invalid Reference on Civilizations.ShortDescription - "TXT_KEY_CIV_RAGOR_SHORT_DESC" does not exist in Language_en_US
[105662.921] Invalid Reference on Civilizations.Description - "TXT_KEY_CIV_RAGOR_DESC" does not exist in Language_en_US
[105662.953] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_STGILLE" does not exist in Language_en_US
[105662.953] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_AIGUEMORTE" does not exist in Language_en_US
[105662.953] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_STLAURENT" does not exist in Language_en_US
[105663.140] Invalid Reference on Traits.ShortDescription - "TXT_KEY_TRAIT_BATTLE_FURY_SHORT" does not exist in Language_en_US
[105663.171] Invalid Reference on Traits.Description - "TXT_KEY_TRAIT_BATTLE_FURY" does not exist in Language_en_US
[105663.984] Invalid Reference on Units.Help - "TXT_KEY_UNIT_HELP_GAELIC_WARRIOR" does not exist in Language_en_US
[105664.078] Invalid Reference on Units.Description - "TXT_KEY_UNIT_GAELIC_WARRIOR" does not exist in Language_en_US
[105664.593] Failed Validation.
[105664.953]
-- SQLite Memory Statistics --
Memory Usage:
        [Cur]        [Max]
Malloc:        6430736        81350320
PageCache:    7        13
LookAside:    0        0
Scratch:    0        1

Static Buffer Overflows:
        [TooLarge]    [NoSpace]
PageCache:    6009360        67491816
Scratch:    0        0

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

Prepared Statements:
Current:        8
------------------------------
 
From what I'm seeing in your mod, you are only creating the text keys in the Language_FR_FR data base, not the Language_en_US.

I'm no expert, but it looks like to me, your game configuration settings are set to using US English as the localization setting. That's why you're seeing all those "Invalid Reference" errors - the text keys exist in the Language_FR_FR data base, but the game doesn't see them? Am not completely sure how the localization.db uses these settings so it may be some other problem.

You may want to look into this and make sure your game is set to use French instead of English. If you want it to stay in English, use the Language_en_US setting in your GameText.xml file and see if that helps.
 
I've just tried this text.xml and switch my game to english language, still get these log error :confused:


Code:
<?xml version="1.0" encoding="utf-8"?>
<!-- Created by ModBuddy on 7/15/2014 2:15:12 PM -->
<GameData>
    <Language_en_US>
        <Row Tag="TXT_KEY_CITY_NAME_STGILLE">
            <Text>StGilles</Text>
        </Row>
        <Row Tag="TXT_KEY_CITY_NAME_NIMES">
            <Text>Nimes</Text>
        </Row>
        <Row Tag="TXT_KEY_CITY_NAME_AIGUEMORTE">
            <Text>AigueMorte</Text>
        </Row>
        <Row Tag="TXT_KEY_CITY_NAME_STLAURENT">
            <Text>StLaurent</Text>
        </Row>
        <Row Tag="TXT_KEY_CIV_RAGOR_ADJECTIVE">
            <Text>Ragorien</Text>
        </Row>
        <Row Tag="TXT_KEY_CIV_RAGOR_DESC">
            <Text>Ragoria</Text>
        </Row>
        <Row Tag="TXT_KEY_CIV_RAGOR_SHORT_DESC">
            <Text>Ragor</Text>
        </Row>
        <Row Tag="TXT_KEY_CIV5_RAGOR_TEXT_1">
            <Text>L'ordre de ragor remonte à la nuit des temps. Ce sont des survivants. Ils savent utiliser leur environnement pour s'assurer un avenir radieu. Doué dans la formation d'unités, ils disposent de soldats bien entrainés et d'un arsenal à toute épreuve.</Text>
        </Row>
        <Row Tag="TXT_KEY_LEADER_BERTRAND">
            <Text>Bertrand</Text>
        </Row>
        <Row Tag="TXT_KEY_TRAIT_BATTLE_FURY">
            <Text>Melee, Mounted and Gun units can make 2 attacks per round.</Text>
        </Row>
        <Row Tag="TXT_KEY_TRAIT_BATTLE_FURY_SHORT">
            <Text>Battle Fury</Text>
        </Row>
        <Row Tag="TXT_KEY_UNIT_GAELIC_WARRIOR">
            <Text>Gaelic Warrior</Text>
        </Row>
        <Row Tag="TXT_KEY_UNIT_HELP_GAELIC_WARRIOR">
            <Text>This unit's ability to ignore terrain allows it to quickly rush into enemy lands.</Text>
        </Row>
    </Language_en_US>
</GameData>


Code:
[107895.562] columns StrategicViewType, TileType are not unique
[107895.562] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[107896.625] no such table: ContentPackage.LocalizedText
[107896.625] no such table: ContentPackage.LocalizedText
[107896.625] no such table: ContentPackage.LocalizedText
[107897.375] no such table: ContentPackage.LocalizedText
[107898.250] columns StrategicViewType, TileType are not unique
[107898.250] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[107898.781] no such table: ContentPackage.LocalizedText
[107898.781] no such table: ContentPackage.LocalizedText
[107898.781] no such table: ContentPackage.LocalizedText
[107901.703] Validating Foreign Key Constraints...
[107901.703] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107901.703] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107901.703] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107901.703] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107901.703] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107901.703] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107901.703] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107901.703] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107901.703] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107903.656] Failed Validation.
[107904.000]
-- SQLite Memory Statistics --
Memory Usage:
        [Cur]        [Max]
Malloc:        6240944        75803296
PageCache:    6        12
LookAside:    0        0
Scratch:    0        1

Static Buffer Overflows:
        [TooLarge]    [NoSpace]
PageCache:    5825904        62898360
Scratch:    0        0

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

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

Static Buffer Overflows:
        [TooLarge]    [NoSpace]
PageCache:    5827080        62898360
Scratch:    0        0

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

Prepared Statements:
Current:        6
------------------------------
[107931.015] columns Language, Tag are not unique
[107931.015] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[107931.015] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with  values (TXT_KEY_CITY_NAME_NIMES, Nimes, ).
[107931.015] In XMLSerializer while updating table Language_en_US from file XML/NewText/BertrandText.xml.
[107931.015] columns Language, Tag are not unique
[107931.625] Validating Foreign Key Constraints...
[107931.625] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107931.625] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107931.625] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107931.625] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107931.625] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107931.625] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107931.625] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107931.625] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107931.625] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[107931.843] Invalid Reference on Civilizations.Adjective - "TXT_KEY_CIV_RAGOR_ADJECTIVE" does not exist in Language_en_US
[107931.875] Invalid Reference on Civilizations.ShortDescription - "TXT_KEY_CIV_RAGOR_SHORT_DESC" does not exist in Language_en_US
[107931.906] Invalid Reference on Civilizations.Description - "TXT_KEY_CIV_RAGOR_DESC" does not exist in Language_en_US
[107931.937] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_STGILLE" does not exist in Language_en_US
[107931.937] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_AIGUEMORTE" does not exist in Language_en_US
[107931.937] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_STLAURENT" does not exist in Language_en_US
[107932.125] Invalid Reference on Traits.ShortDescription - "TXT_KEY_TRAIT_BATTLE_FURY_SHORT" does not exist in Language_en_US
[107932.156] Invalid Reference on Traits.Description - "TXT_KEY_TRAIT_BATTLE_FURY" does not exist in Language_en_US
[107932.984] Invalid Reference on Units.Help - "TXT_KEY_UNIT_HELP_GAELIC_WARRIOR" does not exist in Language_en_US
[107933.062] Invalid Reference on Units.Description - "TXT_KEY_UNIT_GAELIC_WARRIOR" does not exist in Language_en_US
[107933.593] Failed Validation.
[107933.937]
-- SQLite Memory Statistics --
Memory Usage:
        [Cur]        [Max]
Malloc:        6457056        75803296
PageCache:    7        13
LookAside:    0        0
Scratch:    0        1

Static Buffer Overflows:
        [TooLarge]    [NoSpace]
PageCache:    6037584        62898360
Scratch:    0        0

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

Prepared Statements:
Current:        8
------------------------------
 
From what I can see the problem is here:

Code:
[105662.015] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with  values (TXT_KEY_CITY_NAME_NIMES, Nimes, ).
[105662.015] In XMLSerializer while updating table Language_en_US from file XML/NewText/BertrandText.xml.

I didn't see this file (BertrandText.xml) in the RAR you attached earlier. Also, the syntax of the error statement looks like it is expecting only two fields, but the "values" part of that looks malformed.
 
Sorry I renamed GameText.xml in BertrandText.xml while looking for solution.

Agree on the malformed value, looking for this right now and see if I find something.
 
columns Language, Tag are not unique

This looks like the main source of your problems. Adding tags that already exist will cause the entire XML file to fail. For existing tags, you should use <Update> instead.
 
This looks like the main source of your problems. Adding tags that already exist will cause the entire XML file to fail. For existing tags, you should use <Update> instead.

Damn that was only for one city ! It seems NIMES is already added for the French Civilization...
Thanks !
 
Indeed the problem is this:
Code:
		<Row>
			<CivilizationType>CIVILIZATION_FRANCE</CivilizationType>
			<CityName>TXT_KEY_CITY_NAME_NIMES</CityName>
		</Row>
And TXT_KEY_CITY_NAME_NIMES is already defined in the game's base files so you can't attempt to define it again. All you can do is attempt to <Update> the existing TXT_KEY that is in Language_en_US and Language_FR_FR, or use a slightly different TXT_KEY name for the city, such as TXT_KEY_CITY_NAME_NIMES2.

Just be aware that if the actual name as used in-game is Nimes the game will not want to give two different cities the same name, even for two different civilizations. So if Huns (?) or French are in the game and have already built a city that used that city-name, you would not see Nimes as a city-name for that particular game for your civ.
 
Thank you LeeS. We actually found it few messages ago. I didn't expect that Nimes, a pitty city, would be in civ.
By the way, do you know a powerfull tool that allow to do Regular expression search in multiple files in order to research keys in civ5 folder ? Because Modbuddy is not enough.
 
I use Agent Ransack and search all xml files in the Civ5 game directory.

Alternatively you can use an SQL database viewer program and open and look at the contents of ~\Documents\My Games\Sid Meier's Civilization 5\cache/Localization-Merged.db. But probably the Agent Ransack or similar file-searching program will be easier to use since there are so very many TXT_KEYS defined within the game's base language files, and depending on what type of database viewer you use it might not be as simple to find whether a particular TXT KEY already exists in the game's database.
 
Hi again everyone. I come with new questions not related to the thread title but I do not want to polute the forum with more threads.

I am building another civilization now and wanted to add unique tile improvement (just like brazil have their brazilwood camp). I used trade post camp and brazilwood camp as model. The unique tile improvement is shown when I select the civ in game, however I can never build it on any tiles.

Here is the code and database log:
Spoiler Code :

Code:
<?xml version="1.0" encoding="utf-8"?>
<GameData>
    <Improvements>
        <Row>
            <Type>IMPROVEMENT_STANDJAPAN</Type>
            <Description>TXT_KEY_IMPROVEMENT_STANDJAPAN</Description>
            <ArtDefineTag>ART_DEF_IMPROVEMENT_TRADING_POST</ArtDefineTag>
            <Help>TXT_KEY_IMPROVEMENT_STANDJAPAN_HELP</Help>
            <WorldSoundscapeAudioScript></WorldSoundscapeAudioScript>           
            <ImprovementPillage></ImprovementPillage>
            <ImprovementUpgrade></ImprovementUpgrade>
            <SpecificCivRequired>1</SpecificCivRequired>
            <CivilizationType>CIVILIZATION_XIII</CivilizationType>
            <HillsMakesValid>0</HillsMakesValid>
            <FreshWaterMakesValid>0</FreshWaterMakesValid>
            <RiverSideMakesValid>0</RiverSideMakesValid>
            <NoFreshWater>0</NoFreshWater>
            <RequiresFlatlands>0</RequiresFlatlands>
            <RequiresFlatlandsOrFreshWater>0</RequiresFlatlandsOrFreshWater>
            <RequiresFeature>0</RequiresFeature>
            <RequiresImprovement>0</RequiresImprovement>
            <RemovesResource>0</RemovesResource>
            <PromptWhenComplete>0</PromptWhenComplete>
            <Coastal>0</Coastal>
            <Water>0</Water>
            <DestroyedWhenPillaged>0</DestroyedWhenPillaged>
            <DisplacePillager>0</DisplacePillager>
            <BuildableOnResources>0</BuildableOnResources>
            <BarbarianCamp>0</BarbarianCamp>
            <Goody>0</Goody>
            <Permanent>0</Permanent>
            <OutsideBorders>0</OutsideBorders>
            <InAdjacentFriendly>0</InAdjacentFriendly>
            <IgnoreOwnership>0</IgnoreOwnership>
            <OnlyCityStateTerritory>0</OnlyCityStateTerritory>
            <GraphicalOnly>0</GraphicalOnly>
            <CreatedByGreatPerson>0</CreatedByGreatPerson>
            <NoTwoAdjacent>0</NoTwoAdjacent>
            <AdjacentLuxury>0</AdjacentLuxury>
            <AllowsWalkWater>0</AllowsWalkWater>
            <CultureAdjacentSameType>0</CultureAdjacentSameType>
            <TilesPerGoody>0</TilesPerGoody>
            <GoodyRange>0</GoodyRange>
            <FeatureGrowth>0</FeatureGrowth>
            <UpgradeTime>0</UpgradeTime>
            <RiverSideUpgradeMod>0</RiverSideUpgradeMod>
            <CoastalLandUpgradeMod>0</CoastalLandUpgradeMod>
            <HillsUpgradeMod>0</HillsUpgradeMod>
            <FreshWaterUpgradeMod>0</FreshWaterUpgradeMod>
            <DefenseModifier>0</DefenseModifier>
            <NearbyEnemyDamage>0</NearbyEnemyDamage>
            <PillageGold>20</PillageGold>
            <ResourceExtractionMod>0</ResourceExtractionMod>
            <LuxuryCopiesSiphonedFromMinor>0</LuxuryCopiesSiphonedFromMinor>
            <GoldMaintenance>0</GoldMaintenance>
            <CultureBombRadius>0</CultureBombRadius>
            <RequiresXAdjacentLand>-1</RequiresXAdjacentLand>
            <PortraitIndex>32</PortraitIndex>
            <IconAtlas>TERRAIN_ATLAS</IconAtlas>
        </Row>
    </Improvements>
    <Improvement_ValidTerrains>
        <Row>
            <ImprovementType>IMPROVEMENT_STANDJAPAN</ImprovementType>
            <TerrainType>TERRAIN_GRASS</TerrainType>
        </Row>
        <Row>
            <ImprovementType>IMPROVEMENT_STANDJAPAN</ImprovementType>
            <TerrainType>TERRAIN_PLAINS</TerrainType>
        </Row>
        <Row>
            <ImprovementType>IMPROVEMENT_STANDJAPAN</ImprovementType>
            <TerrainType>TERRAIN_DESERT</TerrainType>
        </Row>
        <Row>
            <ImprovementType>IMPROVEMENT_STANDJAPAN</ImprovementType>
            <TerrainType>TERRAIN_TUNDRA</TerrainType>
        </Row>
    </Improvement_ValidTerrains>
    <Improvement_Yields>
        <Row>
            <ImprovementType>IMPROVEMENT_STANDJAPAN</ImprovementType>
            <YieldType>YIELD_GOLD</YieldType>
            <Yield>2</Yield>
        </Row>
        <Row>
            <ImprovementType>IMPROVEMENT_STANDJAPAN</ImprovementType>
            <YieldType>YIELD_CULTURE</YieldType>
            <Yield>4</Yield>
        </Row>
    </Improvement_Yields>
    <Improvement_TechYieldChanges>
        <Row>
            <ImprovementType>IMPROVEMENT_STANDJAPAN</ImprovementType>
            <TechType>TECH_PHILOSOPHY</TechType>
            <YieldType>YIELD_SCIENCE</YieldType>
            <Yield>1</Yield>
        </Row>
    </Improvement_TechYieldChanges>
</GameData>


Spoiler Log :

Code:
[92798.515] columns StrategicViewType, TileType are not unique
[92798.515] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[92800.109] no such table: ContentPackage.LocalizedText
[92800.109] no such table: ContentPackage.LocalizedText
[92800.109] no such table: ContentPackage.LocalizedText
[92801.046] no such table: ContentPackage.LocalizedText
[92802.281] columns StrategicViewType, TileType are not unique
[92802.281] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[92802.828] no such table: ContentPackage.LocalizedText
[92802.828] no such table: ContentPackage.LocalizedText
[92802.843] no such table: ContentPackage.LocalizedText
[92805.921] Validating Foreign Key Constraints...
[92805.921] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92805.921] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92805.921] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92805.921] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92805.921] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92805.921] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92805.921] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92805.921] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92805.921] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92807.875] Failed Validation.
[92808.218]
-- SQLite Memory Statistics --
Memory Usage:
        [Cur]        [Max]
Malloc:        6243296        75805648
PageCache:    6        12
LookAside:    0        0
Scratch:    0        1

Static Buffer Overflows:
        [TooLarge]    [NoSpace]
PageCache:    5828256        62900712
Scratch:    0        0

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

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

Static Buffer Overflows:
        [TooLarge]    [NoSpace]
PageCache:    5829432        62900712
Scratch:    0        0

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

Prepared Statements:
Current:        6
------------------------------
[92865.937] Validating Foreign Key Constraints...
[92865.937] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92865.937] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92865.937] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92865.937] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92865.937] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92865.937] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92865.937] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92865.937] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92865.937] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[92867.906] Failed Validation.
[92868.250]
-- SQLite Memory Statistics --
Memory Usage:
        [Cur]        [Max]
Malloc:        6410192        75805648
PageCache:    7        13
LookAside:    0        0
Scratch:    0        1

Static Buffer Overflows:
        [TooLarge]    [NoSpace]
PageCache:    5983488        62900712
Scratch:    0        0

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

Prepared Statements:
Current:        8
------------------------------
 
no build for the improvement or ability of any unit to build the improvement. See example for the needed tables your code is missing:
Spoiler :
Code:
<GameData>
	<!-- Table data -->
	<Language_en_US>
		<Row Tag="TXT_KEY_CIV5_IMPROVEMENTS_ROMAN_TERRACE_FARM_HELP">
			<Text>Only valid on Hill tiles: +2 [ICON_FOOD], +1 [ICON_GOLD], and +1 [ICON_CULTURE]. +1 [ICON_PRODUCTION] Production for every adjacent mountain tile. Only Rome Can Build Roman Terrace Farms because it is crazy OP for funs.</Text>
		</Row>
		<Row Tag="TXT_KEY_IMPROVEMENT_ROMAN_TERRACE_FARM">
			<Text>Roman Terrace Farm</Text>
		</Row>
	</Language_en_US>

	<Improvements>
		<Row>
			<Type>IMPROVEMENT_ROMAN_TERRACE_FARM</Type>
			<Description>TXT_KEY_IMPROVEMENT_ROMAN_TERRACE_FARM</Description>
			<Civilopedia>TXT_KEY_CIV5_IMPROVEMENTS_TERRACE_FARM_TEXT</Civilopedia>
			<Help>TXT_KEY_CIV5_IMPROVEMENTS_ROMAN_TERRACE_FARM_HELP</Help>
			<ArtDefineTag>ART_DEF_IMPROVEMENT_TERRACE_FARM</ArtDefineTag>
			<SpecificCivRequired>true</SpecificCivRequired>
			<CivilizationType>CIVILIZATION_ROME_LEE</CivilizationType>
			<HillsMakesValid>true</HillsMakesValid>
			<PillageGold>18</PillageGold>
			<PortraitIndex>0</PortraitIndex>
			<IconAtlas>DLC02_TERRAIN_ATLAS</IconAtlas>
		</Row>
	</Improvements>
	<Improvement_Yields>
		<Row>
			<ImprovementType>IMPROVEMENT_ROMAN_TERRACE_FARM</ImprovementType>
			<YieldType>YIELD_FOOD</YieldType>
			<Yield>2</Yield>
		</Row>
		<Row>
			<ImprovementType>IMPROVEMENT_ROMAN_TERRACE_FARM</ImprovementType>
			<YieldType>YIELD_GOLD</YieldType>
			<Yield>1</Yield>
		</Row>
		<Row>
			<ImprovementType>IMPROVEMENT_ROMAN_TERRACE_FARM</ImprovementType>
			<YieldType>YIELD_CULTURE</YieldType>
			<Yield>1</Yield>
		</Row>
	</Improvement_Yields>
	<Improvement_AdjacentMountainYieldChanges>
		<Row>
			<ImprovementType>IMPROVEMENT_ROMAN_TERRACE_FARM</ImprovementType>
			<YieldType>YIELD_PRODUCTION</YieldType>
			<Yield>1</Yield>
		</Row>
	</Improvement_AdjacentMountainYieldChanges>
	<Improvement_TechNoFreshWaterYieldChanges>
		<Row>
			<ImprovementType>IMPROVEMENT_ROMAN_TERRACE_FARM</ImprovementType>
			<TechType>TECH_FERTILIZER</TechType>
			<YieldType>YIELD_FOOD</YieldType>
			<Yield>1</Yield>
		</Row>
	</Improvement_TechNoFreshWaterYieldChanges>
	<Improvement_TechFreshWaterYieldChanges>
		<Row>
			<ImprovementType>IMPROVEMENT_ROMAN_TERRACE_FARM</ImprovementType>
			<TechType>TECH_CIVIL_SERVICE</TechType>
			<YieldType>YIELD_FOOD</YieldType>
			<Yield>1</Yield>
		</Row>
	</Improvement_TechFreshWaterYieldChanges>
	<Improvement_ValidTerrains>
		<Row>
			<ImprovementType>IMPROVEMENT_ROMAN_TERRACE_FARM</ImprovementType>
			<TerrainType>TERRAIN_HILL</TerrainType>
		</Row>
	</Improvement_ValidTerrains>
	<Unit_Builds>
		<Row>
			<UnitType>UNIT_WORKER</UnitType>
			<BuildType>BUILD_ROMAN_TERRACE_FARM</BuildType>
		</Row>
	</Unit_Builds>
	<Builds>
		<Row>
			<Type>BUILD_ROMAN_TERRACE_FARM</Type>
			<PrereqTech>TECH_AGRICULTURE</PrereqTech>
			<Time>600</Time>
			<ImprovementType>IMPROVEMENT_ROMAN_TERRACE_FARM</ImprovementType>
			<Description>TXT_KEY_BUILD_TERRACE_FARM</Description>
			<Recommendation>TXT_KEY_BUILD_FOOD_REC</Recommendation>
			<EntityEvent>ENTITY_EVENT_IRRIGATE</EntityEvent>
			<HotKey>KB_E</HotKey>
			<OrderPriority>97</OrderPriority>
			<IconIndex>0</IconIndex>
			<IconAtlas>UNIT_ACTION_DLC02_ATLAS</IconAtlas>
		</Row>
	</Builds>
	<BuildFeatures>
		<Row>
			<BuildType>BUILD_ROMAN_TERRACE_FARM</BuildType>
			<FeatureType>FEATURE_JUNGLE</FeatureType>
			<PrereqTech>TECH_BRONZE_WORKING</PrereqTech>
			<Time>400</Time>
			<Production>20</Production>
			<Remove>true</Remove>
		</Row>
		<Row>
			<BuildType>BUILD_ROMAN_TERRACE_FARM</BuildType>
			<FeatureType>FEATURE_FOREST</FeatureType>
			<PrereqTech>TECH_MINING</PrereqTech>
			<Time>400</Time>
			<Production>20</Production>
			<Remove>true</Remove>
		</Row>
	</BuildFeatures>
</GameData>
 
Thank you LeeS. We actually found it few messages ago. I didn't expect that Nimes, a pitty city, would be in civ.
Such things, and compatibility problems between mods, can be easily avoided if you add a personal tag to those text keys (or really anything).

Instead of...
TXT_KEY_THING_THAT_MIGHT_ALREADY_EXIST
...name it...
TXT_KEY_RYIKA_THING_THAT_MIGHT_ALREADY_EXIST
...and you shouldn't run into those issues anymore.

(Although, in this case it may have been a good thing that you've ran into the issue, as it made you realize that the City already exists... but as a general idea.)

Also has the added benefit that you can then sort tables by name/use mass searches and find all of your text keys (or buildings, or whatever) in one place.
 
Top Bottom