Need assistance with code - District

[Cagarustus]

I'm trying to create a new District for India based on the Seowon, except faith-based. I pretty much copied the code of the existing Seowon but made changes that reflected Faith.

I tried running the game but it goes back to 'Start Game'. When I opened the Database:

[2380791.995] [Localization]: StartupErrorMessages.xml
[2380791.995] [Localization]: Input XML does not contain database entry tags. GameData, GameInfo or Database
[2380794.909] [Localization]: Validating Foreign Key Constraints...
[2380794.909] [Localization]: Passed Validation.
[2380794.926] [Configuration]: Validating Foreign Key Constraints...
[2380794.927] [Configuration]: Passed Validation.
[2380801.239] [FullTextSearch]: Initializing FullTextSearch
[2380801.645] [Gameplay]: Validating Foreign Key Constraints...
[2380801.656] [Gameplay]: Passed Validation.
[2380802.484] [Configuration]: Validating Foreign Key Constraints...
[2380802.485] [Configuration]: Passed Validation.
[2380819.558] [FullTextSearch]: FTS - Creating Context
[2380826.090] [Configuration]: Validating Foreign Key Constraints...
[2380826.090] [Configuration]: Passed Validation.
[2380828.689] [Gameplay] ERROR: no such table: DistrictAdjacencies
[2380828.689] [Gameplay] ERROR: FOREIGN KEY constraint failed
[2380828.689] [Gameplay] ERROR: FOREIGN KEY constraint failed
[2380828.689] [Gameplay]: Validating Foreign Key Constraints...
[2380828.693] [Gameplay] ERROR: Invalid Reference on Districts.TraitType - "TRAIT_CIVILIZATION_CAG_IG_DISTRICT_ASHRAM" does not exist in Traits
[2380828.705] [Gameplay]: Failed Validation.
[2380828.707] [Gameplay] ERROR: no such table: PlayerItems
[2380829.095] [Gameplay]: Validating Foreign Key Constraints...
[2380829.113] [Gameplay]: Passed Validation.
[2380831.106] [Configuration]: Validating Foreign Key Constraints...
[2380831.106] [Configuration]: Passed Validation.
[2380831.534] [FullTextSearch]: FTS - Creating Context
[2380836.669] [FullTextSearch]: FullTextSearch - Shutting down

So, according to the Logs, I haven't put the Trait in 'Traits' but I have. Here is the code:

INSERT INTO Types (Kind, Type)
VALUES
('KIND_TRAIT', 'TRAIT_CIVILIZATION_CAG_IG_DISTRICT_ASHRAM');

INSERT INTO Traits (Name, TraitType)
VALUES
('LOC_TRAIT_CIVILIZATION_CAG_IG_DISTRICT_ASHRAM_NAME', 'TRAIT_CIVILIZATION_CAG_IG_DISTRICT_ASHRAM');

INSERT INTO CivilizationTraits (CivilizationType, TraitType)
VALUES
('CIVILIZATION_INDIA', 'TRAIT_CIVILIZATION_CAG_IG_DISTRICT_ASHRAM');

INSERT INTO AiListTypes (ListType)
VALUES
('IndiaFaithBiase');

INSERT INTO AiLists (LeaderType, ListType, System)
VALUES
('TRAIT_CIVILIZATION_CAG_IG_DISTRICT_ASHRAM', 'IndiaFaithBiase', 'Yields');

INSERT INTO AiFavoredItems (Value, ListType, Item)
VALUES
('50', 'IndiaFaithBiase', 'YIELD_FAITH');
-----------------------------
Then I created a separated file for the District:

INSERT INTO Types (Kind, Type) VALUES
('KIND_DISTRICT', 'CAG_IG_DISTRICT_ASHRAM');

INSERT INTO Districts (TraitType, CityStrengthModifier, MilitaryDomain, CaptureRemovesCityDefenses, CaptureRemovesBuildings, ZOC, InternalOnly, NoAdjacentCity, Aqueduct, RequiresPopulation, RequiresPlacement, Maintenance, CostProgressionParam1, CostProgressionModel, Cost, AdvisorType, PlunderType, PrereqTech, Description, Name, DistrictType, PlunderAmount)
VALUES
('TRAIT_CIVILIZATION_CAG_IG_DISTRICT_ASHRAM', '2', 'NO_DOMAIN', '0', '0', '0', '0', '0', '0', '1', '1', '1,', '40', 'COST_PROGRESSION_NUM_UNDER_AVG_PLUS_TECH', '27', 'ADVISOR_TECHNOLOGY', 'PLUNDER_FAITH', 'TECH_ASTROLOGY', 'LOC_CAG_IG_DISTRICT_ASHRAM_DESCRIPTION', 'LOC_CAG_IG_DISTRICT_ASHRAM_NAME', 'CAG_IG_DISTRICT_ASHRAM', '25');

INSERT INTO DistrictAdjacencies (DistrictType, YieldChangeId)
VALUES
('CAG_IG_DISTRICT_ASHRAM', 'BaseDistrict_Faith'),
('CAG_IG_DISTRICT_ASHRAM', 'NegativeDistrict_Faith'),
('CAG_IG_DISTRICT_ASHRAM', 'Government_Faith');

INSERT INTO District_GreatPersonPoints (DistrictType, PointsPerTurn)
VALUES
('CAG_IG_DISTRICT_ASHRAM', '1');

INSERT INTO District_CitizenYieldChanges (DistrictType, YieldType, YieldChange)
VALUES
('CAG_IG_DISTRICT_ASHRAM', 'YIELD_FAITH', '2');

INSERT INTO Adjacency_YieldChanges (Description, YieldType, YieldChange, Self, ID, OtherDistrictAdjacent, TilesRequired)
VALUES
('LOC_DISTRICT_BASE_DISTRICT_FAITH', 'YIELD_FAITH', '4', '1', 'BaseDistrict_Faith', NULL, NULL),
('LOC_DISTRICT_NEGATIVE_DISTRICT_FAITH', 'YIELD_FAITH', '-1', NULL, 'NegativeDistrict_Faith', '1', '1');

INSERT INTO District_TradeRouteYields (DistrictType, YieldChangeAsInternationalDestination, YieldChangeAsDomesticDestination, YieldChangeAsOrigin, YieldType)
VALUES
('CAG_IG_DISTRICT_ASHRAM', '1', '0', '0', 'YIELD_FAITH');

INSERT INTO DistrictReplaces (ReplacesDistrictType, CivUniqueDistrictType)
VALUES
('DISTRICT_HOLY_SITE', 'CAG_IG_DISTRICT_ASHRAM');
----------
As you can see, where I've highlighted it in red is where I've included the TraitType in Districts in 'Traits'.

I have no idea what's going on? Assistance please??

 

[Infixo]

There’s an earlier error
[2380828.689] [Gameplay] ERROR: no such table: DistrictAdjacencies

 

[Cagarustus]

Ah ok, thanks. I changed it, but and it's still not working. There appears to be an issue with replicating the BaseAdjacency and NegativeAdjacency for yields other than faith. It might be hard-coded only to work with science.

Thanks anyway.