[GEM 1.13/CivUp 2.4] Database.log errors

[skodkim]

Using GEM 1.13/CivUp 2.4 I get the following errors ins Database.log.

Apart from these I only use City State Diplomacy mod v 35 and have enabled this in the options (sql) file in GEM and CivUP.

Spoiler :

[3164.605] constraint failed
[3164.605] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[3169.690] no such table: ContentPackage.LocalizedText
[3171.250] Validating Foreign Key Constraints...
[3171.250] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[3171.250] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[3171.250] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[3172.171] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_HITTITE_WARCHARIOT" does not exist in Units
[3172.171] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_SUMERIAN_PHALANX" does not exist in Units
[3172.171] Failed Validation.
[3172.529]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 386904 33235848
PageCache: 4388 4982
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 0 29686720
Scratch: 0 0

Largest Allocations:
Malloc: 131072
PageCache: 1160
Scratch: 6664

Prepared Statements:
Current: 10
------------------------------
[3191.874] no such table: ContentPackage.LocalizedText
[3193.855] no such table: ContentPackage.LocalizedText
[3196.351] constraint failed
[3196.351] While executing - 'insert into BuildingClasses('Type', 'DefaultBuilding', 'Description', 'MaxPlayerInstances') values (?, ?, ?, ?);'
[3196.351] In XMLSerializer while inserting row into table insert into BuildingClasses('Type', 'DefaultBuilding', 'Description', 'MaxPlayerInstances') with values (BUILDINGCLASS_SUMMER_PALACE, BUILDING_SUMMER_PALACE, TXT_KEY_BUILDING_PALACE, 3, ).
[3196.351] In XMLSerializer while updating table BuildingClasses from file GEM\Cities\GEC__New.xml.
[3196.351] column Type is not unique
[3207.754] Validating Foreign Key Constraints...
[3207.770] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[3207.770] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[3207.770] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[3207.770] Invalid Reference on Buildings.FreeBuildingThisCity - "BUILDINGCLASS_CITY_HALL" does not exist in BuildingClasses
[3207.957] Invalid Reference on Building_DomainProductionModifiers.BuildingType - "BUILDING_WAREHOUSE" does not exist in Buildings
[3207.957] Invalid Reference on Building_Flavors.BuildingType - "BUILDING_CITY_HALL" does not exist in Buildings
[3207.957] Invalid Reference on Building_Flavors.BuildingType - "BUILDING_CITY_HALL" does not exist in Buildings
[3207.957] Invalid Reference on Building_Flavors.BuildingType - "BUILDING_CITY_HALL" does not exist in Buildings
[3207.957] Invalid Reference on Building_Flavors.BuildingType - "BUILDING_MENTORS_HALL" does not exist in Buildings
[3207.957] Invalid Reference on Building_Flavors.BuildingType - "BUILDING_MENTORS_HALL" does not exist in Buildings
[3207.957] Invalid Reference on Building_Flavors.BuildingType - "BUILDING_MENTORS_HALL" does not exist in Buildings
[3207.957] Invalid Reference on Building_Flavors.BuildingType - "BUILDING_WAREHOUSE" does not exist in Buildings
[3207.957] Invalid Reference on Building_Flavors.BuildingType - "BUILDING_WAREHOUSE" does not exist in Buildings
[3207.957] Invalid Reference on Building_Flavors.BuildingType - "BUILDING_WAREHOUSE" does not exist in Buildings
[3207.957] Invalid Reference on Building_Flavors.BuildingType - "BUILDING_WAREHOUSE" does not exist in Buildings
[3207.957] Invalid Reference on Building_Flavors.BuildingType - "BUILDING_WAREHOUSE" does not exist in Buildings
[3207.957] Invalid Reference on Building_YieldChanges.BuildingType - "BUILDING_CITY_HALL" does not exist in Buildings
[3207.957] Invalid Reference on Building_YieldChanges.BuildingType - "BUILDING_CITY_HALL" does not exist in Buildings
[3207.957] Invalid Reference on Building_YieldChanges.BuildingType - "BUILDING_CITY_HALL" does not exist in Buildings
[3207.957] Invalid Reference on Building_YieldChanges.BuildingType - "BUILDING_WAREHOUSE" does not exist in Buildings
[3208.222] Invalid Reference on Policy_BuildingClassYieldModifiers.BuildingClassType - "BUILDINGCLASS_MENTORS_HALL" does not exist in BuildingClasses
[3208.222] Invalid Reference on Policy_BuildingClassYieldChanges.BuildingClassType - "BUILDINGCLASS_WAREHOUSE" does not exist in BuildingClasses
[3208.768] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_HITTITE_WARCHARIOT" does not exist in Units
[3208.768] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_SUMERIAN_PHALANX" does not exist in Units
[3208.800] Failed Validation.
[3209.268]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 2047144 33235848
PageCache: 4351 4982
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 1485960 29686720
Scratch: 0 0

Largest Allocations:
Malloc: 131072
PageCache: 1160
Scratch: 6664

Prepared Statements:
Current: 19
------------------------------

\Skodkim

 

[skodkim]

When I removed CSD and used only CivUP+GEM it worked again.

Also the bug from here went away so they were related.

I'm wondering if this could be a result of some of the settings from the settings file CSD includes or is it possible that it hasn't been noticed by others before?

\Skodkim

 

[Torvald]

I also had problems using CSD yesterday.

Not sure if it was a true CSD problem, or was related to the notepad vs wordpad method of editing the options.sql file to accommodate CSD.

At any rate, after deleting CSD and reverting back to unedited CivUP/GEM files, the game worked again.

 

[skodkim]

Fortunately this is an easy fix. The bug was introduced by GEM adding the building/buildingclass BUILDING_SUMMER_PALACE and BUILDINGCLASS_SUMMER_PALACE which CSD also uses.

Find the files City-State Diplomacy Mod (CSD) (v 35)\Buildings\BuildingText.xml and City-State Diplomacy Mod (CSD) (v 35)\Buildings\CSDBuildings.xml and rename all instances of _SUMMER_PALACE to CSD_SUMMER_PALACE.

This will remove the errors and shouldn't effect gameplay at all.

\Skodkim

 

[Thalassicus]

Thank you, I fixed this problem by calling the building GEM_Summer_Palace in Gem 1.13.2.