Unknown Syntax Error (Solved, I'm stupid)

Toussaint10326

Toussaint10326

Chieftain
Joined
Jul 28, 2017
Messages
84
Location
United States
After looking up and down my GameDefines.sql (which is where I think the error is coming from) I can not find any errors. It is coming from Gameplay and the other files being loaded into there don't even have ";".

GameDefines.sql:

Code: 
--==========================================================================================================================
-- LEADERS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO Types   
        (Type,                            Kind)
VALUES    ('LEADER_SHSH_POCATELLO',    'KIND_LEADER');   
--------------------------------------------------------------------------------------------------------------------------
-- Leaders
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO Leaders   
        (LeaderType,                    Name,                                        InheritFrom,        SceneLayers)
VALUES    ('LEADER_SHSH_POCATELLO',    'LOC_LEADER_SHSH_POCATELLO',        'LEADER_DEFAULT',    4);   
--------------------------------------------------------------------------------------------------------------------------
-- LeaderQuotes
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO LeaderQuotes   
        (LeaderType,            Quote)
VALUES    ('LEADER_SHSH_POCATELLO',    'LOC_PEDIA_LEADERS_PAGE_LEADER_SHSH_POCATELLO_QUOTE');   
--------------------------------------------------------------------------------------------------------------------------
-- HistoricalAgendas
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO HistoricalAgendas   
        (LeaderType,                    AgendaType)
VALUES    ('LEADER_SHSH_POCATELLO',    'AGENDA_OPTIMUS_PRINCEPS');
--------------------------------------------------------------------------------------------------------------------------
-- AgendaPreferredLeaders
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO AgendaPreferredLeaders   
        (LeaderType,                    AgendaType)
VALUES    ('LEADER_SHSH_POCATELLO',    'AGENDA_NUKE_LOVER');   


--==========================================================================================================================
-- LEADERS: COLOURS
--==========================================================================================================================
-- PlayerColors
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO PlayerColors   
        (Type,                            Usage,            PrimaryColor,                                         SecondaryColor,                                            TextColor)
VALUES    ('LEADER_SHSH_POCATELLO',    'Unique',        'COLOR_PLAYER_SHSH_SHOSHONE_POCATELLO_PRIMARY',        'COLOR_PLAYER_SHSH_SHOSHONE_POCATELLO_SECONDARY',         'COLOR_PLAYER_WHITE_TEXT');   

INSERT INTO Colors
        (Type,                                                 Red,     Green,     Blue,     Alpha)
VALUES    ('COLOR_PLAYER_SHSH_SHOSHONE_POCATELLO_PRIMARY',    0.390,    0.820,    0.960,    1),
        ('COLOR_PLAYER_SHSH_SHOSHONE_POCATELLO_SECONDARY',     0.380,    0.200,    0.070,    1);



--==========================================================================================================================
-- LEADERS: LOADING INFO
--==========================================================================================================================
-- LoadingInfo
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO LoadingInfo   
        (LeaderType,                        BackgroundImage,                         ForegroundImage,                        PlayDawnOfManAudio)
VALUES    ('LEADER_SHSH_POCATELLO',        'LEADER_POCATELLO_BACKGROUND',        'LEADER_POCATELLO_NEUTRAL',            0);   
--==========================================================================================================================
-- CIVILIZATIONS
--==========================================================================================================================
-- Types
----------------------------------------------------------------------------------------------------------------------------   
INSERT INTO Types   
        (Type,                        Kind)
VALUES    ('CIVILIZATION_SHSH_SHOSHONE',    'KIND_CIVILIZATION');
----------------------------------------------------------------------------------------------------------------------------
-- Civilizations
----------------------------------------------------------------------------------------------------------------------------   
INSERT INTO Civilizations   
        (CivilizationType,                    Name,                                        Description,                                    Adjective,                                        StartingCivilizationLevelType,    RandomCityNameDepth,    Ethnicity)
VALUES    ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CIVILIZATION_SHSH_SHOSHONE_NAME',    'LOC_CIVILIZATION_SHSH_SHOSHONE_DESCRIPTION',    'LOC_CIVILIZATION_SHSH_SHOSHONE_ADJECTIVE',    'CIVILIZATION_LEVEL_FULL_CIV',    30,                        'ETHNICITY_AMERICAN');   
----------------------------------------------------------------------------------------------------------------------------           
-- CityNames           
----------------------------------------------------------------------------------------------------------------------------       
INSERT INTO CityNames   
        (CivilizationType,            CityName)   
VALUES    ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_2'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_3'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_4'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_5'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_6'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_7'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_8'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_9'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_10'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_11'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_12'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_13'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_14'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_15'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_16'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_17'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_18'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_19'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_20'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_21'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_22'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_23'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_24'),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITY_NAME_SHSH_SHOSHONE_25');       
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationCitizenNames
----------------------------------------------------------------------------------------------------------------------------   
INSERT INTO CivilizationCitizenNames   
        (CivilizationType,            CitizenName,                                Female,        Modern)
VALUES    ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITIZEN_SHSH_SHOSHONE_MALE_1',                0,            0),
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITIZEN_SHSH_SHOSHONE_MALE_2',                0,            0),
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITIZEN_SHSH_SHOSHONE_MALE_3',                0,            0),
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITIZEN_SHSH_SHOSHONE_MALE_4',                0,            0),
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITIZEN_SHSH_SHOSHONE_FEMALE_1',            1,            0),
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITIZEN_SHSH_SHOSHONE_FEMALE_2',            1,            0),
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITIZEN_SHSH_SHOSHONE_FEMALE_3',            1,            0),
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITIZEN_SHSH_SHOSHONE_FEMALE_4',            1,            0),
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CITIZEN_SHSH_SHOSHONE_FEMALE_5',            1,            0);
----------------------------------------------------------------------------------------------------------------------------           
-- CivilizationInfo           
----------------------------------------------------------------------------------------------------------------------------       
INSERT INTO CivilizationInfo   
        (CivilizationType,            Header,                        Caption,                                SortIndex)   
VALUES    ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CIVINFO_LOCATION',        'LOC_CIVINFO_SHSH_SHOSHONE_LOCATION',        10),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CIVINFO_SIZE',            'LOC_CIVINFO_SHSH_SHOSHONE_SIZE',            20),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CIVINFO_POPULATION',    'LOC_CIVINFO_SHSH_SHOSHONE_POPULATION',        30),   
        ('CIVILIZATION_SHSH_SHOSHONE',    'LOC_CIVINFO_CAPITAL',         'LOC_CIVINFO_SHSH_SHOSHONE_CAPITAL',            40);
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationLeaders
----------------------------------------------------------------------------------------------------------------------------   
INSERT INTO CivilizationLeaders   
        (CivilizationType,                        LeaderType,            CapitalName)
VALUES    ('CIVILIZATION_SHSH_SHOSHONE',    'LEADER_SHSH_POCATELLO',        'LOC_CITY_NAME_SHSH_SHOSHONE_1');






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



















--==========================================================================================================================
-- LEADERS: TRAITS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO Types   
        (Type,                                                        Kind)
VALUES    ('TRAIT_LEADER_SHSH_POCATELLO_TONDZAOSHA',                        'KIND_TRAIT');   
--------------------------------------------------------------------------------------------------------------------------           
-- Traits           
--------------------------------------------------------------------------------------------------------------------------               
INSERT INTO Traits               
        (TraitType,                                                    Name,                                                    Description)
VALUES    ('TRAIT_LEADER_SHSH_POCATELLO_TONDZAOSHA',                        'LOC_TRAIT_LEADER_SHSH_POCATELLO_TONDZAOSHA_NAME',            'LOC_TRAIT_LEADER_SHSH_POCATELLO_TONDZAOSHA_DESCRIPTION');   
--------------------------------------------------------------------------------------------------------------------------       
-- TraitModifiers       
--------------------------------------------------------------------------------------------------------------------------           
INSERT INTO TraitModifiers           
        (TraitType,                                                    ModifierId)
VALUES    ('TRAIT_LEADER_SHSH_POCATELLO_TONDZAOSHA',                        'SHSH_POCATELLO_TONDZAOSHA_EXTRA_SLOT_1');
--------------------------------------------------------------------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Modifiers   
        (ModifierId,                                                ModifierType)
VALUES    ('SHSH_POCATELLO_TONDZAOSHA_EXTRA_SLOT_1',                    'MODIFIER_PLAYER_CULTURE_ADJUST_GOVERNMENT_SLOTS_MODIFIER';
--------------------------------------------------------------------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierArguments
        (ModifierId,                                                Name,                            Value)
VALUES    ('SHSH_POCATELLO_TONDZAOSHA_EXTRA_SLOT_1',                        'GovernmentSlotType',            'SLOT_MILITARY');












--==========================================================================================================================
-- CIVILIZATIONS: TRAITS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO Types   
        (Type,                                                    Kind)
VALUES    ('TRAIT_CIVILIZATION_SHSH_EXPANSE',                        'KIND_TRAIT'),
        ('TRAIT_CIVILIZATION_UNIT_SHSH_PATHFINDER',                'KIND_TRAIT'),
        ('TRAIT_CIVILIZATION_UNIT_SHSH_COM_RIDER',                'KIND_TRAIT');
--------------------------------------------------------------------------------------------------------------------------           
-- Traits           
--------------------------------------------------------------------------------------------------------------------------               
INSERT INTO Traits               
        (TraitType,                                                    Name,                                                    Description)
VALUES    ('TRAIT_CIVILIZATION_SHSH_EXPANSE',                        'LOC_TRAIT_CIVILIZATION_SHSH_EXPANSE_NAME',                    'LOC_TRAIT_CIVILIZATION_SHSH_EXPANSE_DESCRIPTION'),
        ('TRAIT_CIVILIZATION_UNIT_SHSH_PATHFINDER',                'LOC_UNIT_SHSH_PATHFINDER_NAME',                                'LOC_UNIT_SHSH_PATHFINDER_DESCRIPTION'),           
        ('TRAIT_CIVILIZATION_UNIT_SHSH_COM_RIDER',                'LOC_UNIT_SHSH_COM_RIDER_NAME',                                'LOC_UNIT_SHSH_COM_RIDER_DESCRIPTION');           
--------------------------------------------------------------------------------------------------------------------------       
-- TraitModifiers       
--------------------------------------------------------------------------------------------------------------------------           
INSERT INTO TraitModifiers           
        (TraitType,                                            ModifierId)
VALUES    ('TRAIT_CIVILIZATION_SHSH_EXPANSE',                    'SHSH_TRAIT_EXTRA_TILES');                                                                                   
--------------------------------------------------------------------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Modifiers   
        (ModifierId,                                                ModifierType)
VALUES    ('SHSH_TRAIT_EXTRA_TILES',                                    'MODIFIER_PLAYER_ADJUST_CITY_TILES');   
--------------------------------------------------------------------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierArguments
        (ModifierId,                                                Name,                        Value)
VALUES    ('SHSH_TRAIT_EXTRA_TILES',                                   'Amount',                    '9');
















--------------------------------------------------------------------------------------------------------------------------
-- LeaderTraits
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO LeaderTraits   
        (LeaderType,            TraitType)
VALUES    ('LEADER_SHSH_POCATELLO',    'TRAIT_LEADER_SHSH_POCATELLO_TONDZAOSHA');   



----------------------------------------------------------------------------------------------------------------------------
-- CivilizationTraits
----------------------------------------------------------------------------------------------------------------------------   
INSERT INTO CivilizationTraits   
        (TraitType,                                                            CivilizationType)
VALUES    ('TRAIT_CIVILIZATION_SHSH_EXPANSE',                                    'CIVILIZATION_SHSH_SHOSHONE'),
        ('TRAIT_CIVILIZATION_UNIT_SHSH_PATHFINDER',                            'CIVILIZATION_SHSH_SHOSHONE'),
        ('TRAIT_CIVILIZATION_UNIT_SHSH_COM_RIDER',                            'CIVILIZATION_SHSH_SHOSHONE');

Database.log:

Code: 
[188669.728] [Localization]: Validating Foreign Key Constraints...
[188669.729] [Localization]: Passed Validation.
[188669.743] [Configuration]: Validating Foreign Key Constraints...
[188669.744] [Configuration]: Passed Validation.
[188678.831] [FullTextSearch]: Initializing FullTextSearch
[188680.621] [Gameplay]: Validating Foreign Key Constraints...
[188680.642] [Gameplay]: Passed Validation.
[188682.574] [Configuration] ERROR: no such table: Types
[188682.574] [Configuration]: In Query - insert into Types('Type', 'Kind') values (?, ?);
[188682.574] [Configuration]: In XMLSerializer while updating table Types from file Pocatello_Units.xml.
[188682.582] [Configuration]: Validating Foreign Key Constraints...
[188682.624] [Configuration]: Passed Validation.
[188702.223] [FullTextSearch]: FTS - Creating Context
[188762.048] [Gameplay] ERROR: near ";": syntax error
[188762.050] [Gameplay] ERROR: FOREIGN KEY constraint failed
[188762.050] [Gameplay] ERROR: FOREIGN KEY constraint failed
[188762.050] [Gameplay]: Validating Foreign Key Constraints...
[188762.073] [Gameplay] ERROR: Invalid Reference on Units.TraitType - "TRAIT_CIVILIZATION_UNIT_SHSH_PATHFINDER" does not exist in Traits
[188762.073] [Gameplay] ERROR: Invalid Reference on Units.TraitType - "TRAIT_CIVILIZATION_UNIT_SHSH_COM_RIDER" does not exist in Traits
[188762.075] [Gameplay]: Failed Validation.
[188762.132] [Gameplay]: Validating Foreign Key Constraints...
[188762.159] [Gameplay]: Passed Validation.
[188765.610] [FullTextSearch]: FTS - Creating Context
[188765.839] [Configuration] ERROR: no such table: Types
[188765.839] [Configuration]: In Query - insert into Types('Type', 'Kind') values (?, ?);
[188765.839] [Configuration]: In XMLSerializer while updating table Types from file Pocatello_Units.xml.
[188765.846] [Configuration]: Validating Foreign Key Constraints...
[188765.846] [Configuration]: Passed Validation.
[188772.701] [FullTextSearch]: FullTextSearch - Shutting down

Anyone that can point out the error would be a lifesaver!
 
You must log in or register to reply here.

Similar threads

L
How enable to plant jungle ?
Replies
0
Views
386
Lochwein
L
U
MODIFIER_UNIT_ADJUST_COMBAT_CAPTURE
Replies
1
Views
294
UnfortunateSpaceman
U
A
[GS] Problems with custom civilization traits and features
Replies
1
Views
1K
alex1
A
F
Cant use YieldFromAppeal and YieldFromAppealPercent in a Leader Ability?
Replies
2
Views
950
FlyingThunder
F
M
[SOLVED] Unit Error Check
Replies
2
Views
1K
Mikecro
M
Top Bottom