1. We have added a Gift Upgrades feature that allows you to gift an account upgrade to another member, just in time for the holiday season. You can see the gift option when going to the Account Upgrades screen, or on any user profile screen.
    Dismiss Notice

Error log spam that I can't account for

Discussion in 'Civ5 - Creation & Customization' started by Drawmeus, Feb 23, 2013.

  1. Drawmeus

    Drawmeus Emperor

    Joined:
    Jul 25, 2007
    Messages:
    1,213
    I'm having a lot of spam in database.log that I can't account for. Everything seems to be working (there are one or two small errors in here), but I get this error over and over:

    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed

    Full database.log:
    Spoiler :

    [321877.455] constraint failed
    [321877.455] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
    [321881.090] no such table: ContentPackage.LocalizedText
    [321884.678] Validating Foreign Key Constraints...
    [321884.678] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [321884.678] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [321884.678] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [321886.378] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_HITTITE_WARCHARIOT" does not exist in Units
    [321886.378] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_SUMERIAN_PHALANX" does not exist in Units
    [321886.378] Failed Validation.
    [321887.174]
    -- SQLite Memory Statistics --
    Memory Usage:
    [Cur] [Max]
    Malloc: 385936 33234880
    PageCache: 4380 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: 6640

    Prepared Statements:
    Current: 10
    ------------------------------
    [321931.307] no such table: ContentPackage.LocalizedText
    [321935.784] no such table: ContentPackage.LocalizedText
    [321939.700] Validating Foreign Key Constraints...
    [321939.700] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [321939.700] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [321939.700] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [321941.509] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_HITTITE_WARCHARIOT" does not exist in Units
    [321941.509] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_SUMERIAN_PHALANX" does not exist in Units
    [321941.509] Failed Validation.
    [321942.211]
    -- SQLite Memory Statistics --
    Memory Usage:
    [Cur] [Max]
    Malloc: 372104 33234880
    PageCache: 4396 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: 6640

    Prepared Statements:
    Current: 8
    ------------------------------
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321942.242] constraint failed
    [321942.242] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321958.841] no such table: ContentPackage.LocalizedText
    [321961.899] Validating Foreign Key Constraints...
    [321961.914] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [321961.914] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [321961.914] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [321963.661] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_HITTITE_WARCHARIOT" does not exist in Units
    [321963.661] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_SUMERIAN_PHALANX" does not exist in Units
    [321963.661] Failed Validation.
    [321964.426]
    -- SQLite Memory Statistics --
    Memory Usage:
    [Cur] [Max]
    Malloc: 371272 33234880
    PageCache: 4371 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: 6640

    Prepared Statements:
    Current: 8
    ------------------------------
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321964.441] constraint failed
    [321964.441] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [321985.096] no such table: ContentPackage.LocalizedText
    [321989.495] no such table: ContentPackage.LocalizedText
    [322007.123] no such table: ContentPackage.LocalizedText
    [322014.892] no such table: ContentPackage.LocalizedText
    [322019.089] no such table: ContentPackage.LocalizedText
    [322023.269] Validating Foreign Key Constraints...
    [322023.269] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [322023.269] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [322023.269] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [322023.269] Invalid Reference on AICityStrategies.TechPrereq - "TECH_THE_WHEEL" does not exist in Technologies
    [322023.285] Invalid Reference on Buildings.TrainedFreePromotion - "PROMOTION_DRILL_1" does not exist in UnitPromotions
    [322025.032] Invalid Reference on UnitPromotions.PromotionPrereqOr4 - "PROMOTION_HELI_MOBILITY_2" does not exist in UnitPromotions
    [322025.032] Invalid Reference on UnitPromotions.PromotionPrereqOr3 - "PROMOTION_HELI_AMBUSH_2" does not exist in UnitPromotions
    [322025.032] Invalid Reference on UnitPromotions.PromotionPrereqOr2 - "PROMOTION_HELI_MOBILITY_2" does not exist in UnitPromotions
    [322025.032] Invalid Reference on UnitPromotions.PromotionPrereqOr1 - "PROMOTION_HELI_AMBUSH_2" does not exist in UnitPromotions
    [322025.173] Failed Validation.
    [322026.031]
    -- SQLite Memory Statistics --
    Memory Usage:
    [Cur] [Max]
    Malloc: 372688 33234880
    PageCache: 4521 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: 6640

    Prepared Statements:
    Current: 8
    ------------------------------
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.077] constraint failed
    [322026.077] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322026.093] constraint failed
    [322026.093] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [322042.879] Validating Foreign Key Constraints...
    [322042.879] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [322042.879] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [322042.879] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [322042.894] Invalid Reference on AICityStrategies.TechPrereq - "TECH_THE_WHEEL" does not exist in Technologies
    [322042.894] Invalid Reference on Buildings.TrainedFreePromotion - "PROMOTION_DRILL_1" does not exist in UnitPromotions
    [322044.719] Invalid Reference on UnitPromotions.PromotionPrereqOr4 - "PROMOTION_HELI_MOBILITY_2" does not exist in UnitPromotions
    [322044.719] Invalid Reference on UnitPromotions.PromotionPrereqOr3 - "PROMOTION_HELI_AMBUSH_2" does not exist in UnitPromotions
    [322044.719] Invalid Reference on UnitPromotions.PromotionPrereqOr2 - "PROMOTION_HELI_MOBILITY_2" does not exist in UnitPromotions
    [322044.719] Invalid Reference on UnitPromotions.PromotionPrereqOr1 - "PROMOTION_HELI_AMBUSH_2" does not exist in UnitPromotions
    [322044.844] Failed Validation.
    [322045.718]
    -- SQLite Memory Statistics --
    Memory Usage:
    [Cur] [Max]
    Malloc: 513328 33234880
    PageCache: 4503 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: 6640

    Prepared Statements:
    Current: 25
    ------------------------------
    [322045.921] no such column: Type
    [322045.921] In Query - select * from Natural_Wonder_Placement where Type = ? LIMIT 1


    Set aside the invalid reference errors; I know what causes them and they're on my radar to fix.

    I don't see any errors related to my Defines table in the mod. I have two files that update the Defines table:
    Spoiler :
    Code:
    <GameData>
    	<Defines>
    		<Row Name="INVESTMENT_INFLUENCE_GAIN_PER_TURN_SMALL">
    			<Value>1</Value>
    		</Row>
    		<Row Name="INVESTMENT_INFLUENCE_GAIN_PER_TURN_MEDIUM">
    			<Value>2</Value>
    		</Row>
    		<Row Name="INVESTMENT_INFLUENCE_GAIN_PER_TURN_LARGE">
    			<Value>3</Value>
    		</Row>
    		<Row Name="INVESTMENT_MILITARY_COUNTER_PER_UNIT">
    			<Value>30</Value>
    		</Row>
    		<Row Name="INVESTMENT_MILITARY_COUNTER_SMALL_INCREMENT">
    			<Value>3</Value>
    		</Row>
    		<Row Name="INVESTMENT_MILITARY_COUNTER_MEDIUM_INCREMENT">
    			<Value>4</Value>
    		</Row>
    		<Row Name="INVESTMENT_MILITARY_COUNTER_LARGE_INCREMENT">
    			<Value>5</Value>
    		</Row>
    	</Defines>
    </GameData>
    


    Spoiler :
    Code:
    	<Defines>
    		<Update>
    			<Set Value="1.5"/>
    			<Where Name="CITY_GROWTH_EXPONENT"/>
    		</Update>
    		<Update>
    			<Set Value="9"/>
    			<Where Name="CITY_GROWTH_MULTIPLIER"/>
    		</Update>
    		<Update>
    			<Set Value="10"/>
    			<Where Name="BASE_CITY_GROWTH_THRESHOLD"/>
    		</Update>
    		<Update>
    			<Set Value="6"/>
    			<Where Name="RELIGION_ADJACENT_CITY_DISTANCE"/>
    		</Update>
    		<Update>
    			<Set Value="200"/>
    			<Where Name="RELIGION_FAITH_DELTA_NEXT_PROPHET"/>
    		</Update>
    		<Update>
    			<Set Value="10"/>
    			<Where Name="RELIGION_GAME_FAITH_DELTA_NEXT_PANTHEON"/>
    		</Update>
    		<Update>
    			<Set Value="25"/>
    			<Where Name="RELIGION_MIN_FAITH_FIRST_PANTHEON"/>
    		</Update>
    		<Update>
    			<Set Value="500"/>
    			<Where Name="RELIGION_MIN_FAITH_FIRST_PROPHET"/>
    		</Update>
    		<Update>
    			<Set Value="1"/>
    			<Where Name="UNIT_UPGRADE_COST_PER_PRODUCTION"/>
    		</Update>
    		<Update>
    			<Set Value="25"/>
    			<Where Name="GOLD_PURCHASE_GOLD_PER_PRODUCTION"/>
    		</Update>
    		<Update>
    			<Set Value="100"/>
    			<Where Name="ADVANCED_START_CITY_COST"/>
    		</Update>
    		<Update>
    			<Set Value="10"/>
    			<Where Name="CITY_HIT_POINTS_HEALED_PER_TURN"/>
    		</Update>
    		<Update>
    			<Set Value="450"/>
    			<Where Name="CITY_STRENGTH_DEFAULT"/>
    		</Update>
    		<Update>
    			<Set Value="35"/>
    			<Where Name="CITY_STRENGTH_POPULATION_CHANGE"/>
    		</Update>
    		<Update>
    			<Set Value="300"/>
    			<Where Name="CITY_STRENGTH_HILL_CHANGE"/>
    		</Update>
    		<Update>
    			<Set Value="2.1"/>
    			<Where Name="CITY_STRENGTH_TECH_EXPONENT"/>
    		</Update>
    		<Update>
    			<Set Value="60"/>
    			<Where Name="CITY_RANGED_ATTACK_STRENGTH_MULTIPLIER"/>
    		</Update>
    		<Update>
    			<Set Value="200"/>
    			<Where Name="CITY_STRENGTH_UNIT_DIVISOR"/>
    		</Update>
    		<Update>
    			<Set Value="20"/>
    			<Where Name="CITY_CAPTURE_DAMAGE_PERCENT"/>
    		</Update>
    		<Update>
    			<Set Value="-5"/>
    			<Where Name="VERY_UNHAPPY_THRESHOLD"/>
    		</Update>
    		<Update>
    			<Set Value="-10"/>
    			<Where Name="SUPER_UNHAPPY_THRESHOLD"/>
    		</Update>
    		<Update>
    			<Set Value="4"/>
    			<Where Name="UNHAPPINESS_PER_CITY"/>
    		</Update>
    		<Update>
    			<Set Value="300"/>
    			<Where Name="REVOLT_NUM_BASE"/>
    		</Update>
    		<Update>
    			<Set Value="2"/>
    			<Where Name="MIN_CITY_RANGE"/>
    		</Update>
    		<Update>
    			<Set Value="250"/>
    			<Where Name="WARMONGER_THREAT_MINOR_ATTACKED_WEIGHT"/>
    		</Update>
    		<Update>
    			<Set Value="500"/>
    			<Where Name="WARMONGER_THREAT_MINOR_CONQUERED_WEIGHT"/>
    		</Update>
    		<Update>
    			<Set Value="500"/>
    			<Where Name="WARMONGER_THREAT_MAJOR_CONQUERED_WEIGHT"/>
    		</Update>
    		<Update>
    			<Set Value="250"/>
    			<Where Name="WARMONGER_THREAT_MAJOR_ATTACKED_WEIGHT"/>
    		</Update>
    		<Update>
    			<Set Value="-20"/>
    			<Where Name="WARMONGER_THREAT_PER_TURN_DECAY"/>
    		</Update>
    		<Update>
    			<Set Value="5"/>
    			<Where Name="MILITARY_THREAT_PER_MINOR_ATTACKED"/>
    		</Update>
    		<Update>
    			<Set Value="2"/>
    			<Where Name="MILITARY_THREAT_PER_MINOR_CONQUERED"/>
    		</Update>
    		<Update>
    			<Set Value="10"/>
    			<Where Name="MILITARY_THREAT_PER_MAJOR_ATTACKED"/>
    		</Update>
    		<Update>
    			<Set Value="5"/>
    			<Where Name="MILITARY_THREAT_PER_MAJOR_CONQUERED"/>
    		</Update>
    
    		<Update>
    			<Set Value="20"/>
    			<Where Name="BARBARIAN_CAMP_ODDS_OF_NEW_CAMP_SPAWNING"/>
    		</Update>
    		<Update>
    			<Set Value="100"/>
    			<Where Name="GOLD_FROM_BARBARIAN_CONVERSION"/>
    		</Update>
    		<Update>
    			<Set Value="3"/>
    			<Where Name="MAX_BARBARIANS_FROM_CAMP_NEARBY"/>
    		</Update>
    		<Update>
    			<Set Value="25"/>
    			<Where Name="EXPERIENCE_PER_LEVEL"/>
    		</Update>
    	</Defines>
    
     
  2. ww2commander

    ww2commander Emperor

    Joined:
    Aug 23, 2003
    Messages:
    1,243
    Location:
    Australia
    I don't use XML much myself but should the set syntax be something like:

    Personally, SQL is faster and easier to write without all those brackets and forward slashes.
    Instead of an XML files, create a SQL file on ModBuddy and use the following statement to do the exact same thing as the above XML:

     
  3. whoward69

    whoward69 DLL Minion

    Joined:
    May 30, 2011
    Messages:
    8,468
    Location:
    Near Portsmouth, UK
    You get those errors messages even if you start a modded game with zero mods enabled (see post #2 of http://forums.civfanatics.com/showthread.php?t=487482) so it's something the game core is doing wrong and not your mod.

    There just happens to be one line for each PostDefine entry in the standard xml files. Also one of my mods adds another PostDefine and, if that's enabled, I then get anonther entry, so it seems to be something in that processing. Also if you look in stopwatch.log, the time codes for those lines are always after the game core has loaded your xml/sql changes, so it's unlikely to be something you have any direct control over,
     
  4. Drawmeus

    Drawmeus Emperor

    Joined:
    Jul 25, 2007
    Messages:
    1,213
    Good news that it's not my fault and not a problem for me, bad news that there's yet another /facepalm in this code from Firaxis :/
     
  5. Putmalk

    Putmalk Deity

    Joined:
    Sep 26, 2010
    Messages:
    2,623
    Location:
    New York
    I wanted to bump this just in case anybody got any similar errors with inserting into values.

    This time, however, my database.log looked like:

    Spoiler :

    [245943.142] constraint failed
    [245943.142] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
    [245948.149] no such table: ContentPackage.LocalizedText
    [245951.659] Validating Foreign Key Constraints...
    [245951.659] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [245951.659] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [245951.659] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [245953.453] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_HITTITE_WARCHARIOT" does not exist in Units
    [245953.453] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_SUMERIAN_PHALANX" does not exist in Units
    [245953.453] Failed Validation.
    [245954.202]
    -- SQLite Memory Statistics --
    Memory Usage:
    [Cur] [Max]
    Malloc: 385952 33234888
    PageCache: 4380 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: 6640

    Prepared Statements:
    Current: 10
    ------------------------------
    [246380.132] no such table: ContentPackage.LocalizedText
    [246385.046] no such table: ContentPackage.LocalizedText
    [246388.275] table GameSpeeds already exists
    [246388.275] In XMLSerializer while building table GameSpeeds from file XML/Gameplay/CIV5GameSpeeds.xml.
    [246388.291] table Defines has no column named Text
    [246388.291] In Query - insert into Defines('Name', 'Text') values (?, ?);
    [246388.291] In XMLSerializer while updating table Defines from file XML/Gameplay/GlobalDefines.xml.
    [246389.445] Validating Foreign Key Constraints...
    [246389.445] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [246389.445] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [246389.445] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [246391.301] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_HITTITE_WARCHARIOT" does not exist in Units
    [246391.301] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_SUMERIAN_PHALANX" does not exist in Units
    [246391.301] Failed Validation.
    [246392.050]
    -- SQLite Memory Statistics --
    Memory Usage:
    [Cur] [Max]
    Malloc: 371328 33234888
    PageCache: 4396 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: 6640

    Prepared Statements:
    Current: 8
    ------------------------------
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246392.097] constraint failed
    [246392.097] While executing - 'INSERT INTO Defines(Name, Value) VALUES(?, ?)'
    [246404.000] Validating Foreign Key Constraints...
    [246404.000] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [246404.000] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [246404.000] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [246405.763] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_HITTITE_WARCHARIOT" does not exist in Units
    [246405.763] Invalid Reference on UnitGameplay2DScripts.UnitType - "UNIT_SUMERIAN_PHALANX" does not exist in Units
    [246405.763] Failed Validation.
    [246406.480]
    -- SQLite Memory Statistics --
    Memory Usage:
    [Cur] [Max]
    Malloc: 539496 33234888
    PageCache: 4392 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: 6640

    Prepared Statements:
    Current: 28
    ------------------------------
    [246407.058] no such column: Type
    [246407.058] In Query - select * from Natural_Wonder_Placement where Type = ? LIMIT 1



    The specific part of my error was
    Spoiler :

    Code:
    [246388.275] table GameSpeeds already exists
    [246388.275] In XMLSerializer while building table GameSpeeds from file XML/Gameplay/CIV5GameSpeeds.xml.
    [246388.291] table Defines has no column named Text
    [246388.291] In Query - insert into Defines('Name', 'Text') values (?, ?);
    [246388.291] In XMLSerializer while updating table Defines from file XML/Gameplay/GlobalDefines.xml.
    


    and it happened because I accidentally placed the GameSpeeds table in my .xml file (i had converted it from being VFS=true to VFS=false and forgot to remove it). Also I had accidentally added in a new defines with <Text> instead of <Value>.

    Posting just to log this in case somebody has a similar issue in the future.
     

Share This Page