TXT_KEY not replaced

Discussion in 'Civ5 - Creation & Customization' started by Deathoverride, Feb 5, 2017.

Tags:
  1. Deathoverride

    Deathoverride Chieftain

    Joined:
    Feb 5, 2017
    Messages:
    9
    Gender:
    Male
    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>
     

    Attached Files:

  2. sman1975

    sman1975 Emperor

    Joined:
    Aug 27, 2016
    Messages:
    1,246
    Location:
    Dallas, TX
    Any time it looks like database isn't updating, you need to check the database.log to see what the errors are. To enable logging:

    https://forums.civfanatics.com/threads/how-to-enable-logging.487482/

    This should give you a pretty good clue to any errors that are occurring. It would help if you could turn on logging, load the mod, then post a copy of the database.log
     
  3. Deathoverride

    Deathoverride Chieftain

    Joined:
    Feb 5, 2017
    Messages:
    9
    Gender:
    Male
    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
    ------------------------------
    
     
  4. sman1975

    sman1975 Emperor

    Joined:
    Aug 27, 2016
    Messages:
    1,246
    Location:
    Dallas, TX
    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.
     
  5. Deathoverride

    Deathoverride Chieftain

    Joined:
    Feb 5, 2017
    Messages:
    9
    Gender:
    Male
    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
    ------------------------------
    
     
  6. sman1975

    sman1975 Emperor

    Joined:
    Aug 27, 2016
    Messages:
    1,246
    Location:
    Dallas, TX
    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.
     
  7. Deathoverride

    Deathoverride Chieftain

    Joined:
    Feb 5, 2017
    Messages:
    9
    Gender:
    Male
    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.
     
  8. PawelS

    PawelS Ancient Druid

    Joined:
    Dec 11, 2003
    Messages:
    2,803
    Location:
    Poland
    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.
     
    Deathoverride likes this.
  9. Deathoverride

    Deathoverride Chieftain

    Joined:
    Feb 5, 2017
    Messages:
    9
    Gender:
    Male
    Damn that was only for one city ! It seems NIMES is already added for the French Civilization...
    Thanks !
     
  10. sman1975

    sman1975 Emperor

    Joined:
    Aug 27, 2016
    Messages:
    1,246
    Location:
    Dallas, TX
    No prob - sorry I didn't see it earlier. Bon Chance!
     
    Deathoverride likes this.
  11. LeeS

    LeeS Imperator

    Joined:
    Jul 23, 2013
    Messages:
    7,241
    Location:
    Illinois, USA
    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.
     
    sman1975 likes this.
  12. Deathoverride

    Deathoverride Chieftain

    Joined:
    Feb 5, 2017
    Messages:
    9
    Gender:
    Male
    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.
     
  13. LeeS

    LeeS Imperator

    Joined:
    Jul 23, 2013
    Messages:
    7,241
    Location:
    Illinois, USA
    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.
     
    Deathoverride likes this.
  14. Deathoverride

    Deathoverride Chieftain

    Joined:
    Feb 5, 2017
    Messages:
    9
    Gender:
    Male
    Thank you. That will probably help more than me.
     
  15. Deathoverride

    Deathoverride Chieftain

    Joined:
    Feb 5, 2017
    Messages:
    9
    Gender:
    Male
    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
    ------------------------------
    
     
  16. LeeS

    LeeS Imperator

    Joined:
    Jul 23, 2013
    Messages:
    7,241
    Location:
    Illinois, USA
    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>
     
    Deathoverride likes this.
  17. Deathoverride

    Deathoverride Chieftain

    Joined:
    Feb 5, 2017
    Messages:
    9
    Gender:
    Male
    Everything is working fine now !
    Thank you so much.
     
  18. Ryika

    Ryika Lazy Wannabe Artista

    Joined:
    Aug 30, 2013
    Messages:
    9,395
    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.
     

Share This Page