StaticSoviet
Chieftain
- Joined
- Apr 28, 2017
- Messages
- 2
I usually mod Civ VI in XML and I've started to learn how to mod in SQL. Long story short I cant find the problem with my code. I have narrowed it down to this one file.
Here's the error code:
Any help would be appreciated
Code:
--==========================================================================================================================
-- UNITS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('UNIT_EGYPTIAN_JANISSARY', 'KIND_UNIT');
--------------------------------------------------------------------------------------------------------------------------
-- Units
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Units
(UnitType, BaseMoves, Cost, AdvisorType, BaseSightRange, ZoneOfControl, Domain, FormationClass, Name, Description, MandatoryObsoleteTech, PurchaseYield, PromotionClass, Maintenance, Combat, PrereqTech, TraitType)
SELECT 'UNIT_EGYPTIAN_JANISSARY', BaseMoves, Cost, AdvisorType, BaseSightRange, ZoneOfControl, Domain, FormationClass, 'LOC_UNIT_EGYPTIAN_JANISSARY_NAME', 'LOC_UNIT_EGYPTIAN_JANISSARY_DESCRIPTION', MandatoryObsoleteTech, PurchaseYield, PromotionClass, Maintenance, Combat, PrereqTech, 'TRAIT_LEADER_UNIT_EGYPTIAN_JANISSARY'
FROM Units WHERE UnitType = 'UNIT_MUSKETMAN';
--------------------------------------------------------------------------------------------------------------------------
-- UnitUpgrades
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO UnitUpgrades
(Unit, UpgradeUnit)
SELECT 'UNIT_EGYPTIAN_JANISSARY', UpgradeUnit
FROM UnitUpgrades WHERE Unit = 'UNIT_MUSKETMAN';
--------------------------------------------------------------------------------------------------------------------------
-- UnitAIInfos
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO UnitAIInfos
(UnitType, AiType)
SELECT 'UNIT_EGYPTIAN_JANISSARY', AiType
FROM UnitAIInfos WHERE UnitType = 'UNIT_MUSKETMAN';
--------------------------------------------------------------------------------------------------------------------------
-- Tags
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Tags
(Tag, Vocabulary)
VALUES ('CLASS_EGYPTIAN_JANISSARY', 'ABILITY_CLASS');
--------------------------------------------------------------------------------------------------------------------------
-- TypeTags
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO TypeTags
(Type, Tag)
SELECT 'UNIT_EGYPTIAN_JANISSARY', Tag
FROM TypeTags WHERE Type = 'UNIT_MUSKETMAN';
INSERT INTO TypeTags
(Type, Tag)
VALUES ('UNIT_EGYPTIAN_JANISSARY', 'CLASS_EGYPTIAN_JANISSARY');
--==========================================================================================================================
-- UNITS: ABILITIES
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('ABILITY_EGYPTIAN_JANISSARY', 'KIND_ABILITY');
--------------------------------------------------------------------------------------------------------------------------
-- TypeTags
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO TypeTags
(Type, Tag)
VALUES ('ABILITY_EGYPTIAN_JANISSARY', 'CLASS_EGYPTIAN_JANISSARY');
--------------------------------------------------------------------------------------------------------------------------
-- UnitAbilities
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO UnitAbilities
(UnitAbilityType, Name, Description)
VALUES ('ABILITY_EGYPTIAN_JANISSARY', 'LOC_ABILITY_EGYPTIAN_JANISSARY_NAME', 'LOC_ABILITY_EGYPTIAN_JANISSARY_DESCRIPTION');
--------------------------------------------------------------------------------------------------------------------------
-- UnitAbilityModifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO UnitAbilityModifiers
(UnitAbilityType, ModifierId)
VALUES ('ABILITY_EGYPTIAN_JANISSARY', 'ROUGH_RIDER_POST_COMBAT_CULTURE'),
('ABILITY_EGYPTIAN_JANISSARY', 'GARDE_CONTINENT_COMBAT');
--------------------------------------------------------------------------------------------------------------------------
--==========================================================================================================================
-- UNITS: TRAITS
--==========================================================================================================================
--------------------------------------------------------------------------------------------------------------------------
-- Traits
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Traits
(TraitType, Name, Description)
VALUES ('TRAIT_LEADER_UNIT_EGYPTIAN_JANISSARY', 'LOC_UNIT_EGYPTIAN_JANISSARY_NAME', 'LOC_UNIT_EGYPTIAN_JANISSARY_DESCRIPTION);
--==========================================================================================================================
-- LEADERS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('LEADER_SS_GRACIE', 'KIND_LEADER');
--------------------------------------------------------------------------------------------------------------------------
-- Leaders
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Leaders
(LeaderType, Name, InheritFrom, SceneLayers)
VALUES ('LEADER_SS_GRACIE', 'LOC_LEADER_SS_GRACIE_NAME', 'LEADER_DEFAULT', 4);
--------------------------------------------------------------------------------------------------------------------------
-- LeaderQuotes
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO LeaderQuotes
(LeaderType, Quote)
VALUES ('LEADER_SS_GRACIE', 'LOC_PEDIA_LEADERS_PAGE_LEADER_SS_GRACIE_QUOTE');
--------------------------------------------------------------------------------------------------------------------------
-- HistoricalAgendas
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO HistoricalAgendas
(LeaderType, AgendaType)
VALUES ('LEADER_SS_GRACIE', 'AGENDA_QUEEN_OF_NILE');
--------------------------------------------------------------------------------------------------------------------------
-- AgendaPreferredLeaders
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO AgendaPreferredLeaders
(LeaderType, AgendaType)
VALUES ('LEADER_SS_GRACIE', 'AGENDA_PREFER_INCOME');
--------------------------------------------------------------------------------------------------------------------------
-- LeaderTraits
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO LeaderTraits
(LeaderType, TraitType)
VALUES ('LEADER_SS_GRACIE', 'TRAIT_LEADER_GLORY_AND_GOLD'),
('LEADER_SS_GRACIE', 'TRAIT_LEADER_UNIT_EGYPTIAN_JANISSARY');
--==========================================================================================================================
-- LEADERS: AI
--==========================================================================================================================
-- AiListTypes
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO AiListTypes
(ListType)
VALUES ('SS_GRACIEBuildings'),
('SS_GRACIEDistricts'),
('SS_GRACIEPseudoYields'),
('SS_GRACIETechs'),
('SS_GRACIEUnits');
--------------------------------------------------------------------------------------------------------------------------
-- AiLists
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO AiLists
(ListType, LeaderType, System)
VALUES ('SS_GRACIEBuildings', 'TRAIT_LEADER_GLORY_AND_GOLD', 'Buildings'),
('SS_GRACIEDistricts', 'TRAIT_LEADER_GLORY_AND_GOLD', 'Districts'),
('SS_GRACIETechs', 'TRAIT_LEADER_GLORY_AND_GOLD', 'Technologies'),
('SS_GRACIETechs', 'TRAIT_LEADER_GLORY_AND_GOLD', 'Technologies'),
('SS_GRACIEPseudoYields', 'TRAIT_LEADER_GLORY_AND_GOLD', 'PseudoYields'),
('SS_GRACIEUnits', 'TRAIT_LEADER_GLORY_AND_GOLD', 'Units'),
('ScienceLoverSciencePreference', 'TRAIT_LEADER_GLORY_AND_GOLD', 'Yields');
--------------------------------------------------------------------------------------------------------------------------
-- AiFavoredItems
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO AiFavoredItems
(ListType, Favored, Value, Item)
VALUES ('SS_GRACIEDistricts', 1, 1, 'DISTRICT_CAMPUS'),
('SS_GRACIEDistricts', 1, 1, 'DISTRICT_INDUSTRIAL_ZONE'),
('SS_GRACIEDistricts', 1, 1, 'IMPROVEMENT_SPHINX'),
('SS_GRACIETechs', 1, 0, 'TECH_BRONZE_WORKING'),
('SS_GRACIETechs', 1, 0, 'TECH_COMBUSTION'),
('SS_GRACIETechs', 1, 0, 'TECH_MILITARY_TACTICS'),
('SS_GRACIEPseudoYields', 1, 10, 'PSEUDOYIELD_UNIT_COMBAT'),
('SS_GRACIEUnits', 1, 0, 'UNIT_EGYPTIAN_JANISSARY');
--==========================================================================================================================
-- LEADERS: COLOURS
--==========================================================================================================================
-- PlayerColors
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO PlayerColors
(Type, Usage, PrimaryColor, SecondaryColor, TextColor)
VALUES ('LEADER_SS_GRACIE', 'Unique', 'COLOR_PLAYER_EGYPT_GRACIE_PRIMARY', 'COLOR_PLAYER_EGYPT_GRACIE_SECONDARY', 'COLOR_PLAYER_WHITE_TEXT');
INSERT INTO Colors
(Type, Red, Green, Blue, Alpha)
VALUES ('COLOR_PLAYER_EGYPT_GRACIE_PRIMARY', 0.462, 0.129, 0.129, 1),
('COLOR_PLAYER_EGYPT_GRACIE_SECONDARY', 0.839, 0.635, 0.031, 1);
--==========================================================================================================================
-- LEADERS: LOADING INFO
--==========================================================================================================================
-- LoadingInfo
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO LoadingInfo
(LeaderType, BackgroundImage, ForegroundImage, PlayDawnOfManAudio)
VALUES ('LEADER_SS_GRACIE', 'LEADER_CLEOPATRA_BACKGROUND', 'LEADER_CLEOPATRA_NEUTRAL', 0);
--==========================================================================================================================
-- LEADERS: TRAITS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('TRAIT_LEADER_GLORY_AND_GOLD', 'KIND_TRAIT'),
('TRAIT_LEADER_UNIT_EGYPTIAN_JANISSARY', 'KIND_TRAIT');
--------------------------------------------------------------------------------------------------------------------------
-- Traits
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Traits
(TraitType, Name, Description)
VALUES ('TRAIT_LEADER_GLORY_AND_GOLD', 'LOC_TRAIT_LEADER_GLORY_AND_GOLD_NAME', 'LOC_TRAIT_LEADER_GLORY_AND_GOLD_DESCRIPTION');
--------------------------------------------------------------------------------------------------------------------------
-- TraitModifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO TraitModifiers
(TraitType, ModifierId)
VALUES ('TRAIT_LEADER_GLORY_AND_GOLD', 'TRAIT_MILITARY_GOVERNMENT_SLOT'),
('TRAIT_LEADER_GLORY_AND_GOLD', 'TRAIT_ECONOMIC_GOVERNMENT_SLOT');
--------------------------------------------------------------------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Modifiers
(ModifierId, ModifierType)
VALUES ('TRAIT_ECONOMIC_GOVERNMENT_SLOT', 'MODIFIER_PLAYER_CULTURE_ADJUST_GOVERNMENT_SLOTS_MODIFIER');
--------------------------------------------------------------------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierArguments
(ModifierId, Name, Value)
VALUES ('TRAIT_ECONOMIC_GOVERNMENT_SLOT', 'GovernmentSlotType', 'SLOT_ECONOMIC');
--==========================================================================================================================
-- CIVILIZATIONS
--==========================================================================================================================
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationLeaders
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CivilizationLeaders
(CivilizationType, LeaderType, CapitalName)
VALUES ('CIVILIZATION_EGYPT', 'LEADER_SS_GRACIE', 'Alexandria');
----------------------------------------------------------------------------------------------------------------------------
Here's the error code:
Code:
[3055440.232] [Localization]: Validating Foreign Key Constraints...
[3055440.234] [Localization]: Passed Validation.
[3055440.260] [Configuration]: Validating Foreign Key Constraints...
[3055440.261] [Configuration]: Passed Validation.
[3055449.089] [FullTextSearch]: Initializing FullTextSearch
[3055451.580] [Gameplay]: Validating Foreign Key Constraints...
[3055451.623] [Gameplay]: Passed Validation.
[3055453.912] [Configuration]: Validating Foreign Key Constraints...
[3055453.913] [Configuration]: Passed Validation.
[3055475.992] [FullTextSearch]: FTS - Creating Context
[3055478.756] [FullTextSearch]: FTS - Creating Context
[3055486.617] [Configuration]: Validating Foreign Key Constraints...
[3055486.618] [Configuration]: Passed Validation.
[3055490.152] [Configuration]: Validating Foreign Key Constraints...
[3055490.152] [Configuration]: Passed Validation.
[3055513.900] [Configuration]: Validating Foreign Key Constraints...
[3055513.901] [Configuration]: Passed Validation.
[3055516.646] [Gameplay] ERROR: near "LEADER_SS_GRACIE": syntax error
[3055516.646] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3055516.646] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3055516.646] [Gameplay]: Validating Foreign Key Constraints...
[3055516.686] [Gameplay] ERROR: Invalid Reference on Units.TraitType - "TRAIT_LEADER_UNIT_EGYPTIAN_JANISSARY" does not exist in Traits
[3055516.689] [Gameplay]: Failed Validation.
[3055516.759] [Gameplay]: Validating Foreign Key Constraints...
[3055516.804] [Gameplay]: Passed Validation.
[3055522.209] [FullTextSearch]: FTS - Creating Context
[3055522.525] [Configuration]: Validating Foreign Key Constraints...
[3055522.526] [Configuration]: Passed Validation.
[3056377.333] [FullTextSearch]: FTS - Creating Context
[3056381.508] [Configuration]: Validating Foreign Key Constraints...
[3056381.509] [Configuration]: Passed Validation.
[3056384.124] [Configuration]: Validating Foreign Key Constraints...
[3056384.125] [Configuration]: Passed Validation.
[3056394.915] [Configuration]: Validating Foreign Key Constraints...
[3056394.915] [Configuration]: Passed Validation.
[3056399.762] [Gameplay] ERROR: near "LEADER_SS_GRACIE": syntax error
[3056399.763] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3056399.763] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3056399.763] [Gameplay]: Validating Foreign Key Constraints...
[3056399.806] [Gameplay] ERROR: Invalid Reference on Units.TraitType - "TRAIT_LEADER_UNIT_EGYPTIAN_JANISSARY" does not exist in Traits
[3056399.809] [Gameplay]: Failed Validation.
[3056399.903] [Gameplay]: Validating Foreign Key Constraints...
[3056399.955] [Gameplay]: Passed Validation.
[3056405.227] [FullTextSearch]: FTS - Creating Context
[3056406.205] [Configuration]: Validating Foreign Key Constraints...
[3056406.206] [Configuration]: Passed Validation.
[3056684.980] [FullTextSearch]: FTS - Creating Context
[3056693.075] [Configuration]: Validating Foreign Key Constraints...
[3056693.076] [Configuration]: Passed Validation.
[3056695.903] [Configuration]: Validating Foreign Key Constraints...
[3056695.904] [Configuration]: Passed Validation.
[3056704.494] [Configuration]: Validating Foreign Key Constraints...
[3056704.495] [Configuration]: Passed Validation.
[3056708.584] [Gameplay] ERROR: near "LEADER_SS_GRACIE": syntax error
[3056708.584] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3056708.584] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3056708.584] [Gameplay]: Validating Foreign Key Constraints...
[3056708.624] [Gameplay] ERROR: Invalid Reference on Units.TraitType - "TRAIT_LEADER_UNIT_EGYPTIAN_JANISSARY" does not exist in Traits
[3056708.627] [Gameplay]: Failed Validation.
[3056708.693] [Gameplay]: Validating Foreign Key Constraints...
[3056708.736] [Gameplay]: Passed Validation.
[3056713.200] [FullTextSearch]: FTS - Creating Context
[3056713.515] [Configuration]: Validating Foreign Key Constraints...
[3056713.516] [Configuration]: Passed Validation.
[3057640.536] [FullTextSearch]: FTS - Creating Context
[3057647.865] [Configuration]: Validating Foreign Key Constraints...
[3057647.866] [Configuration]: Passed Validation.
[3057651.309] [Configuration]: Validating Foreign Key Constraints...
[3057651.310] [Configuration]: Passed Validation.
[3057666.055] [Configuration]: Validating Foreign Key Constraints...
[3057666.056] [Configuration]: Passed Validation.
[3057670.126] [Gameplay] ERROR: near "LEADER_SS_GRACIE": syntax error
[3057670.127] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3057670.127] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3057670.127] [Gameplay]: Validating Foreign Key Constraints...
[3057670.166] [Gameplay] ERROR: Invalid Reference on Units.TraitType - "TRAIT_LEADER_UNIT_EGYPTIAN_JANISSARY" does not exist in Traits
[3057670.169] [Gameplay]: Failed Validation.
[3057670.236] [Gameplay]: Validating Foreign Key Constraints...
[3057670.283] [Gameplay]: Passed Validation.
[3057677.035] [FullTextSearch]: FTS - Creating Context
[3057677.335] [Configuration]: Validating Foreign Key Constraints...
[3057677.336] [Configuration]: Passed Validation.
[3058620.869] [FullTextSearch]: FTS - Creating Context
[3058628.907] [Configuration]: Validating Foreign Key Constraints...
[3058628.908] [Configuration]: Passed Validation.
[3058631.669] [Configuration]: Validating Foreign Key Constraints...
[3058631.670] [Configuration]: Passed Validation.
[3058644.000] [Configuration]: Validating Foreign Key Constraints...
[3058644.001] [Configuration]: Passed Validation.
[3058648.761] [Gameplay] ERROR: near "LEADER_SS_GRACIE": syntax error
[3058648.761] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3058648.761] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3058648.761] [Gameplay]: Validating Foreign Key Constraints...
[3058648.802] [Gameplay] ERROR: Invalid Reference on Units.TraitType - "TRAIT_LEADER_UNIT_EGYPTIAN_JANISSARY" does not exist in Traits
[3058648.806] [Gameplay]: Failed Validation.
[3058648.872] [Gameplay]: Validating Foreign Key Constraints...
[3058648.916] [Gameplay]: Passed Validation.
[3058653.652] [FullTextSearch]: FTS - Creating Context
[3058653.959] [Configuration]: Validating Foreign Key Constraints...
[3058653.960] [Configuration]: Passed Validation.
[3059363.127] [FullTextSearch]: FTS - Creating Context
[3059368.578] [Configuration]: Validating Foreign Key Constraints...
[3059368.579] [Configuration]: Passed Validation.
[3059372.414] [Configuration]: Validating Foreign Key Constraints...
[3059372.415] [Configuration]: Passed Validation.
[3059417.698] [Configuration]: Validating Foreign Key Constraints...
[3059417.700] [Configuration]: Passed Validation.
[3059422.701] [Gameplay] ERROR: near "LEADER_SS_GRACIE": syntax error
[3059422.701] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3059422.701] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3059422.701] [Gameplay]: Validating Foreign Key Constraints...
[3059422.739] [Gameplay] ERROR: Invalid Reference on Units.TraitType - "TRAIT_LEADER_UNIT_EGYPTIAN_JANISSARY" does not exist in Traits
[3059422.743] [Gameplay]: Failed Validation.
[3059422.808] [Gameplay]: Validating Foreign Key Constraints...
[3059422.850] [Gameplay]: Passed Validation.
[3059427.340] [FullTextSearch]: FTS - Creating Context
[3059427.642] [Configuration]: Validating Foreign Key Constraints...
[3059427.643] [Configuration]: Passed Validation.
[3060088.629] [FullTextSearch]: FTS - Creating Context
[3060107.089] [Configuration]: Validating Foreign Key Constraints...
[3060107.090] [Configuration]: Passed Validation.
[3060109.880] [Configuration]: Validating Foreign Key Constraints...
[3060109.881] [Configuration]: Passed Validation.
[3060121.452] [Configuration]: Validating Foreign Key Constraints...
[3060121.452] [Configuration]: Passed Validation.
[3060125.745] [Gameplay] ERROR: near "LEADER_SS_GRACIE": syntax error
[3060125.745] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3060125.746] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3060125.746] [Gameplay]: Validating Foreign Key Constraints...
[3060125.784] [Gameplay] ERROR: Invalid Reference on Units.TraitType - "TRAIT_LEADER_UNIT_EGYPTIAN_JANISSARY" does not exist in Traits
[3060125.788] [Gameplay]: Failed Validation.
[3060125.850] [Gameplay]: Validating Foreign Key Constraints...
[3060125.891] [Gameplay]: Passed Validation.
[3060130.026] [FullTextSearch]: FTS - Creating Context
[3060130.307] [Configuration]: Validating Foreign Key Constraints...
[3060130.308] [Configuration]: Passed Validation.
[3060139.612] [FullTextSearch]: FTS - Creating Context
[3060147.057] [FullTextSearch]: FullTextSearch - Shutting down
Any help would be appreciated