Chad Darden
Chieftain
- Joined
- Dec 30, 2017
- Messages
- 8
Can someone please look at this and tell me what's wrong, cuz I'm at a loss. Am I crazy or is it right there in traits with no syntax error?
[2943265.934] [Gameplay] ERROR: near "INSERT": syntax error
[2943265.935] [Gameplay] ERROR: FOREIGN KEY constraint failed
[2943265.935] [Gameplay] ERROR: FOREIGN KEY constraint failed
[2943265.935] [Gameplay]: Validating Foreign Key Constraints...
[2943265.936] [Gameplay] ERROR: Invalid Reference on Buildings.TraitType - "TRAIT_CIVILIZATION_BUILDING_CLD_ALAMO" does not exist in Traits
[2943265.948] [Gameplay]: Failed Validation.
[2943265.934] [Gameplay] ERROR: near "INSERT": syntax error
[2943265.935] [Gameplay] ERROR: FOREIGN KEY constraint failed
[2943265.935] [Gameplay] ERROR: FOREIGN KEY constraint failed
[2943265.935] [Gameplay]: Validating Foreign Key Constraints...
[2943265.936] [Gameplay] ERROR: Invalid Reference on Buildings.TraitType - "TRAIT_CIVILIZATION_BUILDING_CLD_ALAMO" does not exist in Traits
[2943265.948] [Gameplay]: Failed Validation.
Code:
<Row BuildingType="BUILDING_CLD_ALAMO" Name="LOC_BUILDING_CLD_ALAMO_NAME" Description="LOC_BUILDING_CLD_ALAMO_DESCRIPTION" PrereqTech="TECH_MILITARY_ENGINEERING" PrereqDistrict="DISTRICT_ENCAMPMENT" PurchaseYield="YIELD_GOLD" Cost="195" AdvisorType="ADVISOR_CONQUEST" Maintenance="0" CitizenSlots="1" TraitType="TRAIT_CIVILIZATION_BUILDING_CLD_ALAMO"/>
Code:
INSERT INTO Types
(Type, Kind)
VALUES ('TRAIT_CIVILIZATION_CLD_DONT', 'KIND_TRAIT'),
('TRAIT_CIVILIZATION_BUILDING_CLD_ALAMO', 'KIND_TRAIT');
--------------------------------------------------------------------------------------------------------------------------
-- Traits
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Traits
(TraitType, Name, Description)
VALUES ('TRAIT_CIVILIZATION_CLD_DONT', 'LOC_TRAIT_CIVILIZATION_CLD_DONT_NAME', 'LOC_TRAIT_CIVILIZATION_CLD_DONT_DESCRIPTION'),
('TRAIT_CIVILIZATION_BUILDING_CLD_ALAMO', 'LOC_TRAIT_CIVILIZATION_BUILDING_CLD_ALAMO_NAME', 'LOC_TRAIT_CIVILIZATION_BUILDING_CLD_ALAMO_DESCRIPTION');