Civ/Leader mod builds, doesn't load/crashes/other issues in-game.

[Sailor Cat]

V:

 

[LeeS]

1. These localization (in-game text) error messages are really one message:

   [2530383.807] [Localization] ERROR: UNIQUE constraint failed: LocalizedText.Language, LocalizedText.Tag
   [2530383.807] [Localization]: While executing - 'insert into LocalizedText('Tag', 'Language', 'Text') values (?, ?, ?);'
   [2530383.807] [Localization]: In XMLSerializer while inserting row into table insert into LocalizedText('Tag', 'Language', 'Text') with  values (LOC_CIVILIZATION_PERSIA_NAME, en_US, Persia, ).
   [2530383.807] [Localization]: In XMLSerializer while updating table LocalizedText from file GameText.xml.
   [2530383.807] [Localization] ERROR: UNIQUE constraint failed: LocalizedText.Language, LocalizedText.Tag

   They are saying that you are attempting to re-enter a tag called LOC_CIVILIZATION_PERSIA_NAME, and that this occurs in file GameText.xml. You cannot re-define the same tag-names as already existi within the game. This causes a "UNIQUE constraint failed" error and the game ceases to read anything further from the file where the error occured.
   
   This causes you to have a bunch of tag-names which never sucessfully get defined and so the game defaults to using whatever you enter for "Name", "Description", etc., as direct text rather than a lookup reference.
2. These two errors are almost certainly occuring in an SQL file and are essentially the same type of error as the one just discussed

   [2530431.234] [Gameplay] ERROR: UNIQUE constraint failed: Types.Type
   [2530431.234] [Gameplay] ERROR: UNIQUE constraint failed: Types.Type

   You cannot redefine anything the game already has. If we compare the time-stamp of "2530431.234" to what is in your modding log, we find this was being executed

   [2530431.233] Status: UpdateDatabase - Loading Core/GameDefines.sql
   [2530431.234] Warning: UpdateDatabase - Error Loading SQL.

   This tells us that you have almost certainly attempted to re-add an existing "Type" somewhere within "Core/GameDefines.sql"
   
   Anything farther into the file than the error being reported will be ignored by the game
3. Given that you are being shunted back to the main menu there ought to be more within Database.log than that which you posted. There should be at the least an Invalid Reference error and there is none.
4. Without the mod itself to look at it is nigh on to impossible to tell what else you might be doing wrong. But Even if you post the mod I won't be able to help you figure out the issues with the art if your mistakes are not to do with incorrect modinfo procedures, for example.

 

[LeeS]

No. it doesn't really look right. Macedon is using

<ModifierType>MODIFIER_PLAYER_CAPTURED_CITY_ATTACH_MODIFIER</ModifierType>

and Jadwiga is using

<ModifierType>MODIFIER_PLAYER_ADJUST_CULTURE_BOMB_CONVERTS_CITY</ModifierType>

There is no Modifier Type called 'MODIFIER_PLAYER_CAPTURED_CITY' that I can find through a search of the game's files.

 

[LeeS]

Your modding log shows:

359.[2766351.775] Status: UpdateDatabase - Loading Core/GameDefines.sql
360.[2766351.776] Warning: UpdateDatabase - Error Loading SQL.

So you need to look at your Database log for a report of a "syntax error" to know whether it is a "near" error, a too many columns or not enough columns error, or what.