Modded Civ does not appear in selection screen

[GlowingIceicle]

Hello,

Recently I tried to make a joke mod for myself in Civ V, but I can't see it in the set up screen. I'm very new to modding, so I read Kael's guide and the thread at http://forums.civfanatics.com/showthread.php?t=493900 to try and construct my own civilization out of components from a couple other mods I enjoyed.

Assets were borrowed from PCMR.

Unfortunately, it doesn't seem to be working. If anyone can point out what I've done wrong from my solution, it would be much appreciated.

EDIT: Looking at the database log, it seems like this is the problem:

[229885.765] Invalid Reference on Civilization_BuildingClassOverrides.CivilizationType - "CIVILIZATION_KUWAIT" does not exist in Civilizations
[229885.859] Invalid Reference on Civilization_UnitClassOverrides.CivilizationType - "CIVILIZATION_KUWAIT" does not exist in Civilizations

How should I go about fixing this? Has anyone ever encountered this problem before?

 

[LeeS]

Hello,

Recently I tried to make a joke mod for myself in Civ V, but I can't see it in the set up screen. I'm very new to modding, so I read Kael's guide and the thread at http://forums.civfanatics.com/showthread.php?t=493900 to try and construct my own civilization out of components from a couple other mods I enjoyed.

Assets were borrowed from PCMR.

Unfortunately, it doesn't seem to be working. If anyone can point out what I've done wrong from my solution, it would be much appreciated.

EDIT: Looking at the database log, it seems like this is the problem:

[229885.765] Invalid Reference on Civilization_BuildingClassOverrides.CivilizationType - "CIVILIZATION_KUWAIT" does not exist in Civilizations
[229885.859] Invalid Reference on Civilization_UnitClassOverrides.CivilizationType - "CIVILIZATION_KUWAIT" does not exist in Civilizations

How should I go about fixing this? Has anyone ever encountered this problem before?

Your problem is that the file with the definition of CIVILIZATION_KUWAIT is being discarded by the game because you have more than one occurance of:

		<Row Tag="TXT_KEY_CIV_KUWAIT_SHORT_DESC">
			<Text>Kuwait</Text>
		</Row>

within the <Language_en_US> table. This is being messaged to you within the Database.log file by these lines:

[108600.015] columns Language, Tag are not unique
[108600.015] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[108600.015] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with  values (TXT_KEY_CIV_KUWAIT_SHORT_DESC, Kuwait, ).
[108600.015] In XMLSerializer while updating table Language_en_US from file XML/Core/Kuwait.xml.
[108600.015] columns Language, Tag are not unique

Your leader file is also failing to be loaded into the game because of a repeat of an existing leader name. This is the error in the Database.log:

[108600.000] column Type is not unique
[108600.000] While executing - 'insert into Leaders('Type', 'Description', 'Civilopedia', 'CivilopediaTag', 'VictoryCompetitiveness', 'WonderCompetitiveness', 'MinorCivCompetitiveness', 'Boldness', 'DiploBalance', 'WarmongerHate', 'WorkAgainstWillingness', 'WorkWithWillingness', 'DenounceWillingness', 'DoFWillingness', 'Loyalty', 'Neediness', 'Forgiveness', 'Chattiness', 'Meanness', 'PortraitIndex', 'IconAtlas') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);'
[108600.000] In XMLSerializer while inserting row into table insert into Leaders('Type', 'Description', 'Civilopedia', 'CivilopediaTag', 'VictoryCompetitiveness', 'WonderCompetitiveness', 'MinorCivCompetitiveness', 'Boldness', 'DiploBalance', 'WarmongerHate', 'WorkAgainstWillingness', 'WorkWithWillingness', 'DenounceWillingness', 'DoFWillingness', 'Loyalty', 'Neediness', 'Forgiveness', 'Chattiness', 'Meanness', 'PortraitIndex', 'IconAtlas') with  values (LEADER_ALEXANDER, TXT_KEY_LEADER_ALEXANDER, TXT_KEY_LEADER_ALEXANDER_PEDIA, TXT_KEY_CIVILOPEDIA_LEADERS_ALEXANDER, 8, 7, 3, 8, 3, 2, 0, 0, 7, 4, 4, 4, 5, 7, 7, 1, CIV_COLOR_ATLAS, ).
[108600.000] In XMLSerializer while updating table Leaders from file XML/Core/LEADER_ALEXANDER.xml.
[108600.000] column Type is not unique

This means that your re-direction of Alexander to use the trait TRAIT_GR8_ST8 is also failing, along with the trait itself, since it is defined within the same file.

You are also stating the <Civilization_BuildingClassOverrides> and <Civilization_UnitClassOverrides> twice. Once within the file for the unique building and unit, and once within the file for the civilization. Re-write so that there is only one occurance of these specifications.

This is also a bit strange:

Spoiler :

	<Unit_FreePromotions>
			<Row>
				<UnitType>UNIT_KUWAITI_308</UnitType>
				<PromotionType>PROMOTION_SHOCK_1</PromotionType>
			</Row>
			<Row>
				<UnitType>UNIT_KUWAITI_308</UnitType>
				<PromotionType>PROMOTION_SHOCK_2</PromotionType>
			</Row>
			<Row>
				<UnitType>UNIT_KUWAITI_308</UnitType>
				<PromotionType>PROMOTION_SHOCK_3</PromotionType>
			</Row>
			<Row>
				<UnitType>UNIT_KUWAITI_308</UnitType>
				<PromotionType>PROMOTION_DRILL_1</PromotionType>
			</Row>
			<Row>
				<UnitType>UNIT_KUWAITI_308</UnitType>
				<PromotionType>PROMOTION_DRILL_2</PromotionType>
			</Row>
			<Row>
				<UnitType>UNIT_KUWAITI_308</UnitType>
				<PromotionType>PROMOTION_DRILL_3</PromotionType>
			</Row>
	</Unit_FreePromotions>

since if I am understanding properly what you are trying to do, you are defining the unit as an Archery-CombatClass, and those are promotions for mounted, melee, armor, and gun Combat-Classes. Archery units use PROMOTION_ACCURACY_1, etc., and PROMOTION_BARRAGE_1, etc.

Taken from the Firaxis file for Unit Promotions:

Spoiler :

	<UnitPromotions_UnitCombats>
		<Row>
			<PromotionType>PROMOTION_SHOCK_1</PromotionType>
			<UnitCombatType>UNITCOMBAT_MOUNTED</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_SHOCK_1</PromotionType>
			<UnitCombatType>UNITCOMBAT_MELEE</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_SHOCK_1</PromotionType>
			<UnitCombatType>UNITCOMBAT_GUN</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_SHOCK_1</PromotionType>
			<UnitCombatType>UNITCOMBAT_ARMOR</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_SHOCK_2</PromotionType>
			<UnitCombatType>UNITCOMBAT_MOUNTED</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_SHOCK_2</PromotionType>
			<UnitCombatType>UNITCOMBAT_MELEE</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_SHOCK_2</PromotionType>
			<UnitCombatType>UNITCOMBAT_GUN</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_SHOCK_2</PromotionType>
			<UnitCombatType>UNITCOMBAT_ARMOR</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_SHOCK_3</PromotionType>
			<UnitCombatType>UNITCOMBAT_MOUNTED</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_SHOCK_3</PromotionType>
			<UnitCombatType>UNITCOMBAT_MELEE</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_SHOCK_3</PromotionType>
			<UnitCombatType>UNITCOMBAT_GUN</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_SHOCK_3</PromotionType>
			<UnitCombatType>UNITCOMBAT_ARMOR</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_DRILL_1</PromotionType>
			<UnitCombatType>UNITCOMBAT_MOUNTED</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_DRILL_1</PromotionType>
			<UnitCombatType>UNITCOMBAT_MELEE</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_DRILL_1</PromotionType>
			<UnitCombatType>UNITCOMBAT_GUN</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_DRILL_1</PromotionType>
			<UnitCombatType>UNITCOMBAT_ARMOR</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_DRILL_2</PromotionType>
			<UnitCombatType>UNITCOMBAT_MOUNTED</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_DRILL_2</PromotionType>
			<UnitCombatType>UNITCOMBAT_MELEE</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_DRILL_2</PromotionType>
			<UnitCombatType>UNITCOMBAT_GUN</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_DRILL_2</PromotionType>
			<UnitCombatType>UNITCOMBAT_ARMOR</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_DRILL_3</PromotionType>
			<UnitCombatType>UNITCOMBAT_MOUNTED</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_DRILL_3</PromotionType>
			<UnitCombatType>UNITCOMBAT_MELEE</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_DRILL_3</PromotionType>
			<UnitCombatType>UNITCOMBAT_GUN</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_DRILL_3</PromotionType>
			<UnitCombatType>UNITCOMBAT_ARMOR</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_ACCURACY_1</PromotionType>
			<UnitCombatType>UNITCOMBAT_ARCHER</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_ACCURACY_1</PromotionType>
			<UnitCombatType>UNITCOMBAT_SIEGE</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_ACCURACY_2</PromotionType>
			<UnitCombatType>UNITCOMBAT_ARCHER</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_ACCURACY_2</PromotionType>
			<UnitCombatType>UNITCOMBAT_SIEGE</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_ACCURACY_3</PromotionType>
			<UnitCombatType>UNITCOMBAT_ARCHER</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_ACCURACY_3</PromotionType>
			<UnitCombatType>UNITCOMBAT_SIEGE</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_BARRAGE_1</PromotionType>
			<UnitCombatType>UNITCOMBAT_ARCHER</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_BARRAGE_1</PromotionType>
			<UnitCombatType>UNITCOMBAT_SIEGE</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_BARRAGE_2</PromotionType>
			<UnitCombatType>UNITCOMBAT_ARCHER</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_BARRAGE_2</PromotionType>
			<UnitCombatType>UNITCOMBAT_SIEGE</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_BARRAGE_3</PromotionType>
			<UnitCombatType>UNITCOMBAT_ARCHER</UnitCombatType>
		</Row>
		<Row>
			<PromotionType>PROMOTION_BARRAGE_3</PromotionType>
			<UnitCombatType>UNITCOMBAT_SIEGE</UnitCombatType>
		</Row>
	</UnitPromotions_UnitCombats>

 

[GlowingIceicle]

Thank you very much! I did as you said and it all worked out. Thanks m8 I really appreci8.

Although, I seem to be facing a completely different problem now:

Spoiler :

Database Log:

Spoiler :

[246602.125] columns StrategicViewType, TileType are not unique
[246602.125] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[246605.453] no such table: ContentPackage.LocalizedText
[246605.453] no such table: ContentPackage.LocalizedText
[246605.453] no such table: ContentPackage.LocalizedText
[246606.578] no such table: ContentPackage.LocalizedText
[246611.734] columns StrategicViewType, TileType are not unique
[246611.734] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[246612.875] no such table: ContentPackage.LocalizedText
[246612.875] no such table: ContentPackage.LocalizedText
[246612.875] no such table: ContentPackage.LocalizedText
[246620.734] Validating Foreign Key Constraints...
[246620.734] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[246620.734] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[246620.734] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[246620.734] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[246620.734] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[246620.734] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[246620.734] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[246620.734] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[246620.734] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[246623.515] Failed Validation.
[246624.046]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 8562384 78106592
PageCache: 6 12
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 8140272 65206848
Scratch: 0 0

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

Prepared Statements:
Current: 6

 

[LeeS]

Yeow ! I'm not sure what's causing that.
You'd have to add the newest version of the mod.

 

[GlowingIceicle]

I've uploaded the new copy to the first post.

 

[TheMarshmallowBear]

You didn't seem to assign a civilization color to Kuwait. But defined the colors.

 

[GlowingIceicle]

Doesn't seem to have done anything
This is the code related to the colors:

Spoiler :

<Colors>
<Row>
<Type>COLOR_PLAYER_KUWAIT_ICON</Type>
<Red>0.592</Red>
<Green>0.196</Green>
<Blue>0.322</Blue>
<Alpha>1.0</Alpha>
</Row>
<Row>
<Type>COLOR_PLAYER_KUWAIT_BACKGROUND</Type>
<Red>0.667</Red>
<Green>0.475</Green>
<Blue>0.224</Blue>
<Alpha>1.0</Alpha>
</Row>
</Colors>
<PlayerColors>
<Row>
<Type>PLAYERCOLOR_KUWAIT</Type>
<PrimaryColor>COLOR_PLAYER_KUWAIT_ICON</PrimaryColor>
<SecondaryColor>COLOR_PLAYER_KUWAIT_BACKGROUND</SecondaryColor>
<TextColor>COLOR_PLAYER_WHITE_TEXT</TextColor>
</Row>
</PlayerColors>

And this is where I assign the color to the civ:

Spoiler :

<DefaultPlayerColors>PLAYERCOLOR_KUWAIT</DefaultPlayerColors>

Here is the database.log from when I last ran the mod:

Spoiler :

[253399.453] no such table: Language_zh_CN
[253399.453] In Query - insert into Language_zh_CN('Tag', 'Text') values (?, ?);
[253399.453] In XMLSerializer while updating table Language_zh_CN from file Localization/IGE_ZH_CN.xml.
[253401.000] Validating Foreign Key Constraints...
[253401.000] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[253401.000] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[253401.000] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[253401.000] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[253401.000] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[253401.000] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[253401.000] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[253401.000] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[253401.000] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[253403.781] Failed Validation.
[253404.312]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 8619792 78106592
PageCache: 7 13
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 8166144 65206848
Scratch: 0 0

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

Prepared Statements:
Current: 12

 

[TheMarshmallowBear]

I don't see the "DefaultColor" on this

		<Civilizations>
			<Row>
				<Type>CIVILIZATION_KUWAIT</Type>
				<Description>TXT_KEY_CIV_KUWAIT_DESC</Description>
				<ShortDescription>TXT_KEY_CIV_KUWAIT_SHORT_DESC</ShortDescription>
				<Adjective>TXT_KEY_CIV_KUWAIT_ADJECTIVE</Adjective>
				<CivilopediaTag>TXT_KEY_CIV5_KUWAIT</CivilopediaTag>
				<ArtStyleType>ARTSTYLE_MIDDLE_EAST</ArtStyleType>
				<ArtStyleSuffix>_AFRI</ArtStyleSuffix>
				<ArtStylePrefix>AFRICAN</ArtStylePrefix>
				<PortraitIndex>1</PortraitIndex>
				<IconAtlas>CIV_COLOR_ATLAS</IconAtlas>
				<MapImage>MapAbbasid512.dds</MapImage>
				<DawnOfManQuote>TXT_KEY_CIV5_DAWN_KUWAIT_TEXT</DawnOfManQuote>
				<DawnOfManImage>DOM_AlRashid.dds</DawnOfManImage>
				<DawnOfManAudio></DawnOfManAudio>
				<SoundtrackTag></SoundtrackTag>
			</Row>
		</Civilizations>

 

[GlowingIceicle]

After setting the DefaultPlayerColors, my original problem of not being able to select the civ comes back.

		<Civilizations>
			<Row>
				<Type>CIVILIZATION_KUWAIT</Type>
				<Description>TXT_KEY_CIV_KUWAIT_DESC</Description>
				<ShortDescription>TXT_KEY_CIV_KUWAIT_SHORT_DESC</ShortDescription>
				<Adjective>TXT_KEY_CIV_KUWAIT_ADJECTIVE</Adjective>
				<CivilopediaTag>TXT_KEY_CIV5_KUWAIT</CivilopediaTag>
				[B]<DefaultPlayerColors>PLAYERCOLOR_KUWAIT</DefaultPlayerColors>[/B]
				<ArtStyleType>ARTSTYLE_MIDDLE_EAST</ArtStyleType>
				<ArtStyleSuffix>_AFRI</ArtStyleSuffix>
				<ArtStylePrefix>AFRICAN</ArtStylePrefix>
				<PortraitIndex>1</PortraitIndex>
				<IconAtlas>CIV_COLOR_ATLAS</IconAtlas>
				<MapImage>MapAbbasid512.dds</MapImage>
				<DawnOfManQuote>TXT_KEY_CIV5_DAWN_KUWAIT_TEXT</DawnOfManQuote>
				<DawnOfManImage>DOM_AlRashid.dds</DawnOfManImage>
				<DawnOfManAudio></DawnOfManAudio>
				<SoundtrackTag></SoundtrackTag>
			</Row>
		</Civilizations>

Log:

Spoiler :

[259250.875] columns StrategicViewType, TileType are not unique
[259250.875] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[259255.187] no such table: ContentPackage.LocalizedText
[259255.187] no such table: ContentPackage.LocalizedText
[259255.187] no such table: ContentPackage.LocalizedText
[259256.312] no such table: ContentPackage.LocalizedText
[259261.609] columns StrategicViewType, TileType are not unique
[259261.609] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[259262.796] no such table: ContentPackage.LocalizedText
[259262.812] no such table: ContentPackage.LocalizedText
[259262.812] no such table: ContentPackage.LocalizedText
[259270.718] Validating Foreign Key Constraints...
[259270.718] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[259270.718] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[259270.718] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[259270.718] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[259270.718] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[259270.718] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[259270.718] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[259270.718] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[259270.718] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[259273.484] Failed Validation.
[259274.015]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 8562384 78106592
PageCache: 6 12
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 8140272 65206848
Scratch: 0 0

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

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

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 8141448 65206848
Scratch: 0 0

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

Prepared Statements:
Current: 6
------------------------------

 

[LeeS]

from the definition of the <Civilizations> table:

<Column name="DefaultPlayerColor" type="text" default="NULL" reference="PlayerColors(Type)"/>

There is no trailing "s" in "DefaultPlayerColor".

Not sure why your log print-out didn't show an invalid column name.

You might want to take a skim through the Work-in-Progress Common Novice-Modder Mistakes reference/guide in the bottom link of my sig.

 

[GlowingIceicle]

That seems to have worked perfectly. Thank you both for helping me out, I'll be sure to check out that guide of yours as well!

 

[TheMarshmallowBear]

from the definition of the <Civilizations> table:

<Column name="DefaultPlayerColor" type="text" default="NULL" reference="PlayerColors(Type)"/>

There is no trailing "s" in "DefaultPlayerColor".

Not sure why your log print-out didn't show an invalid column name.

You might want to take a skim through the Work-in-Progress Common Novice-Modder Mistakes reference/guide in the bottom link of my sig.

I think the Database only fails when it's attempting to use a non-existent table, or invalid Row, Delete, InsertOrAbort etc. commands, but doesn't actually fail when it comes to the specific tags.

Since he didn't define a default color the game simply got confused, I usually get that error several times if I make an error when it came to civ colors.

 

[LeeS]

I think the Database only fails when it's attempting to use a non-existent table, or invalid Row, Delete, InsertOrAbort etc. commands, but doesn't actually fail when it comes to the specific tags.

Since he didn't define a default color the game simply got confused, I usually get that error several times if I make an error when it came to civ colors.

Incorrect column names cause file discard.

 

[ndb997]

Hey can you help me too? When I try out my mod, the civ selection screen looks like this:

Do you know what could be the problem?
Here is the mod file
View attachment Rome2 (v 1).zip
Thanks

 

[LeeS]

These are incorrect because you are attempting to instruct the game that the default unit and building from within a Unit-Class and Building-Class will now be the unique unit and building for your civilization:

<Civilization_UnitClassOverrides>
		<Row>
			<CivilizationType>CIVILIZATION_ROME2</CivilizationType>
			<UnitClassType>UNITCLASS_SWORDSMAN</UnitClassType>
			<UnitType>[COLOR="Red"]UNIT_SWORDSMAN[/COLOR]</UnitType>
		</Row>
	</Civilization_UnitClassOverrides>
	<Civilization_BuildingClassOverrides>
		<Row>
			<CivilizationType>CIVILIZATION_ROME2</CivilizationType>
			<BuildingClassType>BUILDINGCLASS_COURTHOUSE</BuildingClassType>
			<BuildingType>[COLOR="red"]BUILDING_COURTHOUSE[/COLOR]</BuildingType>
		</Row>
	</Civilization_BuildingClassOverrides>

This needs to be eliminated from your civilization file because (a) it does nothing for you, and (b), will in fact confuse the game:

<Leaders>
	<Row>
		<Type>LEADER_JULIUS_CAESER</Type>
	</Row>
</Leaders>

Plus it is no good even though this immediately follows:

<Civilization_Leaders>
	<Row>
		<CivilizationType>CIVILIZATION_ROME2</CivilizationType>
		<LeaderheadType>LEADER_JULIUS_CAESER</LeaderheadType>
	</Row>
</Civilization_Leaders>

Nowhere else do you define anything for a leader called LEADER_JULIUS_CAESER. Your definition of a leader within the Rome2Leader.xml file is all about someone called LEADER_JULIUS. This is helping to confuse the game because also within the leader definition file you have these:

<Description>TXT_KEY_LEADER_JULIUS_CAESER</Description>
<Civilopedia>TXT_KEY_LEADER_JULIUS_CAESER_PEDIA</Civilopedia>
<CivilopediaTag>TXT_KEY_CIVILOPEDIA_LEADERS_JULIUS_CAESER</CivilopediaTag>

You need to get rid of _CAESER in these designations because in certain parts of the civilopedia the game makes assumptions about leader-XML-name character-strings and additional TXT_KEY tag names to be associated with the same leader.

The most basic reason you are getting an empty civilization-selection screen is because of your designation of a leader as being assigned to your civilization, but for the leader designated there is no associated leader-trait, no text, none of the required data to have a correctly-defined leader. The civilization-selection screen is about 70% leader-definition-dependant, and about 30% civilization-definition-dependant as concerns the sorts of errors that incomplete or incorrect definitions of leaders and civilizations will cause.