DLL - Various Mod Components

[skodkim]

Will give that a try later but won't it mess (some of) the mod up?

\Skodkim

 

[whoward69]

Only if you're trying to use "Religion - Bonus Beliefs" (which won't work anyway if there is a conflict) - which is primarily an example for the "Adding new primary tables to the database" tutorial anyway.

Remember that nothing is "on" in the DLL unless activated by the corresponding (micro-)mod

 

[skodkim]

Don't use CivUP et al, but try deleting the file "DLL - Various Mod Components (v 35)\XML\CustomModDbUpdates.xml" - it may fix it.

Just tried and unfortunately I get exactly the same error

Just to be clear I haven't turned the "Religion - Bonus Beliefs" on in the options file and the mod isn't in the mods directory.

\Skodkim

 

[whoward69]

If you've deleted the file XML/CustomModDbUpdates.xml how can you be getting the same error message?

 

[skodkim]

If you've deleted the file XML/CustomModDbUpdates.xml how can you be getting the same error message?

I was surprised at that too so I double checked...

I don't get the error if I run either CEP our your dll alone.

\Skodkim

 

[skodkim]

Just triple checked and DLL - Various Mod Components (v 35)\XML\CustomModDbUpdates.xml was deleted during the last test.

Could it be because CEP creates a table called "plots" and your dll runs a Query on that (regardless that I didn't activate the new belief mod)?

\Skodkim

 

[whoward69]

Just tried and unfortunately I get exactly the same error

If you've deleted the correct file you can't possibly be getting the same error

no such column: Cost
table Plots already exists
In XMLSerializer while building table Plots from file [COLOR="Red"]XML/CustomModDbUpdates.xml[/COLOR].
no such column: Cost

 

[skodkim]

Sorry, sorry, sorry. Of course its not the same but the key part seems to be:

Spoiler :

[1159.602] columns StrategicViewType, TileType are not unique
[1159.602] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[1172.160] no such table: ContentPackage.LocalizedText
[1175.810] columns StrategicViewType, TileType are not unique
[1175.810] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[1182.191]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 6558992 71669968
PageCache: 7 13
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 6143424 59011680
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 6
------------------------------
[1182.674]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 6560168 71669968
PageCache: 7 13
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 6144600 59011680
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 6
------------------------------
[1202.096] no such column: Cost
[1204.078] no such column: Cost
[1206.698] no such table: Plot_Yields
[1206.698] In Query - select Yields.ID, Yield from Plot_Yields inner join Yields on YieldType = Yields.Type where PlotType = ?
[1206.698] no such table: Plot_Yields
[1206.698] In Query - select Yields.ID, Yield from Plot_Yields inner join Yields on YieldType = Yields.Type where PlotType = ?
[1206.698] no such table: Plot_Yields
[1206.698] In Query - select Yields.ID, Yield from Plot_Yields inner join Yields on YieldType = Yields.Type where PlotType = ?
[1206.698] no such table: Plot_Yields
[1206.698] In Query - select Yields.ID, Yield from Plot_Yields inner join Yields on YieldType = Yields.Type where PlotType = ?
[1206.901] no such table: Belief_PlotYieldChanges
[1206.901] In Query - select Plots.ID as PlotID, Yields.ID as YieldID, Yield from Belief_PlotYieldChanges inner join Plots on Plots.Type = PlotType inner join Yields on Yields.Type = YieldType where BeliefType = ?

\Skodkim

 

[whoward69]

Try just leaving the following in that xml file

<?xml version="1.0" encoding="utf-8"?>
<GameData>
	<Table name="Plot_Yields">
		<Column name="PlotType" type="text" reference="Plots(Type)"/>
		<Column name="YieldType" type="text" reference="Yields(Type)"/>
		<Column name="Yield" type="integer" default="0"/>
	</Table>

	<Table name="Belief_PlotYieldChanges">
		<Column name="BeliefType" type="text" reference="Beliefs(Type)"/>
		<Column name="PlotType" type="text" reference="Plots(Type)"/>
		<Column name="YieldType" type="integer" reference="Yields(Type)"/>
		<Column name="Yield" type="integer" default="0"/>
	</Table>
</GameData>

 

[skodkim]

Try just leaving the following in that xml file

<?xml version="1.0" encoding="utf-8"?>
<GameData>
	<Table name="Plot_Yields">
		<Column name="PlotType" type="text" reference="Plots(Type)"/>
		<Column name="YieldType" type="text" reference="Yields(Type)"/>
		<Column name="Yield" type="integer" default="0"/>
	</Table>

	<Table name="Belief_PlotYieldChanges">
		<Column name="BeliefType" type="text" reference="Beliefs(Type)"/>
		<Column name="PlotType" type="text" reference="Plots(Type)"/>
		<Column name="YieldType" type="integer" reference="Yields(Type)"/>
		<Column name="Yield" type="integer" default="0"/>
	</Table>
</GameData>

That seemed to do the trick for now. Database.log:

Spoiler :

[243.548] columns StrategicViewType, TileType are not unique
[243.548] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[257.230] no such table: ContentPackage.LocalizedText
[260.864] columns StrategicViewType, TileType are not unique
[260.864] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[267.416]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 6558992 71669968
PageCache: 7 13
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 6143424 59011680
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 6
------------------------------
[267.900]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 6560168 71669968
PageCache: 7 13
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 6144600 59011680
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 6
------------------------------
[289.522] no such column: Cost
[292.174] no such column: Cost
[295.075]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 7658072 71669968
PageCache: 8 17
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 7159488 59011680
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 12
------------------------------
[295.653]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 7658072 71669968
PageCache: 8 17
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 7159488 59011680
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 12
------------------------------

Would you consider looking into another solution for future releases? This is ok for me but there's a lot of people out there who knows very Little about modding.

\Skodkim

 

[whoward69]

Would you consider looking into another solution for future releases?

Will do. Now that I know what the interaction is - thanks for the help (again)

 

[skodkim]

And here's me thinking you're helping me...

\Skodkim

 

[Hyronymus]

whoward69, I think I know the answer but I want to be sure: can your DLL mods be used together with Civ IV Diplomacy Features Mod ?

 

[whoward69]

whoward69, I think I know the answer but I want to be sure: can your DLL mods be used together with Civ IV Diplomacy Features Mod ?

watch this space

 

[Hyronymus]

watch this space

Ooh, exciting .

 

[whoward69]

V36 with code support for Putmalk's Civ IV Diplomacy Features and Gazebo's City State Diplomacy mods

 

[Hyronymus]

This is amazing - I'm on it later this evening!

 

[rltmd317]

Which flavor of the City-State Diplomacy Mod (CSD) for Brave New World mod (DLL or no DLL). I assume since this post is on the DLL forum it the DLL but we all know what assume mean.....

 

[whoward69]

Which flavor of the City-State Diplomacy Mod (CSD) for Brave New World mod (DLL or no DLL).

Why would I add code support to my DLL for the non-DLL version of CSD?

 

[dilophosaur]

It's fantastic! Thanks.