Sorry to necro this thread, but after much frustration and googling I cannot believe I stumbled upon this thread. I'm having a very similar issue, except I cannot get any adjustment for the science per population to work whatsoever.
I have a fresh install, with a single mod, with 2 lines of...
Thank you for the comprehensive reply!
I have opened the Database.log file following your instructions exactly and I think I've found the problem:
[110162.786] [Gameplay] ERROR: near "DECLARE": syntax error
I also managed to open the DebugGameplay.sqlite file by converting it into an SQL file...
I'm trying to make it so that every Stock Exchange will give 2 gold per citizen in the city, up to 255 citizens. (In the future +1 when unpowered, another +1 when powered or something similar).
Here is what I have so far in an sql file:
DECLARE @cnt INT = 1;
WHILE @cnt < 256