Update 107 invalidated a portion of a mod I'm currently playing around with. My mod added some entries to Building_PrereqBuildingClasses. It was working with 106 but the prereqs no longer had function and were not showing on the updated Civilopedia screen from UP&VE.
This gave me a reason to work with SQL first time but using that to make entries failed to fix the problem. Searching through 107's files I found VEC - General.sql with an entry of DELETE FROM Building_PrereqBuildingClasses; and removed it. Reloading I found the error was fixed. I then looked at 106's version of the file and it had the same statement but didn't break my mod.
I can see VEC - General.sql was updated with 107 to modify the specialists. I cannot confirm the exact reason additions to Building_PrereqBuildingClasses don't go through using sql or xml with 107. Looking at the .db file I can confirm with the line deleted from VEC - General.sql that Building_PrereqBuildingClasses is in the db. When reinserting the line back in the table is empty in the db.
Further testing while I write this shows that 107 invalidates (xml or sql) additions to prereqs table and 106 invalidates prereqs only when using sql to add to the table. Looking at the db the table is empty with 107 but includes my entries with 106 if xml is used.
For my purposes deleting the offending line from your file works but I'm sure you were attempting to move towards your new table for percentages. My deleting might cause additional errors at this time that I'm not aware of yet.
Probably my best bet would be to find a more compatible way to insert into the table, create a new table for my use (would require much more work to ensure what I'm trying to prevent from being built until the right conditions are met and to ensure that the information is shown somewhat usefully in the Civilopedia entries) or rethink what I'm trying to do.
This gave me a reason to work with SQL first time but using that to make entries failed to fix the problem. Searching through 107's files I found VEC - General.sql with an entry of DELETE FROM Building_PrereqBuildingClasses; and removed it. Reloading I found the error was fixed. I then looked at 106's version of the file and it had the same statement but didn't break my mod.
I can see VEC - General.sql was updated with 107 to modify the specialists. I cannot confirm the exact reason additions to Building_PrereqBuildingClasses don't go through using sql or xml with 107. Looking at the .db file I can confirm with the line deleted from VEC - General.sql that Building_PrereqBuildingClasses is in the db. When reinserting the line back in the table is empty in the db.
Further testing while I write this shows that 107 invalidates (xml or sql) additions to prereqs table and 106 invalidates prereqs only when using sql to add to the table. Looking at the db the table is empty with 107 but includes my entries with 106 if xml is used.
For my purposes deleting the offending line from your file works but I'm sure you were attempting to move towards your new table for percentages. My deleting might cause additional errors at this time that I'm not aware of yet.
Probably my best bet would be to find a more compatible way to insert into the table, create a new table for my use (would require much more work to ensure what I'm trying to prevent from being built until the right conditions are met and to ensure that the information is shown somewhat usefully in the Civilopedia entries) or rethink what I'm trying to do.
