Unable to Select Civ on Setup Screen/Config Text Key Issues

clapyourhands · Oct 17, 2017

I was working on the base tutorial template provided when you download ModBuddy. This initially worked in that the civ showed up on the menu, but selecting it would give the start game bug. I then moved over my data into sql files rather than xml; this removed the civ from the menu. However, my civ can still be selected by the random civ choice and is playable if selected by this (I can guarantee this by creating a custom game and creating 19 vanilla civ AIs with no duplicate leaders, so that I always play as my own custom civ). The configurational text keys are not loaded if my civ loads like this, however, though the ones updated in-game are.

The logs don't show anything out of the ordinary. I have been using them to work out bugs, specifically the Modding, LUA, and Database logs, but there are no errors I can see in them as of now; I personally think it's because there's an issue in the text configuration file itself, which wouldn't be seen as an error. But I can't find anything wrong with the file itself. Furthermore, when I copied the text file of a known working civ mod into my own and superficially changed the tags to match my own text keys, the text still did not load, suggesting that the issue lies in how the file is loaded rather than a syntax error. Can someone help me figure out what's wrong? Attached are the log files and a copy of my mod, though it still largely looks like the tutorial files at this point.

Spoiler LUA log (second half only) :

Spoiler Modding Log :

Spoiler Database log :

LeeS · Oct 17, 2017

File Config.sql is incorrectly written. The syntax appears to be ok, but the method you are using is no good.

This will have the effect of telling the game to add 'CIVILIZATION_TONGVA' when 'CIVILIZATION_TONGVA' is already added to the Players and PlayerItems items tables. But 'CIVILIZATION_TONGVA' does not yet exist in those tables so the game cannot successfully SELECT .. FROM.

Code:

INSERT INTO Players	
	(CivilizationType,	LeaderType,		LeaderName,			LeaderIcon,			LeaderAbilityName,			LeaderAbilityDescription,			LeaderAbilityIcon,		CivilizationName,		CivilizationIcon,		CivilizationAbilityName,		CivilizationAbilityDescription,			CivilizationAbilityIcon,	Portrait)
SELECT	'CIVILIZATION_TONGVA',	'LEADER_TOYPURINA',	'LOC_LEADER_TOYPURINA_NAME',	'ICON_LEADER_JASPER_KITTY',	'LOC_TRAIT_CIVILIZATION_TONGVA_NAME',	'LOC_TRAIT_CIVILIZATION_TONGVA_DESCRIPTION',	'ICON_LEADER_JASPER_KITTY',	'LOC_CIVILIZATION_TONGVA_NAME',	'ICON_CIVILIZATION_FELINE',	'LOC_TRAIT_LEADER_TOYPURINA_NAME',	'LOC_TRAIT_CIVILIZATION_TONGVA_DESCRIPTION',	'ICON_CIVILIZATION_FELINE',	'LEADER_JASPER_KITTY_NEUTRAL'
FROM Players WHERE CivilizationType = 'CIVILIZATION_TONGVA' AND LeaderType = 'LEADER_TOYPURINA';
	
INSERT INTO PlayerItems	
	(CivilizationType,		LeaderType,		Type, Icon, Name, Description, SortIndex)
SELECT	'CIVILIZATION_TONGVA',		'LEADER_TOYPURINA',	'IMPROVEMENT_KI', 'ICON_BUILDING_LITTER_BOX', 'LOC_IMPROVEMENT_KI_NAME', 'LOC_IMPROVEMENT_KI_DESCRIPTION', 10
FROM PlayerItems WHERE CivilizationType = 'CIVILIZATION_TONGVA' AND LeaderType = 'LEADER_TOYPURINA';

You want a simple INSERT INTO without the SELECT .. FROM clause.

Code:

INSERT INTO Players	
	(CivilizationType,	LeaderType,		LeaderName,			LeaderIcon,			LeaderAbilityName,			LeaderAbilityDescription,			LeaderAbilityIcon,		CivilizationName,		CivilizationIcon,		CivilizationAbilityName,		CivilizationAbilityDescription,			CivilizationAbilityIcon,	Portrait)
VALUES	('CIVILIZATION_TONGVA',	'LEADER_TOYPURINA',	'LOC_LEADER_TOYPURINA_NAME',	'ICON_LEADER_JASPER_KITTY',	'LOC_TRAIT_CIVILIZATION_TONGVA_NAME',	'LOC_TRAIT_CIVILIZATION_TONGVA_DESCRIPTION',	'ICON_LEADER_JASPER_KITTY',	'LOC_CIVILIZATION_TONGVA_NAME',	'ICON_CIVILIZATION_FELINE',	'LOC_TRAIT_LEADER_TOYPURINA_NAME',	'LOC_TRAIT_CIVILIZATION_TONGVA_DESCRIPTION',	'ICON_CIVILIZATION_FELINE',	'LEADER_JASPER_KITTY_NEUTRAL');

INSERT INTO PlayerItems	
	(CivilizationType,		LeaderType,		Type,			Icon,				Name,				Description,				SortIndex)
VALUES	('CIVILIZATION_TONGVA',		'LEADER_TOYPURINA',	'IMPROVEMENT_KI',	'ICON_BUILDING_LITTER_BOX',	'LOC_IMPROVEMENT_KI_NAME',	'LOC_IMPROVEMENT_KI_DESCRIPTION',	10);

Not sure if you have other errors in the code of the mod. I did not attempt to load the mod in-game.

clapyourhands · Oct 17, 2017

LeeS said:

File Config.sql is incorrectly written. The syntax appears to be ok, but the method you are using is no good.

This will have the effect of telling the game to add 'CIVILIZATION_TONGVA' when 'CIVILIZATION_TONGVA' is already added to the Players and PlayerItems items tables. But 'CIVILIZATION_TONGVA' does not yet exist in those tables so the game cannot successfully SELECT .. FROM.

Code:

INSERT INTO Players   
    (CivilizationType,    LeaderType,        LeaderName,            LeaderIcon,            LeaderAbilityName,            LeaderAbilityDescription,            LeaderAbilityIcon,        CivilizationName,        CivilizationIcon,        CivilizationAbilityName,        CivilizationAbilityDescription,            CivilizationAbilityIcon,    Portrait)
SELECT    'CIVILIZATION_TONGVA',    'LEADER_TOYPURINA',    'LOC_LEADER_TOYPURINA_NAME',    'ICON_LEADER_JASPER_KITTY',    'LOC_TRAIT_CIVILIZATION_TONGVA_NAME',    'LOC_TRAIT_CIVILIZATION_TONGVA_DESCRIPTION',    'ICON_LEADER_JASPER_KITTY',    'LOC_CIVILIZATION_TONGVA_NAME',    'ICON_CIVILIZATION_FELINE',    'LOC_TRAIT_LEADER_TOYPURINA_NAME',    'LOC_TRAIT_CIVILIZATION_TONGVA_DESCRIPTION',    'ICON_CIVILIZATION_FELINE',    'LEADER_JASPER_KITTY_NEUTRAL'
FROM Players WHERE CivilizationType = 'CIVILIZATION_TONGVA' AND LeaderType = 'LEADER_TOYPURINA';
   
INSERT INTO PlayerItems   
    (CivilizationType,        LeaderType,        Type, Icon, Name, Description, SortIndex)
SELECT    'CIVILIZATION_TONGVA',        'LEADER_TOYPURINA',    'IMPROVEMENT_KI', 'ICON_BUILDING_LITTER_BOX', 'LOC_IMPROVEMENT_KI_NAME', 'LOC_IMPROVEMENT_KI_DESCRIPTION', 10
FROM PlayerItems WHERE CivilizationType = 'CIVILIZATION_TONGVA' AND LeaderType = 'LEADER_TOYPURINA';

You want a simple INSERT INTO without the SELECT .. FROM clause.

Code:

INSERT INTO Players   
    (CivilizationType,    LeaderType,        LeaderName,            LeaderIcon,            LeaderAbilityName,            LeaderAbilityDescription,            LeaderAbilityIcon,        CivilizationName,        CivilizationIcon,        CivilizationAbilityName,        CivilizationAbilityDescription,            CivilizationAbilityIcon,    Portrait)
VALUES    ('CIVILIZATION_TONGVA',    'LEADER_TOYPURINA',    'LOC_LEADER_TOYPURINA_NAME',    'ICON_LEADER_JASPER_KITTY',    'LOC_TRAIT_CIVILIZATION_TONGVA_NAME',    'LOC_TRAIT_CIVILIZATION_TONGVA_DESCRIPTION',    'ICON_LEADER_JASPER_KITTY',    'LOC_CIVILIZATION_TONGVA_NAME',    'ICON_CIVILIZATION_FELINE',    'LOC_TRAIT_LEADER_TOYPURINA_NAME',    'LOC_TRAIT_CIVILIZATION_TONGVA_DESCRIPTION',    'ICON_CIVILIZATION_FELINE',    'LEADER_JASPER_KITTY_NEUTRAL');

INSERT INTO PlayerItems   
    (CivilizationType,        LeaderType,        Type,            Icon,                Name,                Description,                SortIndex)
VALUES    ('CIVILIZATION_TONGVA',        'LEADER_TOYPURINA',    'IMPROVEMENT_KI',    'ICON_BUILDING_LITTER_BOX',    'LOC_IMPROVEMENT_KI_NAME',    'LOC_IMPROVEMENT_KI_DESCRIPTION',    10);

Not sure if you have other errors in the code of the mod. I did not attempt to load the mod in-game.

That did it. I've never used SQL prior to the mod so I copied the format from another mod file, thinking it would be similar. Thank you so much!

Unable to Select Civ on Setup Screen/Config Text Key Issues

clapyourhands

Prince

Attachments

LeeS

Imperator

clapyourhands

Prince

Similar threads