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.