[GS] [1.0.0.328] Color & unindentified errors in DB

[Nizou]

I got in Database a color bug from a vanilla file, but I couldn't find which mod causes that :

[794764.635] [ColorManager] ERROR: UNIQUE constraint failed: PlayerColors.Type
[794764.635] [ColorManager]: While executing - 'insert into PlayerColors('Type', 'Usage', 'PrimaryColor', 'SecondaryColor') values (?, ?, ?, ?);'
[794764.635] [ColorManager]: In XMLSerializer while inserting row into table insert into PlayerColors('Type', 'Usage', 'PrimaryColor', 'SecondaryColor') with values (CIVILIZATION_ANTIOCH, Minor, COLOR_PLAYER_CITY_STATE_PRIMARY, COLOR_PLAYER_CITY_STATE_TRADE_SECONDARY, ).
[794764.635] [ColorManager]: In XMLSerializer while updating table PlayerColors from file ../../../DLC/Expansion1/Data/Expansion1_PlayerColors.xml.

I use Prismatic.

******************************

EDIT : I have solved the issue when modified Expansion2_PlayerColors.xml who had doublet of Expansion1_PlayerColors.xml rows for Anticoh & Babylon

 

[Nizou]

I got also some mysterious errors :

[879770.550] [Configuration] ERROR: no such column: Image
[879770.550] [Configuration]: In Query - SELECT File, Image, StaticMap from Maps where Domain = ?

[879845.313] [Gameplay] ERROR: Invalid Reference on PolicyModifiers.PolicyType - "POLICY_SKYSCRAPERS" does not exist in Policies
[879845.313] [Gameplay] ERROR: Invalid Reference on PolicyModifiers.PolicyType - "POLICY_GOTHIC_ARCHITECTURE" does not exist in Policies
[879845.313] [Gameplay] ERROR: Invalid Reference on PolicyModifiers.PolicyType - "POLICY_CORVEE" does not exist in Policies

I use all RwF policy modules excepted Technical policies.

 

[Nizou]

Here is my Modding.lua content : https://pastebin.com/sjTPbQFp

 

[Laurana Kanan]

EDIT : I have solved the issue when modified Expansion2_PlayerColors.xml who had doublet of Expansion1_PlayerColors.xml rows for Anticoh & Babylon

Did you just add a LoadOrder to the Expansion2_PlayerColors.xml to ensure it loads after Expansion1_PlayerColors.xml? Since Expansion 2 uses a Replace statement, if it loads before Expansion 1 you'll get that error.

[879845.313] [Gameplay] ERROR: Invalid Reference on PolicyModifiers.PolicyType - "POLICY_SKYSCRAPERS" does not exist in Policies
[879845.313] [Gameplay] ERROR: Invalid Reference on PolicyModifiers.PolicyType - "POLICY_GOTHIC_ARCHITECTURE" does not exist in Policies
[879845.313] [Gameplay] ERROR: Invalid Reference on PolicyModifiers.PolicyType - "POLICY_CORVEE" does not exist in Policies

I use all RwF policy modules excepted Technical policies.

RwF removes those policies. You have Wonderous Wonders enabled, which attaches production discounts for National Wonders to those policies. Since they no longer exist you get that error.

 

[Nizou]

I didn't add a LoadOrder, but I have made the Exp2 colors disabled (so it means that I'd play with r&F colors for these 2 cities I guess).

Thanks for explaining the Wondrous Wonders bug.

So the last issue remaining is this one :

[879770.550] [Configuration] ERROR: no such column: Image
[879770.550] [Configuration]: In Query - SELECT File, Image, StaticMap from Maps where Domain = ?

 

[Laurana Kanan]

I have made the Exp2 colors disabled

I'm not sure I understand what you mean.

 

[Nizou]

In the screenshot below is what I have done

 

[Laurana Kanan]

Oh, you just commented the code for those two CSs out. I was confused when you said disabled.

 

[Nizou]

Sorry for not being really clear ̂ ̂