SQL from one mod not transferring over into another

[maplemario]

So I've got two mods set up in ModBuddy. The first, MMDLL, is a mod containing two DLLs (game + expansion) and one SQL file which adds two custom fields to the Buildings table (TerrainRequiredWithinCityRadius1 and TerrainRequiredWithinCityRadius2). The second, Inuit, is a mod that adds a civilization. Inuit has a CIV5Buildings.xml file which initializes a building that uses these two properties.

Here's the thing. I used to have the SQL file, that is now in MMDLL, in Inuit--and it worked perfectly. However, now that I've moved it over to a different mod, despite the fact that it is the same file (with some comments removed), I am getting an error saying the two columns don't exist:

[12232.859] table Buildings has no column named TerrainRequiredWithinCityRadius1
[12232.859] In Query - insert into Buildings('Type', 'BuildingClass', 'Cost', 'GoldMaintenance', 'PrereqTech', 'Description', 'Civilopedia', 'Strategy', 'Help', 'ArtDefineTag', 'TerrainRequiredWithinCityRadius1', 'TerrainRequiredWithinCityRadius2', 'MinAreaSize', 'ConquestProb', 'HurryCostModifier', 'IconAtlas', 'PortraitIndex', 'Happiness') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
[12232.859] In XMLSerializer while updating table Buildings from file XML/Buildings/CIV5Buildings.xml.

Import into VFS is set to True on both DLLs, the SQL file in question is being loaded OnModActivated, and Inuit is set to be dependent on MMDLL (and it works, as Civ won't let me activate Inuit without first activating MMDLL). What could possibly be going wrong?

 

[keirathi]

First thing I would do is disable Inuit and only use MMDLL. After you load it up, check the database and make sure that the columns are being created.

If they are, it sounds like they're loading out of order, and I don't have any idea how to fix that

 

[maplemario]

Thanks for the response! How would I go about checking the database--is that something I can do through FireTuner?

 

[Pazyryk]

I use SQLite Manager. It's an addon for Firefox, so you have to have that installed even if you don't use it. There is a standalone SQLite DB viewer that whoward69 has mentioned in his posts, but I can't remember what that is called at the moment...

 

[keirathi]

I use SQLite Manager. It's an addon for Firefox, so you have to have that installed even if you don't use it. There is a standalone SQLite DB viewer that whoward69 has mentioned in his posts, but I can't remember what that is called at the moment...

It's called SQLite Spy.

Once you have one or the other of those programs, you browse to My Documents/My Games/Sid Meiers Civilizations 5/cache/ and use the program to open up Civ5DebugDatabase.db

 

[maplemario]

Thanks, SQLite Manager worked nicely. Some combination of rebuilding the solution, looking at the database, and copying over exactly the old SQL file without cutting out comments seems to have done it. I honestly have no idea why that worked, but thanks for the quick help!