Dummy Buildings creating a Syntax Error

[SpaceCommunist]

Howdy!

I've been working on an overhaul for government-related stuff, and I'm running into some trouble with my dummy buildings. Loading the mod does not crash the game, but the file itself becomes unused due to an apparent "syntax error". From the Database.log file:

[4238082.754] [Gameplay] ERROR: near ",": syntax error

Yeah, it's one of those syntax errors - the ones near one of the most commonly used text symbols in the file, so that the Database.log doesn't actually narrow down where the error is. My guess is that it would be due to my use of || attachments to reference Civics (which is a crucial part of the dummy buildings' functions); however, I've used the exact same pattern in other mod projects without getting a syntax error.

I'm stumped right now and would really appreciate some help. Any suggestions?

 

[Gedemon]

checking that timestamp ([4238082.754]) in the Modding.log should give you the sql file where the error is located (if you use multiple sql files), from there I use a SQLite tool to open the debug DB and copy/paste parts of the file in the query field then run them to check their syntax directly.

 

[LeeS]

You can also open the debug database and see what parts of your SQL file were actually enacted into the database, and this should narrow down where the syntax error is once you find what is missing from the debug database.

-------------------------------

I looked at your file but didn't "see" the error.

However, only 1 building with EnabledByReligion can be present in the same city at the same time. Using EnabledByReligion to lock out acquiring a dummy building also means no city with such a dummy present can build or purchase any "normal" religious building.

Buildings, however, can be their own Prerequisite in table BuildingPrereqs.

Just don't attempt to make a Tech or Civic its own prerequisite as this leads directly to the desktop.