Mods contuinuisly crahes,i do not understand why

By "crashing" do you mean getting sent back to the main menu after the pop-warning related to bad Mods ?

It's because you have an invalid reference.
Code:
[1198817.287] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PIT_PLOT_HAS_PLANTATION" does not exist in RequirementSets
[1198817.287] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PIT_PLOT_HAS_PLANTATION" does not exist in RequirementSets
Which is actually caused by this error
Code:
[1198817.075] [Gameplay] ERROR: UNIQUE constraint failed: StartBiasResources.CivilizationType, StartBiasResources.ResourceType
[1198817.075] [Gameplay] ERROR: UNIQUE constraint failed: StartBiasResources.CivilizationType, StartBiasResources.ResourceType
Which means you are attempting to repeat a combination of settings the game already has for "CivilizationType" and "ResourceType" in table "StartBiasResources"

Firaxis did not forget these
Code:
--and two extra planation resources that firaxis apparently just...forgot?--
INSERT INTO StartBiasResources(Tier,ResourceType,CivilizationType)
VALUES ('1','RESOURCE_BANANAS','CIVILIZATION_MAYA'),
('1','RESOURCE_OLIVES','CIVILIZATION_MAYA');
They are adding them in the Expansion1 and Expansion2 folders so that players who only have Vanilla can still have the Maya-Colombia DLC.

You need to make those into UPDATE commands. Since you actually want to update multiple rows in the table with the exact same change, you can simplify your code to
Code:
UPDATE StartBiasResources SET Tier='1' WHERE CivilizationType='CIVILIZATION_MAYA';

Finally, no single file that is loaded via an UpdateDatabase type of action can be loaded in both the FrontEndActions and the InGameActions. Get rid of the following in the FrontEndActions:
Code:
    <UpdateDatabase id="Data1PIT">
      <Properties>
        <LoadOrder>501</LoadOrder>
      </Properties>
      <File>Maya_Changes.sql</File>
    </UpdateDatabase>
The FrontEnd and InGame Databases have independent and different implementations. What is valid in one is not valid in the other, and vice versa. Adding the same file to UpdateDatabase actions in both "ends" of the game's systems merely results in spurious and confusing error-messages in Database.log.

You may see some people advocating to add the file in the FrontEnd as well as the InGame as some sort of "safety measure" -- this is advice given by people who do not understand how databases work nor how the game is structured. There is no benefit whatever.
 
You also seem to have forgotten to define "PIT_PLANTATION_FAITH_MAYAB" but the game does not care about that in this particular instance since table "ImprovementModifiers" does not actually check whether the argument given for a "ModifierId" has ever been defined anywhere.
 
It's because you have an invalid reference.
Code:
[1198817.287] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PIT_PLOT_HAS_PLANTATION" does not exist in RequirementSets
[1198817.287] [Gameplay] ERROR: Invalid Reference on Modifiers.SubjectRequirementSetId - "PIT_PLOT_HAS_PLANTATION" does not exist in RequirementSets
Which is actually caused by this error
Code:
[1198817.075] [Gameplay] ERROR: UNIQUE constraint failed: StartBiasResources.CivilizationType, StartBiasResources.ResourceType
[1198817.075] [Gameplay] ERROR: UNIQUE constraint failed: StartBiasResources.CivilizationType, StartBiasResources.ResourceType
Which means you are attempting to repeat a combination of settings the game already has for "CivilizationType" and "ResourceType" in table "StartBiasResources"

Firaxis did not forget these
Code:
--and two extra planation resources that firaxis apparently just...forgot?--
INSERT INTO StartBiasResources(Tier,ResourceType,CivilizationType)
VALUES ('1','RESOURCE_BANANAS','CIVILIZATION_MAYA'),
('1','RESOURCE_OLIVES','CIVILIZATION_MAYA');
They are adding them in the Expansion1 and Expansion2 folders so that players who only have Vanilla can still have the Maya-Colombia DLC.


Finally, no single file that is loaded via an UpdateDatabase type of action can be loaded in both the FrontEndActions and the InGameActions. Get rid of the following in the FrontEndActions:
Code:
    <UpdateDatabase id="Data1PIT">
      <Properties>
        <LoadOrder>501</LoadOrder>
      </Properties>
      <File>Maya_Changes.sql</File>
    </UpdateDatabase>
The FrontEnd and InGame Databases have independent and different implementations. What is valid in one is not valid in the other, and vice versa. Adding the same file to UpdateDatabase actions in both "ends" of the game's systems merely results in spurious and confusing error-messages in Database.log.

You may see some people advocating to add the file in the FrontEnd as well as the InGame as some sort of "safety measure" -- this is advice given by people who do not understand how databases work nor how the game is structured. There is no benefit whatever.

I have genuinely no idea how you worked this out,but that seems to have been the issue.Thank you very much for your help in both threads! :D
 
One last question if you do not mind:The plantation bonus works as intended,but in the builder tooltip and in the research tree the Plantation benefits are marked as simply +2 Gold.How do I change this?
 
You need to edit the relevant text entry for that. Probably found in Improvements_Text.xml
 
Back
Top Bottom