My Civ not appearing in game

[thinkingnut]

Hi All,

My custom is not a selectable option in the "create game" page even though I have enabled it as a mod. May I ask why, and how do I fix this?

If anyone can help me take a look, I'll be extremely grateful. Since it's bigger than 10 MB, I'm using File.fm to share: https://files.fm/u/5kkssu88.

Cheers.

 

[LeeS]

1. None of these files belong in a <FrontEndActions> <UpdateDatabase> action:

         <File>Core/Civilization/NeoChina.xml</File>
         <File>Core/Civilization/WarrensNeoChinaBuilding.xml</File>  
         <File>Core/Civilization/WarrensNeoChinaUnits.xml</File>

   This just clogs the database log to no purpose and makes for confusion in attempting to debug what is wrong with the mod.
2. Cleaning this from the modinfo file reveals the following error in Database.log

   [544561.393] [Configuration] ERROR: no such column: CivilizationName

   The timestamp for this "[Configuration]" (<FrontEndActions>) error traces to these lines in Modding.log:

   [544561.393] Status: ModdingUpdateConfigurationDatabase - Loading Core/Leaders/Wen/ChinaWen_Config.sql
   [544561.393] Warning: ModdingUpdateConfigurationDatabase - Error Loading SQL.

   This means your file is never completely being loaded into the game, and thus the civilization is non-existent for the game set-up menus.
3. Your error tracks to this block of code

   INSERT INTO Players	
   	(CivilizationType,		Portrait,			PortraitBackground,		LeaderType,		LeaderName,			LeaderIcon,		LeaderAbilityName,				LeaderAbilityDescription,				LeaderAbilityIcon,	CivilizationName,	CivilizationIcon,			CivilizationAbilityName, CivilizationAbilityDescription, CivilizationAbilityIcon)
   SELECT	'CIVILIZATION_NEOCHINA',	'LEADER_JFD_WEN_NEUTRAL.dds',	'LEADER_DEFAULT_BACKGROUND',	'LEADER_JFD_WEN',	'LOC_LEADER_JFD_WEN_NAME',	'ICON_LEADER_JFD_WEN',	'LOC_TRAIT_LEADER_JFD_SUTRA_ASOKA_NAME',	'LOC_TRAIT_LEADER_JFD_SUTRA_ASOKA_DESCRIPTION',		'ICON_LEADER_JFD_WEN',	CivilizationName,	'ICON_CIVILIZATION_JFD_CHINA_WEN',	CivilizationAbilityName, CivilizationAbilityDescription, 'ICON_CIVILIZATION_JFD_CHINA_WEN'
   AND EXISTS (SELECT * FROM JFD_GlobalUserSettings WHERE Type = 'JFD_CHINA_WEN' AND Value = 1);

   • You are attempting to apply the value for columns 'CivilizationName', 'CivilizationAbilityName', and 'CivilizationAbilityDescription' from an undefined source, and the best the game can do is attempt to apply the value from the 'JFD_GlobalUserSettings' table.
   • You need to directly state the LOC_SOMETHING_SOMETHING names of these for your civ.
   • Putting a valid value for a LOC_SOMETHING for those columns cures the issue for me and your leader begins to appear in the selection screen, altho with issues from an additional error in the file as mentioned below.
4. You have a similar issue to that already mentioned here in this block of code

   -------------------------------------
   -- PlayerItems
   -------------------------------------	
   INSERT INTO PlayerItems	
   		(CivilizationType,		LeaderType,			 Type, Icon, Name, Description, SortIndex)
   SELECT	'CIVILIZATION_NEOCHINA',	'LEADER_JFD_WEN',	 Type, Icon, Name, Description, SortIndex
   AND EXISTS (SELECT * FROM JFD_GlobalUserSettings WHERE Type = 'JFD_CHINA_WEN' AND Value = 1);

   The solution will be the same.
5. You still have at least one outstanding error because I am getting this error, which shoves me back to the main menu

   [545774.586] [Gameplay] ERROR: Invalid Reference on ModifierArguments.ModifierId - "TRAIT_EXTRAINDUSTRIOUSWORKER" does not exist in Modifiers

   You've never defined TRAIT_EXTRAINDUSTRIOUSWORKER as a <ModifierId> in table <Modifiers>.
6. If you are running on a Mac you need to look through your folders under "Library" or "Libraries" (as I understand it: I don't run Mac) to find where error logs and the like are placed because you cannot very effectively debug anything without being able to see what is coming up in Database.log and Modding.log.

 

[thinkingnut]

Hmm, I've done all that you've said. The leader is now showing up in the game menu (thank you very much, LeeS), but a couple of new issues arise: (Note: I've compressed all the below mentioned pics and pdf file into an Archive zip file: https://files.fm/u/bcsknvrh. The revised mod is here: https://files.fm/u/cvrzzfdz.)

1. He is still attached to the base gamed China's set (Dynastic Cycle, Great Wall, Crouching Tiger) and not to my custom civ's set (Organised Workforce, Miele Silo, Industrious Worker). Please see pic 1 and 2.

2. The UU for my civ that replaces the Builder, the Industrious Worker, doesn't seem to be replacing properly. Please see pic 3. And for some reason, the icon for it is that of a Settler in the production sidebar and a Monument as the city production icon (please see pic 4). The unit also is unable to perform any of the usual Builder tasks, eg. chopping forests even after I have researched Mining (please see pic 5).

3. Then there is the issue of the Granary replacement for my custom civ, the Miele Silo, not registering with the game at all. When I hover my mouse over the Granary in the tech tree, it still says Granary. Please see pic 6.

4. I've also copied and pasted the resultant Database.log text into a pdf file for your inspection, as I have no idea what it means.

May I ask how do I fix this? Thank you, LeeS.