[Vanilla] Building.TraitType Doesn't exist in Traits?

[Kind_Of_A_Rarit]

I'm pretty new to Civ 6 modding in general, so I'm sure this is something really simple that I'm just glossing over, but I'll ask here, because I can't figure it out. I'm trying to make a new civ, and the game crashes when I try to start a new game as my civ. I've checked the database log and can see what I think to be the cause is that my building type doesn't exist in traits.

Spoiler Database :

[3369373.620] [Localization]: StartupErrorMessages.xml
[3369373.620] [Localization]: Input XML does not contain database entry tags. GameData, GameInfo or Database
[3369384.112] [Localization]: Validating Foreign Key Constraints...
[3369384.113] [Localization]: Passed Validation.
[3369384.126] [Configuration]: Validating Foreign Key Constraints...
[3369384.127] [Configuration]: Passed Validation.
[3369391.810] [FullTextSearch]: Initializing FullTextSearch
[3369392.868] [Gameplay]: Validating Foreign Key Constraints...
[3369392.889] [Gameplay]: Passed Validation.
[3369394.289] [Configuration] ERROR: no such table: Types
[3369394.289] [Configuration]: In Query - insert into Types('Type', 'Kind') values (?, ?);
[3369394.289] [Configuration]: In XMLSerializer while updating table Types from file Joshs_Template_Buildings.xml.
[3369394.300] [Configuration]: Validating Foreign Key Constraints...
[3369394.301] [Configuration]: Passed Validation.
[3369427.430] [FullTextSearch]: FTS - Creating Context
[3369461.997] [Gameplay] ERROR: table PlayerColors has no column named SDIPLOndaryColor
[3369462.056] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3369462.056] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3369462.056] [Gameplay]: Validating Foreign Key Constraints...
[3369462.059] [Gameplay] ERROR: Invalid Reference on Buildings.TraitType - "TRAIT_CIVILIZATION_BUILDING_SWEET_SHOP" does not exist in Traits
[3369462.075] [Gameplay]: Failed Validation.
[3369465.217] [Configuration] ERROR: no such table: Types
[3369465.217] [Configuration]: In Query - insert into Types('Type', 'Kind') values (?, ?);
[3369465.217] [Configuration]: In XMLSerializer while updating table Types from file Joshs_Template_Buildings.xml.
[3369465.346] [Configuration]: Validating Foreign Key Constraints...
[3369465.347] [Configuration]: Passed Validation.
[3369466.296] [FullTextSearch]: FTS - Creating Context
[3369473.507] [FullTextSearch]: FullTextSearch - Shutting down

I know I've got some other issues in there, but I think the main one I'm concerned with is anything that causes the game to crash. Of course, if anybody could help me with the other ones, that'd be great.

Here's my building file too.

Spoiler Building :

<GameInfo>
<Types>
<Row Type="BUILDING_SWEET_SHOP" Kind="KIND_BUILDING"/>
</Types>

<Buildings>
<Row BuildingType="BUILDING_SWEET_SHOP" Name="LOC_BUILDING_SWEET_SHOP_NAME" Description="LOC_BUILDING_SWEET_SHOP_DESCRIPTION" PrereqDistrict="DISTRICT_CITY_CENTER" PurchaseYield="YIELD_GOLD" Cost="80" AdvisorType="ADVISOR_GENERAL" Maintenance="0" TraitType="TRAIT_CIVILIZATION_BUILDING_SWEET_SHOP"/>
</Buildings>

<Building_YieldChanges>
<Row BuildingType="BUILDING_SWEET_SHOP" YieldType="YIELD_FOOD" YieldChange="2"/>
</Building_YieldChanges>

<Building_YieldChanges>
<Row BuildingType="BUILDING_SWEET_SHOP" YieldType="YIELD_CULTURE" YieldChange="2"/>
</Building_YieldChanges>

<Building_GreatPersonPoints>
<Row BuildingType="BUILDING_SWEET_SHOP" GreatPersonClassType="GREAT_PERSON_CLASS_MERCHANT" PointsPerTurn="1"/>
</Building_GreatPersonPoints>
</GameInfo>

And, lastly, my GameDefines.

Spoiler GameDefines :

--==========================================================================================================================
-- LEADERS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('LEADER_KIND_CELESTIA', 'KIND_LEADER');
--------------------------------------------------------------------------------------------------------------------------
-- Leaders
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Leaders
(LeaderType, Name, InheritFrom, SceneLayers)
VALUES ('LEADER_KIND_CELESTIA', 'LOC_LEADER_KIND_CELESTIA_NAME', 'LEADER_DEFAULT', 4);
--------------------------------------------------------------------------------------------------------------------------
-- LeaderQuotes
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO LeaderQuotes
(LeaderType, Quote)
VALUES ('LEADER_KIND_CELESTIA', 'LOC_PEDIA_LEADERS_PAGE_LEADER_KIND_CELESTIA_QUOTE');
--------------------------------------------------------------------------------------------------------------------------
-- HistoricalAgendas
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO HistoricalAgendas
(LeaderType, AgendaType)
VALUES ('LEADER_KIND_CELESTIA', 'AGENDA_ALLY_OF_ENKIDU');
--------------------------------------------------------------------------------------------------------------------------
-- AgendaPreferredLeaders
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO AgendaPreferredLeaders
(LeaderType, AgendaType)
VALUES ('LEADER_KIND_CELESTIA', 'AGENDA_CIVILIZED');


--==========================================================================================================================
-- LEADERS: COLOURS
--==========================================================================================================================
-- PlayerColors
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO PlayerColors
(Type, Usage, PrimaryColor, SDIPLOndaryColor, TextColor)
VALUES ('LEADER_KIND_CELESTIA', 'Unique', 'COLOR_PLAYER_KIND_THE_SOLAR_EMPIRE_CELESTIA_PRIMARY', 'COLOR_PLAYER_KIND_THE_SOLAR_EMPIRE_CELESTIA_SDIPLONDARY', 'COLOR_PLAYER_WHITE_TEXT');

INSERT INTO Colors
(Type, Red, Green, Blue, Alpha)
VALUES ('COLOR_PLAYER_KIND_THE_SOLAR_EMPIRE_CELESTIA_PRIMARY', 1.00, 0.46, 0.94, 1),
('COLOR_PLAYER_KIND_THE_SOLAR_EMPIRE_CELESTIA_SDIPLONDARY', 1.00, 0.99, 0.51, 1);



--==========================================================================================================================
-- LEADERS: LOADING INFO
--==========================================================================================================================
-- LoadingInfo
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO LoadingInfo
(LeaderType, BackgroundImage, ForegroundImage, PlayDawnOfManAudio)
VALUES ('LEADER_KIND_CELESTIA', 'LEADER_CELESTIA_BACKGROUND', 'LEADER_CELESTIA_NEUTRAL', 0);
--==========================================================================================================================
-- CIVILIZATIONS
--==========================================================================================================================
-- Types
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'KIND_CIVILIZATION');
----------------------------------------------------------------------------------------------------------------------------
-- Civilizations
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO Civilizations
(CivilizationType, Name, Description, Adjective, StartingCivilizationLevelType, RandomCityNameDepth, Ethnicity)
VALUES ('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CIVILIZATION_KIND_THE_SOLAR_EMPIRE_NAME', 'LOC_CIVILIZATION_KIND_THE_SOLAR_EMPIRE_DESCRIPTION', 'LOC_CIVILIZATION_KIND_THE_SOLAR_EMPIRE_ADJECTIVE', 'CIVILIZATION_LEVEL_FULL_CIV', 30, 'ETHNICITY_EURO');
----------------------------------------------------------------------------------------------------------------------------
-- CityNames
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CityNames
(CivilizationType, CityName)
VALUES ('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_2'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_3'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_4'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_5'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_6'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_7'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_8'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_9'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_10'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_11'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_12'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_13'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_14'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_15'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_16'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_17'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_18'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_19'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_20'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_21'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_22'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_23'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_24'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_25'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_26'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_27'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_28'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_29'),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_30');
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationCitizenNames
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CivilizationCitizenNames
(CivilizationType, CitizenName, Female, Modern)
VALUES ('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MALE_1', 0, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MALE_2', 0, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MALE_3', 0, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MALE_4', 0, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MALE_5', 0, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MALE_6', 0, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MALE_7', 0, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MALE_8', 0, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MALE_9', 0, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MALE_10', 0, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_FEMALE_1', 1, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_FEMALE_2', 1, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_FEMALE_3', 1, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_FEMALE_4', 1, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_FEMALE_5', 1, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_FEMALE_6', 1, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_FEMALE_7', 1, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_FEMALE_8', 1, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_FEMALE_9', 1, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_FEMALE_10', 1, 0),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_MALE_1', 0, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_MALE_2', 0, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_MALE_3', 0, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_MALE_4', 0, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_MALE_5', 0, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_MALE_6', 0, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_MALE_7', 0, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_MALE_8', 0, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_MALE_9', 0, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_MALE_10', 0, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_FEMALE_1', 1, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_FEMALE_2', 1, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_FEMALE_3', 1, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_FEMALE_4', 1, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_FEMALE_5', 1, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_FEMALE_6', 1, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_FEMALE_7', 1, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_FEMALE_8', 1, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_FEMALE_9', 1, 1),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CITIZEN_KIND_THE_SOLAR_EMPIRE_MODERN_FEMALE_10', 1, 1);
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationInfo
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CivilizationInfo
(CivilizationType, Header, Caption, SortIndex)
VALUES ('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CIVINFO_LOCATION', 'LOC_CIVINFO_KIND_THE_SOLAR_EMPIRE_LOCATION', 10),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CIVINFO_SIZE', 'LOC_CIVINFO_KIND_THE_SOLAR_EMPIRE_SIZE', 20),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CIVINFO_POPULATION', 'LOC_CIVINFO_KIND_THE_SOLAR_EMPIRE_POPULATION', 30),
('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LOC_CIVINFO_CAPITAL', 'LOC_CIVINFO_KIND_THE_SOLAR_EMPIRE_CAPITAL', 40);
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationLeaders
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CivilizationLeaders
(CivilizationType, LeaderType, CapitalName)
VALUES ('CIVILIZATION_KIND_THE_SOLAR_EMPIRE', 'LEADER_KIND_CELESTIA', 'LOC_CITY_NAME_KIND_THE_SOLAR_EMPIRE_1');






--------------------------------------------------------------------------------------------------------------------------
-- BackGround Art
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO DiplomacyInfo
(Type, BackgroundImage)
VALUES ('LEADER_KIND_CELESTIA', 'ART_LEADER_CELESTIA.dds');



















--==========================================================================================================================
-- LEADERS: TRAITS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('TRAIT_LEADER_KIND_CELESTIA_DIPLO', 'KIND_TRAIT');
--------------------------------------------------------------------------------------------------------------------------
-- Traits
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Traits
(TraitType, Name, Description)
VALUES ('TRAIT_LEADER_KIND_CELESTIA_DIPLO', 'LOC_TRAIT_LEADER_KIND_CELESTIA_DIPLO_NAME', 'LOC_TRAIT_LEADER_KIND_CELESTIA_DIPLO_DESCRIPTION');
--------------------------------------------------------------------------------------------------------------------------
-- TraitModifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO TraitModifiers
(TraitType, ModifierId)
VALUES ('TRAIT_LEADER_KIND_CELESTIA_DIPLO', 'KIND_CELESTIA_DIPLO_EXTRA_SLOT_1');
--------------------------------------------------------------------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Modifiers
(ModifierId, ModifierType)
VALUES ('KIND_CELESTIA_DIPLO_EXTRA_SLOT_1', 'MODIFIER_PLAYER_CULTURE_ADJUST_GOVERNMENT_SLOTS_MODIFIER');
--------------------------------------------------------------------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierArguments
(ModifierId, Name, Value)
VALUES ('KIND_CELESTIA_DIPLO_EXTRA_SLOT_1', 'GovernmentSlotType', 'SLOT_DIPLOMATIC');













--==========================================================================================================================
-- CIVILIZATIONS: TRAITS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('TRAIT_CIVILIZATION_KIND_EXTRA_AMENITIES', 'KIND_TRAIT'),
('TRAIT_CIVILIZATION_BUILDING_SWEET_SHOP', 'KIND_TRAIT');
--------------------------------------------------------------------------------------------------------------------------
-- Traits
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Traits
(TraitType, Name, Description)
VALUES ('TRAIT_CIVILIZATION_KIND_EXTRA_AMENITIES', 'LOC_TRAIT_CIVILIZATION_KIND_EXTRA_AMENITIES_NAME', 'LOC_TRAIT_CIVILIZATION_KIND_EXTRA_AMENITIES_DESCRIPTION'),
('TRAIT_CIVILIZATION_BUILDING_SWEET_SHOP', 'LOC_TRAIT_CIVILIZATION_BUILDING_SWEET_SHOP_NAME', 'LOC_TRAIT_CIVILIZATION_BUILDING_SWEET_SHOP_DESCRIPTION');
--------------------------------------------------------------------------------------------------------------------------
-- TraitModifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO TraitModifiers
(TraitType, ModifierId)
VALUES ('TRAIT_CIVILIZATION_KIND_EXTRA_AMENITIES', 'KIND_TRAIT_LUX_AMENITIES'),
('TRAIT_CIVILIZATION_KIND_EXTRA_AMENITIES', 'KIND_TRAIT_BONUS_AMENITIES'),
--------------------------------------------------------------------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Modifiers
(ModifierId, ModifierType)
VALUES ('KIND_TRAIT_LUX_AMENITIES', 'MODIFIER_PLAYER_OWNED_LUXURY_EXTRA_AMENITIES'),
('KIND_TRAIT_BONUS_AMENITIES', 'MODIFIER_PLAYER_OWNED_BONUS_RESOURCE_EXTRA_AMENITIES'),
--------------------------------------------------------------------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierArguments
(ModifierId, Name, Value)
VALUES ('KIND_TRAIT_LUX_AMENITIES', 'Amount', '1'),
('KIND_TRAIT_BONUS_AMENITIES', 'Amount', '1'),

















--------------------------------------------------------------------------------------------------------------------------
-- LeaderTraits
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO LeaderTraits
(LeaderType, TraitType)
VALUES ('LEADER_KIND_CELESTIA', 'TRAIT_LEADER_KIND_CELESTIA_DIPLO');



----------------------------------------------------------------------------------------------------------------------------
-- CivilizationTraits
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CivilizationTraits
(TraitType, CivilizationType)
VALUES ('TRAIT_CIVILIZATION_KIND_EXTRA_AMENITIES', 'CIVILIZATION_KIND_THE_SOLAR_EMPIRE'),
('TRAIT_CIVILIZATION_BUILDING_SWEET_SHOP', 'CIVILIZATION_KIND_THE_SOLAR_EMPIRE');

I used a template, and I thought I copied it perfectly, but I guess something went wrong somewhere. Anyway, any help at all would be greatly appreciated.

 

[LeeS]

Database.log says

[3369461.997] [Gameplay] ERROR: table PlayerColors has no column named SDIPLOndaryColor

Your Gamedefines.sql says

INSERT INTO PlayerColors 
 (Type, Usage, PrimaryColor, SDIPLOndaryColor, TextColor)

The game ceases to read anything from within your GameDefines.SQL at that line, so your trait is never entered into the game, which results in the Invalid Reference error and kick back to the main menu.

Your problem there is that you typo-goofed over the correct name of the column, which is as I recall SecondaryColor.

--------------------------------

You are also using a template mod that has incorrect file procedures for your XML/SQL files, which is causing about 1/2 (or more) of the clutter of messages in Database.log. This issue with incorrect file procedures is a known issue that the creator of the template has never bothered to fix, or else he/they are no longer even modding.

 

[Kind_Of_A_Rarit]

Thanks! That totally fixed my problem. No more crashes! I knew it was something simple that I just glossed over... I just did a replace all action to replace "ECO" in the template's default trait to "DIPLO," which also seemed to pick up the "eco" in "secondary" without me realizing.
But, about the template, would you happen to know of a more up-to-date one (possibly one that is compatible with Rise and Fall, as I plan on upgrading to that soon)? Or anything that would help in that regard? The template I am using is a bit old, but I couldn't find a more appropriate version. I would very much appreciate it!