opedoh16
Chieftain
- Joined
- Apr 23, 2017
- Messages
- 4
I need some help with spotting the syntax error in this code. If anyone could help, I appreciate it.
The error started when I added the table DynamicModifiers. In game, it only disables the Leader Ability, but most of the other functions look fine (UU, UB, Civilization). The Database.log mentions "ERROR: near "(": syntax error". It is further below.
Gameplay.sql:
Database.log:
The error started when I added the table DynamicModifiers. In game, it only disables the Leader Ability, but most of the other functions look fine (UU, UB, Civilization). The Database.log mentions "ERROR: near "(": syntax error". It is further below.
Gameplay.sql:
Code:
INSERT INTO Types
(Type, Kind)
VALUES ('CIVILIZATION_PDHDENMARK', 'KIND_CIVILIZATION'),
('LEADER_PDHMARGARET', 'KIND_LEADER'),
('TRAIT_CIVILIZATION_PDHDENMARK', 'KIND_TRAIT'),
('TRAIT_LEADER_PDHMARGARET', 'KIND_TRAIT'),
('BUILDING_PDH_RENTEKAMMER', 'KIND_BUILDING'),
('UNIT_PDH_AXEMEN', 'KIND_UNIT'),
('TRAIT_CIVILIZATION_BUILDING_PDH_RENTEKAMMER', 'KIND_TRAIT'),
('TRAIT_CIVILIZATION_UNIT_PDH_AXEMEN', 'KIND_TRAIT'),
('MODIFIER_PLAYER_ADJUST_CAPITAL_YIELD_MODIFIER_PER_TRIBUTARY', 'KIND_MODIFIER');
-- Civilization -----------------------------------------------
INSERT INTO Civilizations
(CivilizationType, Name, Description, Adjective, StartingCivilizationLevelType) --RandomCityNameDepth='10'
VALUES ('CIVILIZATION_PDHDENMARK', 'LOC_CIVILIZATION_PDHDENMARK_NAME', 'LOC_CIVILIZATION_PDHDENMARK_DESCRIPTION', 'LOC_CIVILIZATION_PDHDENMARK_ADJECTIVE', 'CIVILIZATION_LEVEL_FULL_CIV');
INSERT INTO CivilizationTraits
(CivilizationType, TraitType)
VALUES ('CIVILIZATION_PDHDENMARK', 'TRAIT_CIVILIZATION_PDHDENMARK'),
('CIVILIZATION_PDHDENMARK', 'TRAIT_CIVILIZATION_BUILDING_PDH_RENTEKAMMER'),
('CIVILIZATION_PDHDENMARK', 'TRAIT_CIVILIZATION_UNIT_PDH_AXEMEN');
INSERT INTO CityNames
(CivilizationType, CityName)
VALUES ('CIVILIZATION_PDHDENMARK', 'LOC_CITY_NAME_ROSKILDE'),
('CIVILIZATION_PDHDENMARK', 'LOC_CITY_NAME_AARHUS'),
('CIVILIZATION_PDHDENMARK', 'LOC_CITY_NAME_AALBORG'),
('CIVILIZATION_PDHDENMARK', 'LOC_CITY_NAME_ODENSE'),
('CIVILIZATION_PDHDENMARK', 'LOC_CITY_NAME_ESBJERG'),
('CIVILIZATION_PDHDENMARK', 'LOC_CITY_NAME_VEJLE'),
('CIVILIZATION_PDHDENMARK', 'LOC_CITY_NAME_KOLDING'),
('CIVILIZATION_PDHDENMARK', 'LOC_CITY_NAME_RANDERS'),
('CIVILIZATION_PDHDENMARK', 'LOC_CITY_NAME_HERNING'),
('CIVILIZATION_PDHDENMARK', 'LOC_CITY_NAME_COPENHAGEN');
-- Leaders ----------------------------------------------------
INSERT INTO Leaders
(LeaderType, Name, InheritFrom)
VALUES ('LEADER_PDHMARGARET', 'LOC_LEADER_PDHMARGARET_NAME', 'LEADER_DEFAULT');
INSERT INTO CivilizationLeaders
(CivilizationType, LeaderType, CapitalName)
VALUES ('CIVILIZATION_PDHDENMARK', 'LEADER_PDHMARGARET', 'LOC_CITY_NAME_ROSKILDE');
INSERT INTO Colors
(Type, Color)
VALUES ('COLOR_PLAYER_PDH_DANNEBROG', '200, 16, 46, 255');
INSERT INTO PlayerColors
(Type, Usage, PrimaryColor, SecondaryColor, TextColor)
VALUES ('LEADER_PDHMARGARET', 'Unique', 'COLOR_PLAYER_PDH_DANNEBROG', 'COLOR_PLAYER_WHITE', 'COLOR_PLAYER_WHITE_TEXT');
INSERT INTO LeaderTraits
(LeaderType, TraitType)
VALUES ('LEADER_PDHMARGARET', 'TRAIT_LEADER_PDHMARGARET');
-- Buildings --------------------------------------------------
INSERT INTO Buildings
(BuildingType, Name, PrereqTech, PrereqDistrict, PurchaseYield, Cost, AdvisorType, CitizenSlots)
VALUES ('BUILDING_PDH_RENTEKAMMER', 'LOC_BUILDING_PDH_RENTEKAMMER_NAME', 'TECH_BANKING', 'DISTRICT_COMMERCIAL_HUB', 'YIELD_GOLD', '210', 'ADVISOR_GENERIC', '1');
-- Rentekammer, Bank replacement at Banking, 25% cheaper to build (210/290)
INSERT INTO BuildingReplaces
(CivUniqueBuildingType, ReplacesBuildingType)
VALUES ('BUILDING_PDH_RENTEKAMMER', 'BUILDING_BANK');
INSERT INTO BuildingPrereqs
(Building, PrereqBuilding)
VALUES ('BUILDING_PDH_RENTEKAMMER', 'BUILDING_MARKET');
INSERT INTO Building_YieldChanges
(BuildingType, YieldType, YieldChange)
VALUES ('BUILDING_PDH_RENTEKAMMER', 'YIELD_GOLD', '5');
INSERT INTO Building_GreatPersonPoints
(BuildingType, GreatPersonClassType, PointsPerTurn)
VALUES ('BUILDING_PDH_RENTEKAMMER', 'GREAT_PERSON_CLASS_MERCHANT', '1');
-- Units ------------------------------------------------------
INSERT INTO Units
(UnitType, BaseMoves, Cost, AdvisorType, BaseSightRange, ZoneOfControl, Domain, FormationClass, Name, Description, PurchaseYield, PrereqTech, PromotionClass, Maintenance, Combat, TraitType, MandatoryObsoleteTech)
VALUES ('UNIT_PDH_AXEMEN', '2', '90', 'ADVISOR_CONQUEST', '2', 1, 'DOMAIN_LAND', 'FORMATION_CLASS_LAND_COMBAT', 'LOC_UNIT_PDH_AXEMEN_NAME', 'LOC_UNIT_PDH_AXEMEN_DESCRIPTION', 'YIELD_GOLD', 'TECH_IRON_WORKING', 'PROMOTION_CLASS_MELEE', '2', '40', 'TRAIT_CIVILIZATION_UNIT_PDH_AXEMEN', 'TECH_REPLACEABLE_PARTS');
INSERT INTO UnitReplaces
(CivUniqueUnitType, ReplacesUnitType)
VALUES ('UNIT_PDH_AXEMEN', 'UNIT_SWORDSMAN');
INSERT INTO UnitUpgrades
(Unit, UpgradeUnit)
VALUES ('UNIT_PDH_AXEMEN', 'UNIT_MUSKETMAN');
-- Traits -----------------------------------------------------
INSERT INTO Traits
(TraitType, Name, Description)
VALUES ('TRAIT_CIVILIZATION_PDHDENMARK', 'LOC_TRAIT_CIVILIZATION_PDHDENMARK_NAME', 'LOC_TRAIT_CIVILIZATION_PDHDENMARK_DESCRIPTION'),
('TRAIT_LEADER_PDHMARGARET', 'LOC_TRAIT_LEADER_PDHMARGARET_NAME', 'LOC_TRAIT_LEADER_PDHMARGARET_DESCRIPTION'),
('TRAIT_CIVILIZATION_BUILDING_PDH_RENTEKAMMER', 'LOC_BUILDING_PDH_RENTEKAMMER_NAME', 'LOC_BUILDING_PDH_RENTEKAMMER_DESCRIPTION'),
('TRAIT_CIVILIZATION_UNIT_PDH_AXEMEN', 'LOC_UNIT_PDH_AXEMEN_NAME', 'LOC_UNIT_PDH_AXEMEN_DESCRIPTION');
INSERT INTO TraitModifiers
(TraitType, ModifierID)
VALUES ('TRAIT_LEADER_PDHMARGARET', 'TRAIT_MODIFIER_PDH_DIPLOMATIC_SLOT_ON_POLITICAL_PHILOSOPHY'),
('TRAIT_LEADER_PDHMARGARET', 'TRAIT_MODIFIER_PDH_CULTURE_BOMB_COMMERCIAL_HUB'),
('TRAIT_LEADER_PDHMARGARET', 'TRAIT_MODIFIER_PDH_CULTURE_BOMB_HARBOR'),
('TRAIT_LEADER_PDHMARGARET', 'TRAIT_MODIFIER_CAPITAL_FOOD_PER_VASSAL'),
('TRAIT_LEADER_PDHMARGARET', 'TRAIT_MODIFIER_CAPITAL_PRODUCTION_PER_VASSAL'),
('TRAIT_LEADER_PDHMARGARET', 'TRAIT_MODIFIER_CAPITAL_SCIENCE_PER_VASSAL'),
('TRAIT_LEADER_PDHMARGARET', 'TRAIT_MODIFIER_CAPITAL_CULTURE_PER_VASSAL'),
('TRAIT_LEADER_PDHMARGARET', 'TRAIT_MODIFIER_CAPITAL_GOLD_PER_VASSAL')
('TRAIT_LEADER_PDHMARGARET', 'TRAIT_MODIFIER_CAPITAL_FAITH_PER_VASSAL');
-- Modifiers --------------------------------------------------
INSERT INTO DynamicModifiers
(ModifierType, CollectionType, EffectType)
VALUES ('MODIFIER_PLAYER_ADJUST_CAPITAL_YIELD_MODIFIER_PER_TRIBUTARY', 'COLLECTION_PLAYER_CAPITAL_CITY', 'EFFECT_ADJUST_PLAYER_YIELD_MODIFIER_PER_TRIBUTARY');
INSERT INTO Modifiers
(ModifierId, ModifierType, SubjectRequirementSetId)
VALUES ('TRAIT_MODIFIER_PDH_DIPLOMATIC_SLOT_ON_POLITICAL_PHILOSOPHY', 'MODIFIER_PLAYER_CULTURE_ADJUST_GOVERNMENT_SLOTS_MODIFIER', 'REQUIREMENTS_PDH_PLAYER_HAS_POLITICAL_PHILOSOPHY'),
('TRAIT_MODIFIER_PDH_CULTURE_BOMB_COMMERCIAL_HUB', 'MODIFIER_PLAYER_ADD_CULTURE_BOMB_TRIGGER', NULL),
('TRAIT_MODIFIER_PDH_CULTURE_BOMB_HARBOR', 'MODIFIER_PLAYER_ADD_CULTURE_BOMB_TRIGGER', NULL),
-- +% per Vassal
('TRAIT_MODIFIER_CAPITAL_FOOD_PER_VASSAL', 'MODIFIER_PLAYER_ADJUST_CAPITAL_YIELD_MODIFIER_PER_TRIBUTARY', NULL),
('TRAIT_MODIFIER_CAPITAL_PRODUCTION_PER_VASSAL', 'MODIFIER_PLAYER_ADJUST_CAPITAL_YIELD_MODIFIER_PER_TRIBUTARY', NULL),
('TRAIT_MODIFIER_CAPITAL_SCIENCE_PER_VASSAL', 'MODIFIER_PLAYER_ADJUST_CAPITAL_YIELD_MODIFIER_PER_TRIBUTARY', NULL),
('TRAIT_MODIFIER_CAPITAL_CULTURE_PER_VASSAL', 'MODIFIER_PLAYER_ADJUST_CAPITAL_YIELD_MODIFIER_PER_TRIBUTARY', NULL),
('TRAIT_MODIFIER_CAPITAL_GOLD_PER_VASSAL', 'MODIFIER_PLAYER_ADJUST_CAPITAL_YIELD_MODIFIER_PER_TRIBUTARY', NULL),
('TRAIT_MODIFIER_CAPITAL_FAITH_PER_VASSAL', 'MODIFIER_PLAYER_ADJUST_CAPITAL_YIELD_MODIFIER_PER_TRIBUTARY', NULL);
INSERT INTO ModifierArguments
(ModifierId, Name, Value)
VALUES ('TRAIT_MODIFIER_PDH_DIPLOMATIC_SLOT_ON_POLITICAL_PHILOSOPHY', 'GovernmentSlotType', 'SLOT_DIPLOMATIC'),
('TRAIT_MODIFIER_PDH_CULTURE_BOMB_COMMERCIAL_HUB', 'DistrictType', 'DISTRICT_COMMERCIAL_HUB'),
('TRAIT_MODIFIER_PDH_CULTURE_BOMB_HARBOR', 'DistrictType', 'DISTRICT_HARBOR'),
-- +% per Vassal, Yield Type
('TRAIT_MODIFIER_CAPITAL_FOOD_PER_VASSAL', 'YieldType', 'YIELD_FOOD'),
('TRAIT_MODIFIER_CAPITAL_PRODUCTION_PER_VASSAL', 'YieldType', 'YIELD_PRODUCTION'),
('TRAIT_MODIFIER_CAPITAL_SCIENCE_PER_VASSAL', 'YieldType', 'YIELD_SCIENCE'),
('TRAIT_MODIFIER_CAPITAL_CULTURE_PER_VASSAL', 'YieldType', 'YIELD_CULTURE'),
('TRAIT_MODIFIER_CAPITAL_GOLD_PER_VASSAL', 'YieldType', 'YIELD_GOLD'),
('TRAIT_MODIFIER_CAPITAL_FAITH_PER_VASSAL', 'YieldType', 'YIELD_FAITH'),
-- +% per Vassal, Amount
('TRAIT_MODIFIER_CAPITAL_FOOD_PER_VASSAL', 'Amount', '3'),
('TRAIT_MODIFIER_CAPITAL_PRODUCTION_PER_VASSAL', 'Amount', '3'),
('TRAIT_MODIFIER_CAPITAL_SCIENCE_PER_VASSAL', 'Amount', '3'),
('TRAIT_MODIFIER_CAPITAL_CULTURE_PER_VASSAL', 'Amount', '3'),
('TRAIT_MODIFIER_CAPITAL_GOLD_PER_VASSAL', 'Amount', '3'),
('TRAIT_MODIFIER_CAPITAL_FAITH_PER_VASSAL', 'Amount', '3');
-- Requeriments -----------------------------------------------
INSERT INTO RequirementSets
(RequirementSetId, RequirementSetType)
VALUES ('REQUIREMENTS_PDH_PLAYER_HAS_POLITICAL_PHILOSOPHY', 'REQUIREMENTSET_TEST_ALL');
INSERT INTO Requirements
(RequirementId, RequirementType)
VALUES ('REQUIRES_PDH_PLAYER_HAS_POLITICAL_PHILOSOPHY', 'REQUIREMENT_PLAYER_HAS_CIVIC');
INSERT INTO RequirementSetRequirements
(RequirementSetId, RequirementId)
VALUES ('REQUIREMENTS_PDH_PLAYER_HAS_POLITICAL_PHILOSOPHY', 'REQUIRES_PDH_PLAYER_HAS_POLITICAL_PHILOSOPHY');
INSERT INTO RequirementArguments
(RequirementId, Name, Value)
VALUES ('REQUIRES_PDH_PLAYER_HAS_POLITICAL_PHILOSOPHY', 'CivicType', 'CIVIC_POLITICAL_PHILOSOPHY');
Database.log:
Code:
[3437679.476] [Localization]: Validating Foreign Key Constraints...
[3437679.477] [Localization]: Passed Validation.
[3437679.489] [Configuration]: Validating Foreign Key Constraints...
[3437679.490] [Configuration]: Passed Validation.
[3437686.973] [FullTextSearch]: Initializing FullTextSearch
[3437687.579] [Gameplay]: Validating Foreign Key Constraints...
[3437687.598] [Gameplay]: Passed Validation.
[3437689.476] [Configuration]: Validating Foreign Key Constraints...
[3437689.476] [Configuration]: Passed Validation.
[3437689.602] [Database] ERROR: near "Index": syntax error
[3437722.151] [FullTextSearch]: FTS - Creating Context
[3437726.789] [Gameplay]: Validating Foreign Key Constraints...
[3437726.809] [Gameplay]: Passed Validation.
[3437731.957] [FullTextSearch]: FTS - Creating Context
[3437732.763] [FullTextSearch]: FTS - Creating Context
[3437734.741] [FullTextSearch]: FTS - Creating Context
[3437839.777] [FullTextSearch]: FTS - Creating Context
[3437839.977] [Configuration]: Validating Foreign Key Constraints...
[3437839.977] [Configuration]: Passed Validation.
[3437840.081] [Database] ERROR: near "Index": syntax error
[3438262.320] [Gameplay] ERROR: near "(": syntax error
[3438262.357] [Gameplay]: Validating Foreign Key Constraints...
[3438262.376] [Gameplay]: Passed Validation.
[3438266.767] [FullTextSearch]: FTS - Creating Context
[3438267.180] [FullTextSearch]: FTS - Creating Context
[3438268.026] [FullTextSearch]: FTS - Creating Context
[3438824.866] [FullTextSearch]: FTS - Creating Context
[3438825.098] [Configuration]: Validating Foreign Key Constraints...
[3438825.098] [Configuration]: Passed Validation.
[3438825.205] [Database] ERROR: near "Index": syntax error
[3440360.468] [Gameplay] ERROR: near "(": syntax error
[3440360.506] [Gameplay]: Validating Foreign Key Constraints...
[3440360.525] [Gameplay]: Passed Validation.
[3440364.674] [FullTextSearch]: FTS - Creating Context
[3440365.272] [FullTextSearch]: FTS - Creating Context
[3440366.337] [FullTextSearch]: FTS - Creating Context
[3441012.477] [FullTextSearch]: FTS - Creating Context
[3441012.655] [Configuration]: Validating Foreign Key Constraints...
[3441012.656] [Configuration]: Passed Validation.
[3441012.755] [Database] ERROR: near "Index": syntax error
[3441525.365] [Gameplay] ERROR: near "(": syntax error
[3441525.403] [Gameplay]: Validating Foreign Key Constraints...
[3441525.422] [Gameplay]: Passed Validation.
[3441529.607] [FullTextSearch]: FTS - Creating Context
[3441530.203] [FullTextSearch]: FTS - Creating Context
[3441531.266] [FullTextSearch]: FTS - Creating Context
[3442004.351] [FullTextSearch]: FTS - Creating Context
[3442004.568] [Configuration]: Validating Foreign Key Constraints...
[3442004.568] [Configuration]: Passed Validation.
[3442004.698] [Database] ERROR: near "Index": syntax error
[3442095.277] [FullTextSearch]: FTS - Creating Context
[3443008.798] [Gameplay] ERROR: near "(": syntax error
[3443008.843] [Gameplay]: Validating Foreign Key Constraints...
[3443008.871] [Gameplay]: Passed Validation.
[3443013.221] [FullTextSearch]: FTS - Creating Context
[3443013.815] [FullTextSearch]: FTS - Creating Context
[3443014.967] [FullTextSearch]: FTS - Creating Context
[3443557.080] [FullTextSearch]: FullTextSearch - Shutting down