Bugs in the Code?

[luckybutjinxed]

Edit: Finally got Game Text working. Now I have this error.

[3733611.336] [Localization]: Validating Foreign Key Constraints...
[3733611.338] [Localization]: Passed Validation.
[3733611.357] [Configuration]: Validating Foreign Key Constraints...
[3733611.357] [Configuration]: Passed Validation.
[3733624.437] [FullTextSearch]: Initializing FullTextSearch
[3733627.185] [Gameplay]: Validating Foreign Key Constraints...
[3733627.204] [Gameplay]: Passed Validation.
[3733629.056] [Configuration]: Validating Foreign Key Constraints...
[3733629.056] [Configuration]: Passed Validation.
[3733672.317] [FullTextSearch]: FTS - Creating Context
[3733690.766] [Configuration]: Validating Foreign Key Constraints...
[3733690.767] [Configuration]: Passed Validation.
[3733725.322] [Gameplay] ERROR: CHECK constraint failed: Units
[3733725.323] [Gameplay] ERROR: CHECK constraint failed: Units
[3733725.820] [Gameplay]: Validating Foreign Key Constraints...
[3733725.843] [Gameplay]: Passed Validation.

Updated mod attached

 

[LeeS]

1. you attached a modbuddy project for a mod, not an executable mod
2. SQL has no such thing as 'false'. Use 0
3. ' denotes text in SQL, so '1' is actually telling SQL you want a text value that looks like numerical 1 but may not be implemented correctly as numerical 1. You are better off always specifying numerical values directly as numerical values without surrounding text denotations. This also applies for stating 0/1 for boolean columns in sql
   • 0 not '0'
   • 1 not '1'
   • 157 not '157'
   • -1 not '-1'

 

[Infixo]

...and there's a missing ' in line:
('LJX_INFLUENCE_GOLD', MODIFIER_ADJUST_OPEN_BORDERS_FROM_INFLUENCE', 'PLAYER_IS_MINOR');

 

[luckybutjinxed]

Thank you! We caught most things I think. I removed the unit because I think trying to replace the settler is causing its own host of problems. But I am still getting crashes. There's a ( syntax error I can't seem to find.

[3830572.947] [Localization]: Validating Foreign Key Constraints...
[3830572.949] [Localization]: Passed Validation.
[3830572.975] [Configuration]: Validating Foreign Key Constraints...
[3830572.976] [Configuration]: Passed Validation.
[3830585.180] [FullTextSearch]: Initializing FullTextSearch
[3830586.578] [Gameplay]: Validating Foreign Key Constraints...
[3830586.597] [Gameplay]: Passed Validation.
[3830587.898] [Configuration]: Validating Foreign Key Constraints...
[3830587.898] [Configuration]: Passed Validation.
[3830607.199] [FullTextSearch]: FTS - Creating Context
[3830632.518] [Gameplay] ERROR: near ")": syntax error
[3830632.582] [Gameplay]: Validating Foreign Key Constraints...
[3830632.601] [Gameplay]: Passed Validation.

 

[LeeS]

Most likely I would guess it is this:

'YieldType',  ‘YIELD_FOOD’)

The first is using ', the second is using "smart-quotes" versions of ', which is not the same thing.

But since you did not attach a zipped (or .rar'd) copy of the mod taken from the game's MODs menu I cannot run the mod on my end to verify if this is the issue.

 

[luckybutjinxed]

That was it! If you wouldn't mind looking though, I'm not sure why my Leader trait of +1 Gold per Spent Envoy isn't working. This should be the correct file now.

Edit: Disregard, fixed it myself.