Augh, no custom civilizations i made in the select civilization screen?

ScoopJohn

Chieftain
Joined
Oct 30, 2015
Messages
47
Hi guys, i already finished another civilization for my mod and turns out i've made strange errors again. This time i went to test my another civilization and however, there are no custom civilizations i made on the list...i also went to the advanced setup to check and there isn't them too. I was glad that this turned out well but it's confusing that i don't know why the civilizations aren't showing.

This is the database log i've collected:
Code:
[55672.687] table Civilization_SpyNames has no column named Gender
[55672.687] In Query - insert into Civilization_SpyNames('CivilizationType', 'SpyName', 'Gender') values (?, ?, ?);
[55672.687] In XMLSerializer while updating table Civilization_SpyNames from file XML/Civilizations/Civ_SeaKingdom.xml.
[55672.703] columns Language, Tag are not unique
[55672.703] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[55672.703] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with  values (TXT_KEY_LEADER_SHIROGANE, Shirogane, ).
[55672.703] In XMLSerializer while updating table Language_en_US from file XML/NewText/GameText.xml.
[55672.703] columns Language, Tag are not unique
[55672.765] columns Language, Tag are not unique
[55672.765] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[55672.765] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with  values (TXT_KEY_LEADER_SHIROGANE, Shirogane, ).
[55672.765] In XMLSerializer while updating table Language_en_US from file XML/NewText/GameText.xml.
[55672.765] columns Language, Tag are not unique
[55672.781] table Civilization_SpyNames has no column named Gender
[55672.781] In Query - insert into Civilization_SpyNames('CivilizationType', 'SpyName', 'Gender') values (?, ?, ?);
[55672.781] In XMLSerializer while updating table Civilization_SpyNames from file XML/Civilizations/Civ_IcebergIsle.xml.
[55672.781] Database::XMLSerializer (XML/Units/CIV5ArtDefines.xml): 'Row' or 'Delete' expected, got 'UnitArtInfo'.
[55672.781] Database::XMLSerializer (XML/NewText/Shirogane_DiploText.xml): 'Row' or 'Delete' expected, got 'Diplomacy_Responses'.

Below it's the zip file of the mod i made as usual.
 
The very first thing in that log is your immediate problem:
Code:
[55672.687] table Civilization_SpyNames has no column named Gender
[55672.687] In Query - insert into Civilization_SpyNames('CivilizationType', 'SpyName', 'Gender') values (?, ?, ?);
[55672.687] In XMLSerializer while updating table Civilization_SpyNames from file XML/Civilizations/Civ_SeaKingdom.xml.
To put this in human speech:

"While processing a file called Civ_SeaKingdom.xml, we ran across an attempt to insert data into the table Civilization_SpyNames using a column called Gender, which is nonexistent."

At this point the XML parser - which reads your XML and adds it to the game database - dumped the entire file, which necessarily also includes the code that defines the civilization. Hence, the civilization data never got loaded, since it got dumped, and hence, it really doesn't exist as far as the game knows!

We see later in the log that you made the same error, but in a different file:
Code:
[55672.781] table Civilization_SpyNames has no column named Gender
[55672.781] In Query - insert into Civilization_SpyNames('CivilizationType', 'SpyName', 'Gender') values (?, ?, ?);
[55672.781] In XMLSerializer while updating table Civilization_SpyNames from file XML/Civilizations/Civ_IcebergIsle.xml.

What I assume you're trying to do is adding a gender to spy names... but that's done within Language_en_US, not Civilization_SpyNames. The former does have a column named <Gender>.

I wrote this post a while back, for someone who also couldn't get their civ to show up. Their problem was a little different - it involved a different table being inserted into, for example - but the process I outlined for reading and understanding log errors is the same.
 
The very first thing in that log is your immediate problem:
Code:
[55672.687] table Civilization_SpyNames has no column named Gender
[55672.687] In Query - insert into Civilization_SpyNames('CivilizationType', 'SpyName', 'Gender') values (?, ?, ?);
[55672.687] In XMLSerializer while updating table Civilization_SpyNames from file XML/Civilizations/Civ_SeaKingdom.xml.
To put this in human speech:

"While processing a file called Civ_SeaKingdom.xml, we ran across an attempt to insert data into the table Civilization_SpyNames using a column called Gender, which is nonexistent."

At this point the XML parser - which reads your XML and adds it to the game database - dumped the entire file, which necessarily also includes the code that defines the civilization. Hence, the civilization data never got loaded, since it got dumped, and hence, it really doesn't exist as far as the game knows!

We see later in the log that you made the same error, but in a different file:
Code:
[55672.781] table Civilization_SpyNames has no column named Gender
[55672.781] In Query - insert into Civilization_SpyNames('CivilizationType', 'SpyName', 'Gender') values (?, ?, ?);
[55672.781] In XMLSerializer while updating table Civilization_SpyNames from file XML/Civilizations/Civ_IcebergIsle.xml.

What I assume you're trying to do is adding a gender to spy names... but that's done within Language_en_US, not Civilization_SpyNames. The former does have a column named <Gender>.

I wrote this post a while back, for someone who also couldn't get their civ to show up. Their problem was a little different - it involved a different table being inserted into, for example - but the process I outlined for reading and understanding log errors is the same.

This has worked, but i've got another problem now:
oDaIggh.png


For the civilizations i'm working on separate files per civilization and leader, and however, this weird error shows up and it displays the string variables instead of the string's names. Plus, the Sea Kingdom civilization isn't shown on the leader select and so does only Iceberg Isle.

Welp, modding in CIV 5 wasn't so similar as CIV 4... :cry:
 
Look at your database.log again...

Last night i was really tired and forgot that aswell the Sea Kingdom's spy names had the same error before as the other civ, i've fixed that too.
Here's aswell the database log generated as after i fixed the spy names.

Code:
[842.203] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with  values (TXT_KEY_LEADER_SHIROGANE, Shirogane, ).
[842.203] In XMLSerializer while updating table Language_en_US from file XML/NewText/GameText.xml.
[842.203] columns Language, Tag are not unique
[842.218] Database::XMLSerializer (XML/Units/CIV5ArtDefines.xml): 'Row' or 'Delete' expected, got 'UnitArtInfo'.
[842.218] Database::XMLSerializer (XML/NewText/Shirogane_DiploText.xml): 'Row' or 'Delete' expected, got 'Diplomacy_Responses'.
[842.859] Validating Foreign Key Constraints...
[842.859] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[842.859] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[842.859] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[842.859] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[842.859] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[842.859] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[842.984] Invalid Reference on Buildings.Help - "TXT_KEY_BUILDING_ORBBARRIER_STRATEGY" does not exist in Language_en_US
[842.984] Invalid Reference on Buildings.Help - "TXT_KEY_BUILDING_IGLOO_STRATEGY" does not exist in Language_en_US
[843.015] Invalid Reference on Buildings.Strategy - "TXT_KEY_BUILDING_ORBBARRIER_STRATEGY" does not exist in Language_en_US
[843.015] Invalid Reference on Buildings.Strategy - "TXT_KEY_BUILDING_IGLOO_STRATEGY" does not exist in Language_en_US
[843.062] Invalid Reference on Buildings.Civilopedia - "TXT_KEY_CIV5_BUILDINGS_ORBBARRIER_TEXT" does not exist in Language_en_US
[843.062] Invalid Reference on Buildings.Civilopedia - "TXT_KEY_CIV5_BUILDINGS_IGLOO_TEXT" does not exist in Language_en_US
[843.093] Invalid Reference on Buildings.Description - "TXT_KEY_BUILDING_ORBBARRIER" does not exist in Language_en_US
[843.093] Invalid Reference on Buildings.Description - "TXT_KEY_BUILDING_IGLOO" does not exist in Language_en_US
[843.093] Invalid Reference on Building_YieldChanges.BuildingType - "BUILDING_CEILIDH_HALL" does not exist in Buildings
[843.093] Invalid Reference on Civilizations.AlphaIconAtlas - "CIV_ALPHA_ATLAS_OKEGOM1" does not exist in IconTextureAtlases
[843.093] Invalid Reference on Civilizations.AlphaIconAtlas - "CIV_ALPHA_ATLAS_OKEGOM1" does not exist in IconTextureAtlases
[843.140] Invalid Reference on Civilizations.Adjective - "TXT_KEY_CIV_SEAKINGDOM_ADJECTIVE" does not exist in Language_en_US
[843.140] Invalid Reference on Civilizations.Adjective - "TXT_KEY_CIV_ICEBERGISLE_ADJECTIVE" does not exist in Language_en_US
[843.171] Invalid Reference on Civilizations.ShortDescription - "TXT_KEY_CIV_SEAKINGDOM_SHORT_DESC" does not exist in Language_en_US
[843.171] Invalid Reference on Civilizations.ShortDescription - "TXT_KEY_CIV_ICEBERGISLE_SHORT_DESC" does not exist in Language_en_US
[843.203] Invalid Reference on Civilizations.Description - "TXT_KEY_CIV_SEAKINGDOM_DESC" does not exist in Language_en_US
[843.203] Invalid Reference on Civilizations.Description - "TXT_KEY_CIV_ICEBERGISLE_DESC" does not exist in Language_en_US
[843.234] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_SEAKINGDOM_0" does not exist in Language_en_US
[843.234] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_SEAKINGDOM_1" does not exist in Language_en_US
[843.234] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_SEAKINGDOM_2" does not exist in Language_en_US
[843.234] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_SEAKINGDOM_3" does not exist in Language_en_US
[843.234] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_SEAKINGDOM_4" does not exist in Language_en_US
[843.234] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_SEAKINGDOM_5" does not exist in Language_en_US
[843.234] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_SEAKINGDOM_6" does not exist in Language_en_US
[843.234] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_SEAKINGDOM_7" does not exist in Language_en_US
[843.234] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_SEAKINGDOM_8" does not exist in Language_en_US
[843.234] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_SEAKINGDOM_9" does not exist in Language_en_US
[843.234] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_SEAKINGDOM_10" does not exist in Language_en_US
[843.250] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_SEAKINGDOM_11" does not exist in Language_en_US
[843.250] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_ICEBERGISLE_0" does not exist in Language_en_US
[843.250] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_ICEBERGISLE_1" does not exist in Language_en_US
[843.250] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_ICEBERGISLE_2" does not exist in Language_en_US
[843.250] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_ICEBERGISLE_3" does not exist in Language_en_US
[843.250] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_ICEBERGISLE_5" does not exist in Language_en_US
[843.250] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_ICEBERGISLE_6" does not exist in Language_en_US
[843.250] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_ICEBERGISLE_7" does not exist in Language_en_US
[843.250] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_ICEBERGISLE_8" does not exist in Language_en_US
[843.250] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_ICEBERGISLE_9" does not exist in Language_en_US
[843.250] Invalid Reference on Civilization_CityNames.CityName - "TXT_KEY_CITY_NAME_ICEBERGISLE_10" does not exist in Language_en_US
[843.250] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_BYZANTIUM" does not exist in Civilizations
[843.250] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_NETHERLANDS" does not exist in Civilizations
[843.250] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_SWEDEN" does not exist in Civilizations
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_SEAKINGDOM_0" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_SEAKINGDOM_1" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_SEAKINGDOM_2" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_SEAKINGDOM_3" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_SEAKINGDOM_4" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_SEAKINGDOM_5" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_SEAKINGDOM_6" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_SEAKINGDOM_7" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_SEAKINGDOM_8" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_SEAKINGDOM_9" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_SEAKINGDOM_10" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_SEAKINGDOM_11" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_SEAKINGDOM_12" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_ICEBERGISLE_0" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_ICEBERGISLE_1" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_ICEBERGISLE_2" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_ICEBERGISLE_3" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_ICEBERGISLE_4" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_ICEBERGISLE_5" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_SpyNames.SpyName - "TXT_KEY_SPY_NAME_ICEBERGISLE_6" does not exist in Language_en_US
[843.281] Invalid Reference on Civilization_Start_Along_Ocean.CivilizationType - "CIVILIZATION_BYZANTIUM" does not exist in Civilizations
[843.281] Invalid Reference on Civilization_Start_Along_Ocean.CivilizationType - "CIVILIZATION_KOREA" does not exist in Civilizations
[843.281] Invalid Reference on Civilization_Start_Region_Priority.CivilizationType - "CIVILIZATION_AUSTRIA" does not exist in Civilizations
[843.281] Invalid Reference on Civilization_Start_Region_Priority.CivilizationType - "CIVILIZATION_SWEDEN" does not exist in Civilizations
[843.281] Invalid Reference on Civilization_Start_Region_Avoid.CivilizationType - "CIVILIZATION_BABYLON" does not exist in Civilizations
[843.281] Invalid Reference on Civilization_Start_Region_Avoid.CivilizationType - "CIVILIZATION_HUNS" does not exist in Civilizations
[843.281] Invalid Reference on Civilization_Start_Region_Avoid.CivilizationType - "CIVILIZATION_HUNS" does not exist in Civilizations
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_ATTILA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_ATTILA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_ATTILA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_ATTILA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_ATTILA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_ATTILA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_BOUDICCA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_BOUDICCA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_BOUDICCA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_BOUDICCA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_BOUDICCA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_BOUDICCA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_DIDO" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_DIDO" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_DIDO" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_DIDO" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_DIDO" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_DIDO" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_GUSTAVUS_ADOLPHUS" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_GUSTAVUS_ADOLPHUS" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_GUSTAVUS_ADOLPHUS" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_GUSTAVUS_ADOLPHUS" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_GUSTAVUS_ADOLPHUS" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_GUSTAVUS_ADOLPHUS" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_HARALD" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_HARALD" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_HARALD" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_HARALD" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_HARALD" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_HARALD" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_ISABELLA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_ISABELLA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_ISABELLA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_ISABELLA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_ISABELLA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_ISABELLA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_KAMEHAMEHA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_KAMEHAMEHA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_KAMEHAMEHA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_KAMEHAMEHA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_KAMEHAMEHA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_KAMEHAMEHA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_MARIA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_MARIA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_MARIA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_MARIA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_MARIA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_MARIA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_NEBUCHADNEZZAR" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_NEBUCHADNEZZAR" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_NEBUCHADNEZZAR" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_NEBUCHADNEZZAR" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_NEBUCHADNEZZAR" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_NEBUCHADNEZZAR" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_PACAL" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_PACAL" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_PACAL" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_PACAL" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_PACAL" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_PACAL" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_PACHACUTI" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_PACHACUTI" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_PACHACUTI" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_PACHACUTI" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_PACHACUTI" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_PACHACUTI" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_SEJONG" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_SEJONG" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_SEJONG" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_SEJONG" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_SEJONG" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_SEJONG" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_THEODORA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_THEODORA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_THEODORA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_THEODORA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_THEODORA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_THEODORA" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_WILLIAM" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_WILLIAM" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_WILLIAM" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_WILLIAM" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_WILLIAM" does not exist in Leaders
[843.718] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_WILLIAM" does not exist in Leaders
[844.500] Invalid Reference on Units.Help - "TXT_KEY_UNIT_HELP_SEAMAN" does not exist in Language_en_US
[844.500] Invalid Reference on Units.Help - "TXT_KEY_UNIT_HELP_POLARBEARGUARD" does not exist in Language_en_US
[844.531] Invalid Reference on Units.Strategy - "TXT_KEY_UNIT_SEAMAN_STRATEGY" does not exist in Language_en_US
[844.531] Invalid Reference on Units.Strategy - "TXT_KEY_UNIT_POLARBEARGUARD_STRATEGY" does not exist in Language_en_US
[844.578] Invalid Reference on Units.Civilopedia - "TXT_KEY_CIV5_ANTIQUITY_SEAMAN_TEXT" does not exist in Language_en_US
[844.578] Invalid Reference on Units.Civilopedia - "TXT_KEY_CIV5_ANTIQUITY_POLARBEARGUARD_TEXT" does not exist in Language_en_US
[844.609] Invalid Reference on Units.Description - "TXT_KEY_UNIT_SEAMAN" does not exist in Language_en_US
[844.609] Invalid Reference on Units.Description - "TXT_KEY_UNIT_POLARBEARGUARD" does not exist in Language_en_US
[845.265] Failed Validation.
[845.703]

(ignore the steam DLC missing civilizations)
As you can see, the custom text strings were working before and something happened to them. It's quite strange.
 
You've included GameText.xml twice as an UpdateDatabase action, which doesn't help matters, but errors occur in order, so you need to fix the couple at the top of the list before worrying about the (several hundred) missing TXT_KEY_s - as they are almost certainly being caused by the initial errors.

Without looking in the xml files ...
Code:
[139864.625] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[139864.625] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with  values (TXT_KEY_LEADER_SHIROGANE, Shirogane, ).
[139864.625] In XMLSerializer while updating table Language_en_US from file XML/NewText/GameText.xml.
Looks like you've copy/paste duplicated TXT_KEY_LEADER_SHIROGANE (and possibly others, keep checking the logs until the GameText.xml file doesn't generate any errors)
Code:
[139864.765] Database::XMLSerializer (XML/Units/CIV5ArtDefines.xml): 'Row' or 'Delete' expected, got 'UnitArtInfo'.
Looks like you've missed out the <Row> tag and just listed column names directly within the <UnitArtInfo> table
Code:
[139864.765] Database::XMLSerializer (XML/NewText/Shirogane_DiploText.xml): 'Row' or 'Delete' expected, got 'Diplomacy_Responses'.
Probably a copy/pasted duplicated tag

Remember, a single error in a database XML file will cause the entire file to be discarded, so those errors have the effect of your mod being missing three of your XML files!
 
You've included GameText.xml twice as an UpdateDatabase action, which doesn't help matters, but errors occur in order, so you need to fix the couple at the top of the list before worrying about the (several hundred) missing TXT_KEY_s - as they are almost certainly being caused by the initial errors.

Without looking in the xml files ...
Code:
[139864.625] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[139864.625] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with  values (TXT_KEY_LEADER_SHIROGANE, Shirogane, ).
[139864.625] In XMLSerializer while updating table Language_en_US from file XML/NewText/GameText.xml.
Looks like you've copy/paste duplicated TXT_KEY_LEADER_SHIROGANE (and possibly others, keep checking the logs until the GameText.xml file doesn't generate any errors)
Code:
[139864.765] Database::XMLSerializer (XML/Units/CIV5ArtDefines.xml): 'Row' or 'Delete' expected, got 'UnitArtInfo'.
Looks like you've missed out the <Row> tag and just listed column names directly within the <UnitArtInfo> table
Code:
[139864.765] Database::XMLSerializer (XML/NewText/Shirogane_DiploText.xml): 'Row' or 'Delete' expected, got 'Diplomacy_Responses'.
Probably a copy/pasted duplicated tag

Remember, a single error in a database XML file will cause the entire file to be discarded, so those errors have the effect of your mod being missing three of your XML files!

This worked like charm, however, i made a unique unit which is a polar bear guard using the Civ4 bear model i got from this forum. However, i can't get the art define right and instead it's showing me the default warrior models. I ain't good at custom art define...
I have the bear model in the art/units directory by the way.
930yEdb.jpg
 
Assuming the attachment in Post #5 is still a fairly accurate representation of your mod, the problem with the unsuccessful unit art define is right here
Code:
<GameData>
	<UnitArtInfos>
		<UnitArtInfo>
			<Type>ART_DEF_UNIT_POLARBEARGUARD</Type>
			<Formation>Phalanx</Formation>
			<DamageStates>1</DamageStates>
			<UnitMemberArt>
				<MemberType>ART_DEF_UNIT_MEMBER_POLARBEARGUARD</MemberType>
				<MemberCount>10</MemberCount>
			</UnitMemberArt>
		</UnitArtInfo>
	</UnitArtInfos>

	<UnitMemberArtInfos>
		<UnitMemberArtInfo>
			<Type>ART_DEF_UNIT_MEMBER_POLARBEARGUARD</Type>
			<fScale>0.15</fScale>
			<Granny>Art/Units/bear.fxsxml</Granny>
			<Combat>
				<Defaults>ART_DEF_TEMPLATE_SOLDIER</Defaults>
				<Weapon>
					<WeaponTypeTag>BLUNT</WeaponTypeTag>
					<WeaponTypeSoundOverrideTag>BLUNT</WeaponTypeSoundOverrideTag>
				</Weapon>
			</Combat>
			<MaterialTypeTag>CLOTH</MaterialTypeTag>
			<MaterialTypeSoundOverrideTag>FLESH</MaterialTypeSoundOverrideTag>
		</UnitMemberArtInfo>
	</UnitMemberArtInfos>
</GameData>
  1. Table <UnitArtInfos> and its submember <UnitMemberArt> are no longer used in mods.
  2. Table <UnitMemberArtInfos> and its submembers are no longer used in mods.
  3. Unit art defines now (and have for some time) require use of tables <ArtDefine_UnitInfos>, <ArtDefine_UnitInfoMemberInfos>, <ArtDefine_UnitMemberInfos>, <ArtDefine_StrategicView>, <ArtDefine_UnitMemberCombats>, and <ArtDefine_UnitMemberCombatWeapons>
  4. Like this, copied from one of DoktorApplejuice's mods:
    Code:
    <GameData>
    	<ArtDefine_UnitInfos>
    		<Row>
    			<Type>ART_DEF_UNIT_SAILORSENSHI</Type>
    			<DamageStates>1</DamageStates>
    			<Formation>Scout</Formation>
    		</Row>
    	</ArtDefine_UnitInfos>
    	<ArtDefine_UnitInfoMemberInfos>
    		<Row>
    			<UnitInfoType>ART_DEF_UNIT_SAILORSENSHI</UnitInfoType>
    			<UnitMemberInfoType>ART_DEF_UNIT_MEMBER_SAILORSENSHI</UnitMemberInfoType>
    			<NumMembers>1</NumMembers>
    		</Row>
    	</ArtDefine_UnitInfoMemberInfos>
    	<ArtDefine_UnitMemberInfos>
    		<Row>
    			<Type>ART_DEF_UNIT_MEMBER_SAILORSENSHI</Type>
    			<Scale>0.200000000596046</Scale>
    			<Model>SailorSenshi.fxsxml</Model>
    			<MaterialTypeTag>CLOTH</MaterialTypeTag>
    			<MaterialTypeSoundOverrideTag>FLESH</MaterialTypeSoundOverrideTag>
    		</Row>
    	</ArtDefine_UnitMemberInfos>
    	<ArtDefine_UnitMemberCombats>
    		<Row>
    			<UnitMemberType>ART_DEF_UNIT_MEMBER_SAILORSENSHI</UnitMemberType>
    			<EnableActions>Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge</EnableActions>
    			<ShortMoveRadius>12.0</ShortMoveRadius>
    			<ShortMoveRate>0.349999994039536</ShortMoveRate>
    			<TargetHeight>8.0</TargetHeight>
    			<HasRefaceAfterCombat>1</HasRefaceAfterCombat>
    		</Row>
    	</ArtDefine_UnitMemberCombats>
    	<ArtDefine_UnitMemberCombatWeapons>
    		<Row>
    			<UnitMemberType>ART_DEF_UNIT_MEMBER_SAILORSENSHI</UnitMemberType>
    			<Index>0</Index>
    			<SubIndex>0</SubIndex>
    			<WeaponTypeTag>BLUNT</WeaponTypeTag>
    			<WeaponTypeSoundOverrideTag>SPEAR</WeaponTypeSoundOverrideTag>
    		</Row>
    	</ArtDefine_UnitMemberCombatWeapons>
    	<ArtDefine_StrategicView>
    		<Row>
    			<StrategicViewType>ART_DEF_UNIT_SAILORSENSHI</StrategicViewType>
    			<TileType>Unit</TileType>
    			<Asset>SV_Pathfinder.dds</Asset>
    		</Row>
    	</ArtDefine_StrategicView>
    </GameData>
 
Assuming the attachment in Post #5 is still a fairly accurate representation of your mod, the problem with the unsuccessful unit art define is right here
Code:
<GameData>
	<UnitArtInfos>
		<UnitArtInfo>
			<Type>ART_DEF_UNIT_POLARBEARGUARD</Type>
			<Formation>Phalanx</Formation>
			<DamageStates>1</DamageStates>
			<UnitMemberArt>
				<MemberType>ART_DEF_UNIT_MEMBER_POLARBEARGUARD</MemberType>
				<MemberCount>10</MemberCount>
			</UnitMemberArt>
		</UnitArtInfo>
	</UnitArtInfos>

	<UnitMemberArtInfos>
		<UnitMemberArtInfo>
			<Type>ART_DEF_UNIT_MEMBER_POLARBEARGUARD</Type>
			<fScale>0.15</fScale>
			<Granny>Art/Units/bear.fxsxml</Granny>
			<Combat>
				<Defaults>ART_DEF_TEMPLATE_SOLDIER</Defaults>
				<Weapon>
					<WeaponTypeTag>BLUNT</WeaponTypeTag>
					<WeaponTypeSoundOverrideTag>BLUNT</WeaponTypeSoundOverrideTag>
				</Weapon>
			</Combat>
			<MaterialTypeTag>CLOTH</MaterialTypeTag>
			<MaterialTypeSoundOverrideTag>FLESH</MaterialTypeSoundOverrideTag>
		</UnitMemberArtInfo>
	</UnitMemberArtInfos>
</GameData>
  1. Table <UnitArtInfos> and its submember <UnitMemberArt> are no longer used in mods.
  2. Table <UnitMemberArtInfos> and its submembers are no longer used in mods.
  3. Unit art defines now (and have for some time) require use of tables <ArtDefine_UnitInfos>, <ArtDefine_UnitInfoMemberInfos>, <ArtDefine_UnitMemberInfos>, <ArtDefine_StrategicView>, <ArtDefine_UnitMemberCombats>, and <ArtDefine_UnitMemberCombatWeapons>
  4. Like this, copied from one of DoktorApplejuice's mods:
    Code:
    <GameData>
    	<ArtDefine_UnitInfos>
    		<Row>
    			<Type>ART_DEF_UNIT_SAILORSENSHI</Type>
    			<DamageStates>1</DamageStates>
    			<Formation>Scout</Formation>
    		</Row>
    	</ArtDefine_UnitInfos>
    	<ArtDefine_UnitInfoMemberInfos>
    		<Row>
    			<UnitInfoType>ART_DEF_UNIT_SAILORSENSHI</UnitInfoType>
    			<UnitMemberInfoType>ART_DEF_UNIT_MEMBER_SAILORSENSHI</UnitMemberInfoType>
    			<NumMembers>1</NumMembers>
    		</Row>
    	</ArtDefine_UnitInfoMemberInfos>
    	<ArtDefine_UnitMemberInfos>
    		<Row>
    			<Type>ART_DEF_UNIT_MEMBER_SAILORSENSHI</Type>
    			<Scale>0.200000000596046</Scale>
    			<Model>SailorSenshi.fxsxml</Model>
    			<MaterialTypeTag>CLOTH</MaterialTypeTag>
    			<MaterialTypeSoundOverrideTag>FLESH</MaterialTypeSoundOverrideTag>
    		</Row>
    	</ArtDefine_UnitMemberInfos>
    	<ArtDefine_UnitMemberCombats>
    		<Row>
    			<UnitMemberType>ART_DEF_UNIT_MEMBER_SAILORSENSHI</UnitMemberType>
    			<EnableActions>Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge</EnableActions>
    			<ShortMoveRadius>12.0</ShortMoveRadius>
    			<ShortMoveRate>0.349999994039536</ShortMoveRate>
    			<TargetHeight>8.0</TargetHeight>
    			<HasRefaceAfterCombat>1</HasRefaceAfterCombat>
    		</Row>
    	</ArtDefine_UnitMemberCombats>
    	<ArtDefine_UnitMemberCombatWeapons>
    		<Row>
    			<UnitMemberType>ART_DEF_UNIT_MEMBER_SAILORSENSHI</UnitMemberType>
    			<Index>0</Index>
    			<SubIndex>0</SubIndex>
    			<WeaponTypeTag>BLUNT</WeaponTypeTag>
    			<WeaponTypeSoundOverrideTag>SPEAR</WeaponTypeSoundOverrideTag>
    		</Row>
    	</ArtDefine_UnitMemberCombatWeapons>
    	<ArtDefine_StrategicView>
    		<Row>
    			<StrategicViewType>ART_DEF_UNIT_SAILORSENSHI</StrategicViewType>
    			<TileType>Unit</TileType>
    			<Asset>SV_Pathfinder.dds</Asset>
    		</Row>
    	</ArtDefine_StrategicView>
    </GameData>

I've used the warrior xml art define and modified it, yeah, this one is good i just completed my next civilization, but, one more thing for now is, do you know how to make custom promotions?
 
I've used the warrior xml art define and modified it, yeah, this one is good i just completed my next civilization, but, one more thing for now is, do you know how to make custom promotions?

The table name is UnitPromotions; see here for the columns.
 
They are in the .fpk files. Search the forum for "Dragon Unpacker" to find the utility to unpack them. There is another utility (which I can never remember the name of - cue Nutty berating me again - and is bookmarked on my PC at home) which you may need to convert the compressed dds files into usable jpeg/png files
 
They are in the .fpk files. Search the forum for "Dragon Unpacker" to find the utility to unpack them. There is another utility (which I can never remember the name of - cue Nutty berating me again - and is bookmarked on my PC at home) which you may need to convert the compressed dds files into usable jpeg/png files

I downloaded Dragon Unpacker and all i got is this messy DDS file:
e5kIwSP.png
 
Did the input directory have both the garbled DDS file AND - this is important - also another DDS file which has the same name as the garbled one but with "_index" tacked on at the end? Because that one is required too. For some reason. I honestly couldn't tell you why Firaxis felt the need to garble the files to begin with.
 
Back
Top Bottom