[SOLVED] Agenda and Leader Trait giving errors

[RFormica]

I have decided to revive my Edward IV mod in SQL, and I did get the art to work (yay!)
However, my Database.log is giving me these errors:

Spoiler database.log :

[513004.736] [Localization]: Validating Foreign Key Constraints...
[513004.737] [Localization]: Passed Validation.
[513004.747] [Configuration]: Validating Foreign Key Constraints...
[513004.747] [Configuration]: Passed Validation.
[513018.502] [FullTextSearch]: Initializing FullTextSearch
[513018.893] [Gameplay]: Validating Foreign Key Constraints...
[513018.911] [Gameplay]: Passed Validation.
[513020.774] [Configuration]: Validating Foreign Key Constraints...
[513020.774] [Configuration]: Passed Validation.
[513045.632] [FullTextSearch]: FTS - Creating Context
[513088.742] [Configuration]: Validating Foreign Key Constraints...
[513088.742] [Configuration]: Passed Validation.
[513090.036] [Gameplay] ERROR: near "Tier": syntax error
[513090.092] [Gameplay] ERROR: near "INSERT": syntax error
[513090.092] [Gameplay] ERROR: FOREIGN KEY constraint failed
[513090.092] [Gameplay] ERROR: FOREIGN KEY constraint failed
[513090.092] [Gameplay]: Validating Foreign Key Constraints...
[513090.098] [Gameplay] ERROR: Invalid Reference on HistoricalAgendas.AgendaType - "AGENDA_RF_METHOD_AND_ORDER" does not exist in Agendas
[513090.098] [Gameplay] ERROR: Invalid Reference on LeaderTraits.TraitType - "TRAIT_LEADER_RF_IN_ALL_CHRISTENDOM" does not exist in Traits
[513090.106] [Gameplay]: Failed Validation.
[513090.135] [Gameplay]: Validating Foreign Key Constraints...
[513090.148] [Gameplay]: Passed Validation.
[513092.675] [FullTextSearch]: FTS - Creating Context
[513092.827] [Configuration]: Validating Foreign Key Constraints...
[513092.827] [Configuration]: Passed Validation.
[513264.045] [FullTextSearch]: FullTextSearch - Shutting down

I have highlighted the issues. In addition to 2 syntax errors, it says that my agenda does not exist in agendas and my trait does not exist in traits... although I have checked those tables multiple times and they do exist in those!
My GameDefines file is uploaded.

 

[LeeS]

INSERT INTO AiListTypes	
		(ListType)
VALUES	('RF_EdwardIVBuildings'),
		('RF_EdwardIVCivics'),
		('RF_EdwardIVTechs'),

This causes the rest of the code in the file to be discarded by the game.

"does not exist in [TableName]" errors means it is not successfully loaded into the game's database. It is not saying the string is not present in the files of the mod. You must fix all fatal syntax errors within a file in order to get everything in the file to successfully load into the game's database.

The word "Tier" is not even used within the SQL file you attached so the error related to it cannot be coming from that file.

------------------------

[edit] further look through your sql file shows additional places where you have a comma terminating an INSERT block instead of the needed semi-colon.

they all appear to be in the section of the file

-- LEADER: AI

 

[LeeS]

This really doesn't look right either

INSERT INTO Modifiers	
	(ModifierId,						ModifierType,								SubjectRequirementSetId)
VALUES	('RF_IN_ALL_CHRISTENDOM_CAPITAL_CITY_INFLUENCE',	'MODIFIER_MODIFIER_PLAYER_CAPITAL_CITY_ADJUST_CITY_YIELD_CHANGE',	null);
--------------------------------------------------------------------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierArguments
	(ModifierId,						Name,		Value)
VALUES	('RF_IN_ALL_CHRISTENDOM_CAPITAL_CITY_INFLUENCE',	'YieldType',	'PSUEDOYIELD_INFLUENCE'),
	('RF_IN_ALL_CHRISTENDOM_CAPITAL_CITY_INFLUENCE',	'Amount',	2);

• Are you sure PseudoYields will even be implemented in any way?
• I don't see where you are using RF_IN_ALL_CHRISTENDOM_CAPITAL_CITY_INFLUENCE
• You aren't using this either: MODIFIER_MODIFIER_PLAYER_CAPITAL_CITY_ADJUST_CITY_YIELD_CHANGE. Plus it looks like a typo in the ModifierType.

 

[RFormica]

The double modifier is a typo; and I'm not sure at all whether the Psuedoyields will be implemented; the idea is that you will generate +2 more influence than is normal (and adding it to the capital seems like the best way to do that)

 

[RFormica]

Changed his unique ability to providing +3 Great General Points per turn.