Techs doing something wierd, need help!

[Voltron81]

1) Gods and kings not used.
2)this mod adds two full eras.

If you start the game normal it seeems fine. I have not played it all the way to the genetic but it might very well do the same thing as when you start at genetic or diamond. The first column of techs are doubled and all the rest are red and locked. The preqs are correct. i really need help.

 

[Voltron81]

Spoiler :

[289062.531] constraint failed
[289062.531] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[289081.421] Validating Foreign Key Constraints...
[289082.265] Passed Validation.
[289082.640]

------------------------------
[289129.063] no such table: Language_zh_CN
[289129.063] In Query - insert into Language_zh_CN('Tag', 'Text') values (?, ?);
[289129.063] In XMLSerializer while updating table Language_zh_CN from file Localization/ZH_CN.xml.
[289129.219] Database::XMLSerializer (LUA/InGame.xml): 'Row' or 'Delete' expected, got 'LuaContext'.
[289131.469] Database::XMLSerializer (XML/Defines/FM_artdefines_unitmembers.xml): 'Row' or 'Delete' expected, got 'Type'.
[289131.469] Database::XMLSerializer (XML/Defines/FM_artdefines_units.xml): 'Row' or 'Delete' expected, got 'Type'.
[289131.469] constraint failed
[289131.469] While executing - 'insert into BuildingClasses('Type', 'DefaultBuilding', 'Description') values (?, ?, ?);'
[289131.469] In XMLSerializer while inserting row into table insert into BuildingClasses('Type', 'DefaultBuilding', 'Description') with values (BUILDINGCLASS_INCUBATORS, BUILDING_INCUBATORS, TXT_KEY_BUILDING_INCUBATORS_DESC, ).
[289131.469] In XMLSerializer while updating table BuildingClasses from file XML/Buildings/CIV5BuildingClasses.xml.
[289131.469] column Type is not unique
[289131.500] constraint failed
[289131.500] While executing - 'insert into Buildings('Type', 'BuildingClass', 'Cost', 'GoldMaintenance', 'PrereqTech', 'Help', 'Description', 'Civilopedia', 'Strategy', 'ArtDefineTag', 'NukeImmune', 'NukeModifier', 'MinAreaSize', 'HurryCostModifier', 'IconAtlas', 'NeverCapture', 'PortraitIndex') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);'
[289131.500] In XMLSerializer while inserting row into table insert into Buildings('Type', 'BuildingClass', 'Cost', 'GoldMaintenance', 'PrereqTech', 'Help', 'Description', 'Civilopedia', 'Strategy', 'ArtDefineTag', 'NukeImmune', 'NukeModifier', 'MinAreaSize', 'HurryCostModifier', 'IconAtlas', 'NeverCapture', 'PortraitIndex') with values (BUILDING_BUNKER, BUILDINGCLASS_BUNKER, 450, 2, TECH_ELECTRONICS, TXT_KEY_BUILDING_BUNKER_HELP, TXT_KEY_BUILDING_BUNKER_DESC, TXT_KEY_BUILDING_BUNKER_PEDIA, TXT_KEY_BUILDING_BUNKER_STRATEGY, ART_DEF_BUILDING_BARRACKS, 1, -25, -1, 25, BW_ATLAS_1, 1, 6, ).
[289131.500] In XMLSerializer while updating table Buildings from file XML/Buildings/CIV5Buildings.xml.
[289131.500] column Type is not unique
[289131.531] constraint failed
[289131.531] While executing - 'insert into Colors('Type', 'Red', 'Green', 'Blue', 'Alpha') values (?, ?, ?, ?, ?);'
[289131.531] In XMLSerializer while inserting row into table insert into Colors('Type', 'Red', 'Green', 'Blue', 'Alpha') with values (COLOR_PLAYER_HEBREW_BACKGROUND, 0, 0.220, 0.722, 1, ).
[289131.531] In XMLSerializer while updating table Colors from file XML/Civs/HEB/hebrew.xml.
[289131.531] column Type is not unique
[289131.563] constraint failed
[289131.563]
[289131.563] In XMLSerializer while inserting row into table insert into Eras('ID', 'Type', 'Description', 'ArtPrefix', 'Strategy', 'NoGoodies', 'NoBarbUnits', 'NoBarbCities', 'ResearchAgreementCost', 'StartingUnitMultiplier', 'StartingDefenseUnits', 'StartingWorkerUnits', 'StartingExploreUnits', 'StartingGold', 'StartingCulture', 'StartPercent', 'BuildingMaintenancePercent', 'GrowthPercent', 'TrainPercent', 'ConstructPercent', 'CreatePercent', 'ResearchPercent', 'BuildPercent', 'ImprovementPercent', 'GreatPeoplePercent', 'CulturePercent', 'EventChancePerTurn', 'SoundtrackSpace', 'CityBombardEffectTag', 'AudioUnitVictoryScript', 'AudioUnitDefeatScript') with values (7, ERA_DIAMOND_ERA, TXT_KEY_ERA_7, FUTURE, 0, 1, 1, 1, 80000, 5, 5, 5, 4, 500000, 10000, 90, 1400, 60, 165, 195, 18, 50, 50, 50, 75, 50, 10, 40, CITY_BOMBARD_LATE, AS2D_VICTORY_LATE, AS2D_LOSS_LATE, ).
[289131.563] In XMLSerializer while updating table Eras from file XML/GameImfo/eras.xml.
[289131.563] PRIMARY KEY must be unique
[289131.594] constraint failed
[289131.594] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289131.594] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_PROJECT_MARS_MISSION, Mars Mission, ).
[289131.594] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_BUILDINGS.xml.
[289131.594] columns Language, Tag are not unique
[289131.594] constraint failed
[289131.594] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289131.594] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_TECH_INCUBATION_PODS_TITLE, Incubation Pods, ).
[289131.594] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_TECH.xml.
[289131.594] columns Language, Tag are not unique
[289131.625] constraint failed
[289131.625] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289131.625] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_PROMOTION_ADAMANTIUM, Adamantium Armor, ).
[289131.625] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_PROMOTIONS.xml.
[289131.625] columns Language, Tag are not unique
[289131.625] constraint failed
[289131.625] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289131.625] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_ERA_DIAMOND_ERA_QUOTE1, [NEWLINE] "The diamond age is the pinacle of humanity."[NEWLINE] - Yin Lang 2230[NEWLINE] , ).
[289131.625] In XMLSerializer while updating table Language_en_US from file XML/NewText/erasTEXT.xml.
[289131.625] columns Language, Tag are not unique
[289131.750] constraint failed
[289131.750] While executing - 'insert into UnitPromotions('Type', 'Description', 'Help', 'PortraitIndex', 'IconAtlas', 'OrderPriority', 'DefenseMod', 'Sound', 'CannotBeChosen', 'PediaType', 'PediaEntry') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);'
[289131.750] In XMLSerializer while inserting row into table insert into UnitPromotions('Type', 'Description', 'Help', 'PortraitIndex', 'IconAtlas', 'OrderPriority', 'DefenseMod', 'Sound', 'CannotBeChosen', 'PediaType', 'PediaEntry') with values (PROMOTION_ADAMANTIUM, TXT_KEY_PROMOTION_ADAMANTIUM_DESC, TXT_KEY_PROMOTION_ADAMANTIUM_HELP, 59, ABILITY_ATLAS, 0, 200, AS2D_IF_LEVELUP, 1, PEDIA_SHARED, TXT_KEY_PROMOTION_ADAMANTIUM, ).
[289131.750] In XMLSerializer while updating table UnitPromotions from file XML/Units/FM_Promotions.xml.
[289131.750] column Type is not unique
[289131.781] constraint failed
[289131.781] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289131.781] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_UNIT_RAILGUN_DESTROYER_DESC, Railgun Destroyer, ).
[289131.781] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_UNITS.xml.
[289131.781] columns Language, Tag are not unique
[289154.063] Validating Foreign Key Constraints...
[289154.813] Invalid Reference on Units.Civilopedia - "TXT_KEY_RAILGUN_DESTROYER_PEDIA" does not exist in Language_en_US
[289154.969] Failed Validation.
[289155.500]

------------------------------
[289275.125] no such table: Language_zh_CN
[289275.125] In Query - insert into Language_zh_CN('Tag', 'Text') values (?, ?);
[289275.125] In XMLSerializer while updating table Language_zh_CN from file Localization/ZH_CN.xml.
[289275.250] Database::XMLSerializer (LUA/InGame.xml): 'Row' or 'Delete' expected, got 'LuaContext'.
[289277.188] Database::XMLSerializer (XML/Defines/FM_artdefines_unitmembers.xml): 'Row' or 'Delete' expected, got 'Type'.
[289277.188] Database::XMLSerializer (XML/Defines/FM_artdefines_units.xml): 'Row' or 'Delete' expected, got 'Type'.
[289277.188] constraint failed
[289277.188] While executing - 'insert into BuildingClasses('Type', 'DefaultBuilding', 'Description') values (?, ?, ?);'
[289277.188] In XMLSerializer while inserting row into table insert into BuildingClasses('Type', 'DefaultBuilding', 'Description') with values (BUILDINGCLASS_INCUBATORS, BUILDING_INCUBATORS, TXT_KEY_BUILDING_INCUBATORS_DESC, ).
[289277.188] In XMLSerializer while updating table BuildingClasses from file XML/Buildings/CIV5BuildingClasses.xml.
[289277.188] column Type is not unique
[289277.188] constraint failed
[289277.188] While executing - 'insert into Buildings('Type', 'BuildingClass', 'Cost', 'GoldMaintenance', 'PrereqTech', 'Help', 'Description', 'Civilopedia', 'Strategy', 'ArtDefineTag', 'NukeImmune', 'NukeModifier', 'MinAreaSize', 'HurryCostModifier', 'IconAtlas', 'NeverCapture', 'PortraitIndex') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);'
[289277.188] In XMLSerializer while inserting row into table insert into Buildings('Type', 'BuildingClass', 'Cost', 'GoldMaintenance', 'PrereqTech', 'Help', 'Description', 'Civilopedia', 'Strategy', 'ArtDefineTag', 'NukeImmune', 'NukeModifier', 'MinAreaSize', 'HurryCostModifier', 'IconAtlas', 'NeverCapture', 'PortraitIndex') with values (BUILDING_BUNKER, BUILDINGCLASS_BUNKER, 450, 2, TECH_ELECTRONICS, TXT_KEY_BUILDING_BUNKER_HELP, TXT_KEY_BUILDING_BUNKER_DESC, TXT_KEY_BUILDING_BUNKER_PEDIA, TXT_KEY_BUILDING_BUNKER_STRATEGY, ART_DEF_BUILDING_BARRACKS, 1, -25, -1, 25, BW_ATLAS_1, 1, 6, ).
[289277.188] In XMLSerializer while updating table Buildings from file XML/Buildings/CIV5Buildings.xml.
[289277.188] column Type is not unique
[289277.188] constraint failed
[289277.188] While executing - 'insert into Colors('Type', 'Red', 'Green', 'Blue', 'Alpha') values (?, ?, ?, ?, ?);'
[289277.188] In XMLSerializer while inserting row into table insert into Colors('Type', 'Red', 'Green', 'Blue', 'Alpha') with values (COLOR_PLAYER_HEBREW_BACKGROUND, 0, 0.220, 0.722, 1, ).
[289277.188] In XMLSerializer while updating table Colors from file XML/Civs/HEB/hebrew.xml.
[289277.188] column Type is not unique
[289277.188] constraint failed
[289277.188]
[289277.188] In XMLSerializer while inserting row into table insert into Eras('ID', 'Type', 'Description', 'ArtPrefix', 'Strategy', 'NoGoodies', 'NoBarbUnits', 'NoBarbCities', 'ResearchAgreementCost', 'StartingUnitMultiplier', 'StartingDefenseUnits', 'StartingWorkerUnits', 'StartingExploreUnits', 'StartingGold', 'StartingCulture', 'StartPercent', 'BuildingMaintenancePercent', 'GrowthPercent', 'TrainPercent', 'ConstructPercent', 'CreatePercent', 'ResearchPercent', 'BuildPercent', 'ImprovementPercent', 'GreatPeoplePercent', 'CulturePercent', 'EventChancePerTurn', 'SoundtrackSpace', 'CityBombardEffectTag', 'AudioUnitVictoryScript', 'AudioUnitDefeatScript') with values (7, ERA_DIAMOND_ERA, TXT_KEY_ERA_7, FUTURE, 0, 1, 1, 1, 80000, 5, 5, 5, 4, 500000, 10000, 90, 1400, 60, 165, 195, 18, 50, 50, 50, 75, 50, 10, 40, CITY_BOMBARD_LATE, AS2D_VICTORY_LATE, AS2D_LOSS_LATE, ).
[289277.188] In XMLSerializer while updating table Eras from file XML/GameImfo/eras.xml.
[289277.188] PRIMARY KEY must be unique
[289277.188] constraint failed
[289277.188] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289277.188] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_PROJECT_MARS_MISSION, Mars Mission, ).
[289277.188] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_BUILDINGS.xml.
[289277.188] columns Language, Tag are not unique
[289277.188] constraint failed
[289277.188] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289277.188] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_TECH_INCUBATION_PODS_TITLE, Incubation Pods, ).
[289277.188] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_TECH.xml.
[289277.188] columns Language, Tag are not unique
[289277.188] constraint failed
[289277.188] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289277.188] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_PROMOTION_ADAMANTIUM, Adamantium Armor, ).
[289277.188] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_PROMOTIONS.xml.
[289277.188] columns Language, Tag are not unique
[289277.188] constraint failed
[289277.188] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289277.188] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_ERA_DIAMOND_ERA_QUOTE1, [NEWLINE] "The diamond age is the pinacle of humanity."[NEWLINE] - Yin Lang 2230[NEWLINE] , ).
[289277.188] In XMLSerializer while updating table Language_en_US from file XML/NewText/erasTEXT.xml.
[289277.188] columns Language, Tag are not unique
[289277.219] constraint failed
[289277.219] While executing - 'insert into UnitPromotions('Type', 'Description', 'Help', 'PortraitIndex', 'IconAtlas', 'OrderPriority', 'DefenseMod', 'Sound', 'CannotBeChosen', 'PediaType', 'PediaEntry') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);'
[289277.219] In XMLSerializer while inserting row into table insert into UnitPromotions('Type', 'Description', 'Help', 'PortraitIndex', 'IconAtlas', 'OrderPriority', 'DefenseMod', 'Sound', 'CannotBeChosen', 'PediaType', 'PediaEntry') with values (PROMOTION_ADAMANTIUM, TXT_KEY_PROMOTION_ADAMANTIUM_DESC, TXT_KEY_PROMOTION_ADAMANTIUM_HELP, 59, ABILITY_ATLAS, 0, 200, AS2D_IF_LEVELUP, 1, PEDIA_SHARED, TXT_KEY_PROMOTION_ADAMANTIUM, ).
[289277.219] In XMLSerializer while updating table UnitPromotions from file XML/Units/FM_Promotions.xml.
[289277.219] column Type is not unique
[289277.219] constraint failed
[289277.219] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289277.219] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_UNIT_RAILGUN_DESTROYER_DESC, Railgun Destroyer, ).
[289277.219] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_UNITS.xml.
[289277.219] columns Language, Tag are not unique
[289304.281] Validating Foreign Key Constraints...
[289305.000] Invalid Reference on Units.Civilopedia - "TXT_KEY_RAILGUN_DESTROYER_PEDIA" does not exist in Language_en_US
[289305.188] Failed Validation.
[289305.656]
------------------------------
[289385.719] no such table: Language_zh_CN
[289385.719] In Query - insert into Language_zh_CN('Tag', 'Text') values (?, ?);
[289385.719] In XMLSerializer while updating table Language_zh_CN from file Localization/ZH_CN.xml.
[289385.844] Database::XMLSerializer (LUA/InGame.xml): 'Row' or 'Delete' expected, got 'LuaContext'.
[289388.188] Database::XMLSerializer (XML/Defines/FM_artdefines_unitmembers.xml): 'Row' or 'Delete' expected, got 'Type'.
[289388.188] Database::XMLSerializer (XML/Defines/FM_artdefines_units.xml): 'Row' or 'Delete' expected, got 'Type'.
[289388.188] constraint failed
[289388.188] While executing - 'insert into BuildingClasses('Type', 'DefaultBuilding', 'Description') values (?, ?, ?);'
[289388.188] In XMLSerializer while inserting row into table insert into BuildingClasses('Type', 'DefaultBuilding', 'Description') with values (BUILDINGCLASS_INCUBATORS, BUILDING_INCUBATORS, TXT_KEY_BUILDING_INCUBATORS_DESC, ).
[289388.188] In XMLSerializer while updating table BuildingClasses from file XML/Buildings/CIV5BuildingClasses.xml.
[289388.188] column Type is not unique
[289388.188] constraint failed
[289388.188] While executing - 'insert into Buildings('Type', 'BuildingClass', 'Cost', 'GoldMaintenance', 'PrereqTech', 'Help', 'Description', 'Civilopedia', 'Strategy', 'ArtDefineTag', 'NukeImmune', 'NukeModifier', 'MinAreaSize', 'HurryCostModifier', 'IconAtlas', 'NeverCapture', 'PortraitIndex') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);'
[289388.188] In XMLSerializer while inserting row into table insert into Buildings('Type', 'BuildingClass', 'Cost', 'GoldMaintenance', 'PrereqTech', 'Help', 'Description', 'Civilopedia', 'Strategy', 'ArtDefineTag', 'NukeImmune', 'NukeModifier', 'MinAreaSize', 'HurryCostModifier', 'IconAtlas', 'NeverCapture', 'PortraitIndex') with values (BUILDING_BUNKER, BUILDINGCLASS_BUNKER, 450, 2, TECH_ELECTRONICS, TXT_KEY_BUILDING_BUNKER_HELP, TXT_KEY_BUILDING_BUNKER_DESC, TXT_KEY_BUILDING_BUNKER_PEDIA, TXT_KEY_BUILDING_BUNKER_STRATEGY, ART_DEF_BUILDING_BARRACKS, 1, -25, -1, 25, BW_ATLAS_1, 1, 6, ).
[289388.188] In XMLSerializer while updating table Buildings from file XML/Buildings/CIV5Buildings.xml.
[289388.188] column Type is not unique
[289388.188] constraint failed
[289388.188] While executing - 'insert into Colors('Type', 'Red', 'Green', 'Blue', 'Alpha') values (?, ?, ?, ?, ?);'
[289388.188] In XMLSerializer while inserting row into table insert into Colors('Type', 'Red', 'Green', 'Blue', 'Alpha') with values (COLOR_PLAYER_HEBREW_BACKGROUND, 0, 0.220, 0.722, 1, ).
[289388.188] In XMLSerializer while updating table Colors from file XML/Civs/HEB/hebrew.xml.
[289388.188] column Type is not unique
[289388.188] constraint failed
[289388.188]
[289388.188] In XMLSerializer while inserting row into table insert into Eras('ID', 'Type', 'Description', 'ArtPrefix', 'Strategy', 'NoGoodies', 'NoBarbUnits', 'NoBarbCities', 'ResearchAgreementCost', 'StartingUnitMultiplier', 'StartingDefenseUnits', 'StartingWorkerUnits', 'StartingExploreUnits', 'StartingGold', 'StartingCulture', 'StartPercent', 'BuildingMaintenancePercent', 'GrowthPercent', 'TrainPercent', 'ConstructPercent', 'CreatePercent', 'ResearchPercent', 'BuildPercent', 'ImprovementPercent', 'GreatPeoplePercent', 'CulturePercent', 'EventChancePerTurn', 'SoundtrackSpace', 'CityBombardEffectTag', 'AudioUnitVictoryScript', 'AudioUnitDefeatScript') with values (7, ERA_DIAMOND_ERA, TXT_KEY_ERA_7, FUTURE, 0, 1, 1, 1, 80000, 5, 5, 5, 4, 500000, 10000, 90, 1400, 60, 165, 195, 18, 50, 50, 50, 75, 50, 10, 40, CITY_BOMBARD_LATE, AS2D_VICTORY_LATE, AS2D_LOSS_LATE, ).
[289388.188] In XMLSerializer while updating table Eras from file XML/GameImfo/eras.xml.
[289388.188] PRIMARY KEY must be unique
[289388.188] constraint failed
[289388.188] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289388.188] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_PROJECT_MARS_MISSION, Mars Mission, ).
[289388.188] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_BUILDINGS.xml.
[289388.188] columns Language, Tag are not unique
[289388.188] constraint failed
[289388.188] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289388.188] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_TECH_INCUBATION_PODS_TITLE, Incubation Pods, ).
[289388.188] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_TECH.xml.
[289388.188] columns Language, Tag are not unique
[289388.188] constraint failed
[289388.188] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289388.188] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_PROMOTION_ADAMANTIUM, Adamantium Armor, ).
[289388.188] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_PROMOTIONS.xml.
[289388.188] columns Language, Tag are not unique
[289388.188] constraint failed
[289388.188] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289388.188] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_ERA_DIAMOND_ERA_QUOTE1, [NEWLINE] "The diamond age is the pinacle of humanity."[NEWLINE] - Yin Lang 2230[NEWLINE] , ).
[289388.188] In XMLSerializer while updating table Language_en_US from file XML/NewText/erasTEXT.xml.
[289388.188] columns Language, Tag are not unique
[289388.188] constraint failed
[289388.188] While executing - 'insert into UnitPromotions('Type', 'Description', 'Help', 'PortraitIndex', 'IconAtlas', 'OrderPriority', 'DefenseMod', 'Sound', 'CannotBeChosen', 'PediaType', 'PediaEntry') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);'
[289388.188] In XMLSerializer while inserting row into table insert into UnitPromotions('Type', 'Description', 'Help', 'PortraitIndex', 'IconAtlas', 'OrderPriority', 'DefenseMod', 'Sound', 'CannotBeChosen', 'PediaType', 'PediaEntry') with values (PROMOTION_ADAMANTIUM, TXT_KEY_PROMOTION_ADAMANTIUM_DESC, TXT_KEY_PROMOTION_ADAMANTIUM_HELP, 59, ABILITY_ATLAS, 0, 200, AS2D_IF_LEVELUP, 1, PEDIA_SHARED, TXT_KEY_PROMOTION_ADAMANTIUM, ).
[289388.188] In XMLSerializer while updating table UnitPromotions from file XML/Units/FM_Promotions.xml.
[289388.188] column Type is not unique
[289388.188] constraint failed
[289388.188] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289388.188] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_UNIT_RAILGUN_DESTROYER_DESC, Railgun Destroyer, ).
[289388.188] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_UNITS.xml.
[289388.188] columns Language, Tag are not unique
[289410.094] Validating Foreign Key Constraints...
[289410.813] Invalid Reference on Units.Civilopedia - "TXT_KEY_RAILGUN_DESTROYER_PEDIA" does not exist in Language_en_US
[289411.000] Failed Validation.
[289411.469]
------------------------------

 

[Voltron81]

Spoiler :

[289595.844] no such table: Language_zh_CN
[289595.844] In Query - insert into Language_zh_CN('Tag', 'Text') values (?, ?);
[289595.844] In XMLSerializer while updating table Language_zh_CN from file Localization/ZH_CN.xml.
[289595.969] Database::XMLSerializer (LUA/InGame.xml): 'Row' or 'Delete' expected, got 'LuaContext'.
[289597.719] Database::XMLSerializer (XML/Defines/FM_artdefines_unitmembers.xml): 'Row' or 'Delete' expected, got 'Type'.
[289597.719] Database::XMLSerializer (XML/Defines/FM_artdefines_units.xml): 'Row' or 'Delete' expected, got 'Type'.
[289597.719] constraint failed
[289597.719] While executing - 'insert into BuildingClasses('Type', 'DefaultBuilding', 'Description') values (?, ?, ?);'
[289597.719] In XMLSerializer while inserting row into table insert into BuildingClasses('Type', 'DefaultBuilding', 'Description') with values (BUILDINGCLASS_INCUBATORS, BUILDING_INCUBATORS, TXT_KEY_BUILDING_INCUBATORS_DESC, ).
[289597.719] In XMLSerializer while updating table BuildingClasses from file XML/Buildings/CIV5BuildingClasses.xml.
[289597.719] column Type is not unique
[289597.719] constraint failed
[289597.719] While executing - 'insert into Buildings('Type', 'BuildingClass', 'Cost', 'GoldMaintenance', 'PrereqTech', 'Help', 'Description', 'Civilopedia', 'Strategy', 'ArtDefineTag', 'NukeImmune', 'NukeModifier', 'MinAreaSize', 'HurryCostModifier', 'IconAtlas', 'NeverCapture', 'PortraitIndex') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);'
[289597.719] In XMLSerializer while inserting row into table insert into Buildings('Type', 'BuildingClass', 'Cost', 'GoldMaintenance', 'PrereqTech', 'Help', 'Description', 'Civilopedia', 'Strategy', 'ArtDefineTag', 'NukeImmune', 'NukeModifier', 'MinAreaSize', 'HurryCostModifier', 'IconAtlas', 'NeverCapture', 'PortraitIndex') with values (BUILDING_BUNKER, BUILDINGCLASS_BUNKER, 450, 2, TECH_ELECTRONICS, TXT_KEY_BUILDING_BUNKER_HELP, TXT_KEY_BUILDING_BUNKER_DESC, TXT_KEY_BUILDING_BUNKER_PEDIA, TXT_KEY_BUILDING_BUNKER_STRATEGY, ART_DEF_BUILDING_BARRACKS, 1, -25, -1, 25, BW_ATLAS_1, 1, 6, ).
[289597.750] In XMLSerializer while updating table Buildings from file XML/Buildings/CIV5Buildings.xml.
[289597.750] column Type is not unique
[289597.750] constraint failed
[289597.750] While executing - 'insert into Colors('Type', 'Red', 'Green', 'Blue', 'Alpha') values (?, ?, ?, ?, ?);'
[289597.750] In XMLSerializer while inserting row into table insert into Colors('Type', 'Red', 'Green', 'Blue', 'Alpha') with values (COLOR_PLAYER_HEBREW_BACKGROUND, 0, 0.220, 0.722, 1, ).
[289597.750] In XMLSerializer while updating table Colors from file XML/Civs/HEB/hebrew.xml.
[289597.750] column Type is not unique
[289597.750] constraint failed
[289597.750]
[289597.750] In XMLSerializer while inserting row into table insert into Eras('ID', 'Type', 'Description', 'ArtPrefix', 'Strategy', 'NoGoodies', 'NoBarbUnits', 'NoBarbCities', 'ResearchAgreementCost', 'StartingUnitMultiplier', 'StartingDefenseUnits', 'StartingWorkerUnits', 'StartingExploreUnits', 'StartingGold', 'StartingCulture', 'StartPercent', 'BuildingMaintenancePercent', 'GrowthPercent', 'TrainPercent', 'ConstructPercent', 'CreatePercent', 'ResearchPercent', 'BuildPercent', 'ImprovementPercent', 'GreatPeoplePercent', 'CulturePercent', 'EventChancePerTurn', 'SoundtrackSpace', 'CityBombardEffectTag', 'AudioUnitVictoryScript', 'AudioUnitDefeatScript') with values (7, ERA_DIAMOND_ERA, TXT_KEY_ERA_7, FUTURE, 0, 1, 1, 1, 80000, 5, 5, 5, 4, 500000, 10000, 90, 1400, 60, 165, 195, 18, 50, 50, 50, 75, 50, 10, 40, CITY_BOMBARD_LATE, AS2D_VICTORY_LATE, AS2D_LOSS_LATE, ).
[289597.750] In XMLSerializer while updating table Eras from file XML/GameImfo/eras.xml.
[289597.750] PRIMARY KEY must be unique
[289597.750] constraint failed
[289597.750] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289597.750] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_PROJECT_MARS_MISSION, Mars Mission, ).
[289597.750] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_BUILDINGS.xml.
[289597.750] columns Language, Tag are not unique
[289597.750] constraint failed
[289597.750] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289597.750] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_TECH_INCUBATION_PODS_TITLE, Incubation Pods, ).
[289597.750] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_TECH.xml.
[289597.750] columns Language, Tag are not unique
[289597.750] constraint failed
[289597.750] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289597.750] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_PROMOTION_ADAMANTIUM, Adamantium Armor, ).
[289597.750] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_PROMOTIONS.xml.
[289597.750] columns Language, Tag are not unique
[289597.750] constraint failed
[289597.750] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289597.750] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_ERA_DIAMOND_ERA_QUOTE1, [NEWLINE] "The diamond age is the pinacle of humanity."[NEWLINE] - Yin Lang 2230[NEWLINE] , ).
[289597.750] In XMLSerializer while updating table Language_en_US from file XML/NewText/erasTEXT.xml.
[289597.750] columns Language, Tag are not unique
[289597.750] constraint failed
[289597.750] While executing - 'insert into UnitPromotions('Type', 'Description', 'Help', 'PortraitIndex', 'IconAtlas', 'OrderPriority', 'DefenseMod', 'Sound', 'CannotBeChosen', 'PediaType', 'PediaEntry') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);'
[289597.750] In XMLSerializer while inserting row into table insert into UnitPromotions('Type', 'Description', 'Help', 'PortraitIndex', 'IconAtlas', 'OrderPriority', 'DefenseMod', 'Sound', 'CannotBeChosen', 'PediaType', 'PediaEntry') with values (PROMOTION_ADAMANTIUM, TXT_KEY_PROMOTION_ADAMANTIUM_DESC, TXT_KEY_PROMOTION_ADAMANTIUM_HELP, 59, ABILITY_ATLAS, 0, 200, AS2D_IF_LEVELUP, 1, PEDIA_SHARED, TXT_KEY_PROMOTION_ADAMANTIUM, ).
[289597.750] In XMLSerializer while updating table UnitPromotions from file XML/Units/FM_Promotions.xml.
[289597.750] column Type is not unique
[289597.750] constraint failed
[289597.750] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289597.750] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_UNIT_RAILGUN_DESTROYER_DESC, Railgun Destroyer, ).
[289597.750] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_UNITS.xml.
[289597.750] columns Language, Tag are not unique
[289629.469] Validating Foreign Key Constraints...
[289630.188] Invalid Reference on Units.Civilopedia - "TXT_KEY_RAILGUN_DESTROYER_PEDIA" does not exist in Language_en_US
[289630.375] Failed Validation.
[289630.844]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 446088 7744144
PageCache: 4195 4982
LookAside: 0 0
Scratch: 0 1

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

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

Prepared Statements:
Current: 24
------------------------------
[289777.625] no such table: Language_zh_CN
[289777.625] In Query - insert into Language_zh_CN('Tag', 'Text') values (?, ?);
[289777.625] In XMLSerializer while updating table Language_zh_CN from file Localization/ZH_CN.xml.
[289777.813] Database::XMLSerializer (LUA/InGame.xml): 'Row' or 'Delete' expected, got 'LuaContext'.
[289779.781] Database::XMLSerializer (XML/Defines/FM_artdefines_unitmembers.xml): 'Row' or 'Delete' expected, got 'Type'.
[289779.781] Database::XMLSerializer (XML/Defines/FM_artdefines_units.xml): 'Row' or 'Delete' expected, got 'Type'.
[289779.781] constraint failed
[289779.781] While executing - 'insert into BuildingClasses('Type', 'DefaultBuilding', 'Description') values (?, ?, ?);'
[289779.781] In XMLSerializer while inserting row into table insert into BuildingClasses('Type', 'DefaultBuilding', 'Description') with values (BUILDINGCLASS_INCUBATORS, BUILDING_INCUBATORS, TXT_KEY_BUILDING_INCUBATORS_DESC, ).
[289779.781] In XMLSerializer while updating table BuildingClasses from file XML/Buildings/CIV5BuildingClasses.xml.
[289779.781] column Type is not unique
[289779.781] constraint failed
[289779.781] While executing - 'insert into Buildings('Type', 'BuildingClass', 'Cost', 'GoldMaintenance', 'PrereqTech', 'Help', 'Description', 'Civilopedia', 'Strategy', 'ArtDefineTag', 'NukeImmune', 'NukeModifier', 'MinAreaSize', 'HurryCostModifier', 'IconAtlas', 'NeverCapture', 'PortraitIndex') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);'
[289779.781] In XMLSerializer while inserting row into table insert into Buildings('Type', 'BuildingClass', 'Cost', 'GoldMaintenance', 'PrereqTech', 'Help', 'Description', 'Civilopedia', 'Strategy', 'ArtDefineTag', 'NukeImmune', 'NukeModifier', 'MinAreaSize', 'HurryCostModifier', 'IconAtlas', 'NeverCapture', 'PortraitIndex') with values (BUILDING_BUNKER, BUILDINGCLASS_BUNKER, 450, 2, TECH_ELECTRONICS, TXT_KEY_BUILDING_BUNKER_HELP, TXT_KEY_BUILDING_BUNKER_DESC, TXT_KEY_BUILDING_BUNKER_PEDIA, TXT_KEY_BUILDING_BUNKER_STRATEGY, ART_DEF_BUILDING_BARRACKS, 1, -25, -1, 25, BW_ATLAS_1, 1, 6, ).
[289779.781] In XMLSerializer while updating table Buildings from file XML/Buildings/CIV5Buildings.xml.
[289779.781] column Type is not unique
[289779.781] constraint failed
[289779.781] While executing - 'insert into Colors('Type', 'Red', 'Green', 'Blue', 'Alpha') values (?, ?, ?, ?, ?);'
[289779.781] In XMLSerializer while inserting row into table insert into Colors('Type', 'Red', 'Green', 'Blue', 'Alpha') with values (COLOR_PLAYER_HEBREW_BACKGROUND, 0, 0.220, 0.722, 1, ).
[289779.781] In XMLSerializer while updating table Colors from file XML/Civs/HEB/hebrew.xml.
[289779.781] column Type is not unique
[289779.781] constraint failed
[289779.781]
[289779.781] In XMLSerializer while inserting row into table insert into Eras('ID', 'Type', 'Description', 'ArtPrefix', 'Strategy', 'NoGoodies', 'NoBarbUnits', 'NoBarbCities', 'ResearchAgreementCost', 'StartingUnitMultiplier', 'StartingDefenseUnits', 'StartingWorkerUnits', 'StartingExploreUnits', 'StartingGold', 'StartingCulture', 'StartPercent', 'BuildingMaintenancePercent', 'GrowthPercent', 'TrainPercent', 'ConstructPercent', 'CreatePercent', 'ResearchPercent', 'BuildPercent', 'ImprovementPercent', 'GreatPeoplePercent', 'CulturePercent', 'EventChancePerTurn', 'SoundtrackSpace', 'CityBombardEffectTag', 'AudioUnitVictoryScript', 'AudioUnitDefeatScript') with values (7, ERA_DIAMOND_ERA, TXT_KEY_ERA_7, FUTURE, 0, 1, 1, 1, 80000, 5, 5, 5, 4, 500000, 10000, 90, 1400, 60, 165, 195, 18, 50, 50, 50, 75, 50, 10, 40, CITY_BOMBARD_LATE, AS2D_VICTORY_LATE, AS2D_LOSS_LATE, ).
[289779.781] In XMLSerializer while updating table Eras from file XML/GameImfo/eras.xml.
[289779.781] PRIMARY KEY must be unique
[289779.781] constraint failed
[289779.781] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289779.781] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_PROJECT_MARS_MISSION, Mars Mission, ).
[289779.781] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_BUILDINGS.xml.
[289779.781] columns Language, Tag are not unique
[289779.781] constraint failed
[289779.781] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289779.781] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_TECH_INCUBATION_PODS_TITLE, Incubation Pods, ).
[289779.781] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_TECH.xml.
[289779.781] columns Language, Tag are not unique
[289779.781] constraint failed
[289779.781] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289779.781] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_PROMOTION_ADAMANTIUM, Adamantium Armor, ).
[289779.781] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_PROMOTIONS.xml.
[289779.781] columns Language, Tag are not unique
[289779.781] constraint failed
[289779.781] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289779.781] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_ERA_DIAMOND_ERA_QUOTE1, [NEWLINE] "The diamond age is the pinacle of humanity."[NEWLINE] - Yin Lang 2230[NEWLINE] , ).
[289779.781] In XMLSerializer while updating table Language_en_US from file XML/NewText/erasTEXT.xml.
[289779.781] columns Language, Tag are not unique
[289779.781] constraint failed
[289779.781] While executing - 'insert into UnitPromotions('Type', 'Description', 'Help', 'PortraitIndex', 'IconAtlas', 'OrderPriority', 'DefenseMod', 'Sound', 'CannotBeChosen', 'PediaType', 'PediaEntry') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);'
[289779.781] In XMLSerializer while inserting row into table insert into UnitPromotions('Type', 'Description', 'Help', 'PortraitIndex', 'IconAtlas', 'OrderPriority', 'DefenseMod', 'Sound', 'CannotBeChosen', 'PediaType', 'PediaEntry') with values (PROMOTION_ADAMANTIUM, TXT_KEY_PROMOTION_ADAMANTIUM_DESC, TXT_KEY_PROMOTION_ADAMANTIUM_HELP, 59, ABILITY_ATLAS, 0, 200, AS2D_IF_LEVELUP, 1, PEDIA_SHARED, TXT_KEY_PROMOTION_ADAMANTIUM, ).
[289779.781] In XMLSerializer while updating table UnitPromotions from file XML/Units/FM_Promotions.xml.
[289779.781] column Type is not unique
[289779.781] constraint failed
[289779.781] While executing - 'insert into Language_en_US('Tag', 'Text') values (?, ?);'
[289779.781] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_UNIT_RAILGUN_DESTROYER_DESC, Railgun Destroyer, ).
[289779.781] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_UNITS.xml.
[289779.781] columns Language, Tag are not unique
[289830.938] Validating Foreign Key Constraints...
[289831.656] Invalid Reference on Units.Civilopedia - "TXT_KEY_RAILGUN_DESTROYER_PEDIA" does not exist in Language_en_US
[289831.813] Failed Validation.
[289832.313]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 446088 7744144
PageCache: 4194 4982
LookAside: 0 0
Scratch: 0 1

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

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

Prepared Statements:
Current: 24
------------------------------

 

[Horem]

Dude, thats alot of errors...

[289388.188] In XMLSerializer while inserting row into table insert into Language_en_US('Tag', 'Text') with values (TXT_KEY_UNIT_RAILGUN_DESTROYER_DESC, Railgun Destroyer, ).
[289388.188] In XMLSerializer while updating table Language_en_US from file XML/NewText/CIV5GameText_UNITS.xml.
[289388.188] columns Language, Tag are not unique

That one is telling you that you have a duplicate tag, so the whole file fails.

[289388.188] In XMLSerializer while inserting row into table insert into UnitPromotions('Type', 'Description', 'Help', 'PortraitIndex', 'IconAtlas', 'OrderPriority', 'DefenseMod', 'Sound', 'CannotBeChosen', 'PediaType', 'PediaEntry') with values (PROMOTION_ADAMANTIUM, TXT_KEY_PROMOTION_ADAMANTIUM_DESC, TXT_KEY_PROMOTION_ADAMANTIUM_HELP, 59, ABILITY_ATLAS, 0, 200, AS2D_IF_LEVELUP, 1, PEDIA_SHARED, TXT_KEY_PROMOTION_ADAMANTIUM, ).
[289388.188] In XMLSerializer while updating table UnitPromotions from file XML/Units/FM_Promotions.xml.
[289388.188] column Type is not unique

Same for this one, duplicate tag, whole file fails. Actualy most of them errors are related to Duplicate Tags, if I were you id fix them first, qyite easy realy, add a number to them e.g: TXT_KEY_PROMOTION_ADAMANTIUM2_DESC.

[289388.188] Database::XMLSerializer (XML/Defines/FM_artdefines_unitmembers.xml): 'Row' or 'Delete' expected, got 'Type'.
[289388.188] Database::XMLSerializer (XML/Defines/FM_artdefines_units.xml): 'Row' or 'Delete' expected, got 'Type'.
[289388.188] constraint failed

As far as I am awsare(from reading reports here on the forums) you now have too use SQL to update artdefines files, not use the whole files liek it was pre patch, so this u need to address.

 

[Voltron81]

i am unsure of how it could be duplicate tags. for example if i search the solution for TXT_KEY_UNIT_RAILGUN_DESTROYER_DESC only have the one. I can post the building xml. BUt i find no duplications yet. does the latest patch also affect new atlas graphics?

 

[PawelS]

I think you should clear your cache - delete all content from My Documents\My Games\Sid Meier's Civilization 5\cache

 

[Voltron81]

@PawelS thanks that did the trick on the funky chicken stuff, now i might be able to figure out what is going on. Looking at the editor the genetic age disappeared. Time to work.

edit: oddity. I using the in game editor mod. In the tech section, its all there in alll its beauty. I do not think the techs are an issue but a symptom. but of what? I start a new game and no visual units. No tech tree. Settle a city and there is nothing in it! Am i going nuts here?