[R&F] Can someone spot the error in my .sql file? (Solved)

[neonpinku]

I've been trying to create this mod (Austria tbe) for some while now and there were some obstacles over the days, but I've always found a solution. Now though I'm at a point where i simply can't find a solution and i wanted to ask if anyone could maybe help me here. At some point I couldn't start a game anymore after I did some changes, but for some reason I can't remember which changes they were. The database.log tells me:

> [1325993.908] [Gameplay] ERROR: near "INSERT": syntax error

and I don't know where that error could be.

--==========================================================================================================================
-- LEADERS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO Types   
        (Type,                            Kind)
VALUES    ('LEADER_NEON_KOERNER',    'KIND_LEADER');   
--------------------------------------------------------------------------------------------------------------------------
-- Leaders
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO Leaders   
        (LeaderType,                    Name,                                        InheritFrom,        SceneLayers)
VALUES    ('LEADER_NEON_KOERNER',    'LOC_LEADER_NEON_KOERNER',        'LEADER_DEFAULT',    4);   
--------------------------------------------------------------------------------------------------------------------------
-- LeaderQuotes
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO LeaderQuotes   
        (LeaderType,            Quote)
VALUES    ('LEADER_NEON_KOERNER',    'LOC_PEDIA_LEADERS_PAGE_LEADER_NEON_KOERNER_QUOTE');   
--------------------------------------------------------------------------------------------------------------------------
-- HistoricalAgendas
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO HistoricalAgendas   
        (LeaderType,                    AgendaType)
VALUES    ('LEADER_NEON_KOERNER',    'AGENDA_OPTIMUS_PRINCEPS');
--------------------------------------------------------------------------------------------------------------------------
-- AgendaPreferredLeaders
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO AgendaPreferredLeaders   
        (LeaderType,                    AgendaType)
VALUES    ('LEADER_NEON_KOERNER',    'AGENDA_NUKE_LOVER');   


--==========================================================================================================================
-- LEADERS: COLOURS
--==========================================================================================================================
-- PlayerColors
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO PlayerColors   
        (Type,                    Usage,            PrimaryColor,                                SecondaryColor,                                TextColor)
VALUES    ('LEADER_NEON_KOERNER',    'Unique',        'COLOR_PLAYER_NEON_KOERNER_PRIMARY',        'COLOR_PLAYER_NEON_KOERNER_SECONDARY',         'COLOR_PLAYER_WHITE_TEXT');   

INSERT INTO Colors
        (Type,                                                     Red,     Green,     Blue,     Alpha)
VALUES    ('COLOR_PLAYER_NEON_KOERNER_PRIMARY',                    0.988,    0.008,    0.016,    1),
        ('COLOR_PLAYER_NEON_KOERNER_SECONDARY',                    1,        1,        1,        1);

--==========================================================================================================================
-- LEADERS: LOADING INFO
--==========================================================================================================================
-- LoadingInfo
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO LoadingInfo   
        (LeaderType,                        BackgroundImage,                         ForegroundImage,                        PlayDawnOfManAudio)
VALUES    ('LEADER_NEON_KOERNER',        'LEADER_KOERNER_BACKGROUND',        'LEADER_KOERNER_NEUTRAL',            0);   
--==========================================================================================================================
-- CIVILIZATIONS
--==========================================================================================================================
-- Types
----------------------------------------------------------------------------------------------------------------------------   
INSERT INTO Types   
        (Type,                        Kind)
VALUES    ('CIVILIZATION_NEON_AUSTRIA',    'KIND_CIVILIZATION');
----------------------------------------------------------------------------------------------------------------------------
-- Civilizations
----------------------------------------------------------------------------------------------------------------------------   
INSERT INTO Civilizations   
        (CivilizationType,            Name,                                Description,                                Adjective,                                StartingCivilizationLevelType, RandomCityNameDepth, Ethnicity)
VALUES    ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CIVILIZATION_NEON_AUSTRIA_NAME',    'LOC_CIVILIZATION_NEON_AUSTRIA_DESCRIPTION',    'LOC_CIVILIZATION_NEON_AUSTRIA_ADJECTIVE', 'CIVILIZATION_LEVEL_FULL_CIV', 10,                     'ETHNICITY_EURO');   
----------------------------------------------------------------------------------------------------------------------------           
-- CityNames           
----------------------------------------------------------------------------------------------------------------------------       
INSERT INTO CityNames   
        (CivilizationType,            CityName)   
VALUES    ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_2'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_3'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_4'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_5'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_6'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_7'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_8'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_9'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_10'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_11'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_12'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_13'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_14'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_15'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_16'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_17'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_18'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_19'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_20'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_21'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_22'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_23'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_24'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_25'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_26'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_27'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_28'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_29'),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITY_NAME_NEON_AUSTRIA_30');   
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationCitizenNames
----------------------------------------------------------------------------------------------------------------------------   
INSERT INTO CivilizationCitizenNames   
        (CivilizationType,            CitizenName,                                Female,        Modern)
VALUES    ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MALE_1',                0,            0),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MALE_2',                0,            0),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MALE_3',                0,            0),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MALE_4',                0,            0),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MALE_5',                0,            0),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_FEMALE_1',            1,            0),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_FEMALE_2',            1,            0),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_FEMALE_3',            1,            0),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_FEMALE_4',            1,            0),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_FEMALE_5',            1,            0),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MODERN_MALE_1',        0,            1),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MODERN_MALE_2',        0,            1),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MODERN_MALE_3',        0,            1),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MODERN_MALE_4',        0,            1),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MODERN_MALE_5',        0,            1),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MODERN_FEMALE_1',        1,            1),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MODERN_FEMALE_2',        1,            1),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MODERN_FEMALE_3',        1,            1),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MODERN_FEMALE_4',        1,            1),
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CITIZEN_NEON_AUSTRIA_MODERN_FEMALE_5',        1,            1),
----------------------------------------------------------------------------------------------------------------------------           
-- CivilizationInfo           
----------------------------------------------------------------------------------------------------------------------------       
INSERT INTO CivilizationInfo   
        (CivilizationType,            Header,                        Caption,                                SortIndex)   
VALUES    ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CIVINFO_LOCATION',        'LOC_CIVINFO_NEON_AUSTRIA_LOCATION',        10),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CIVINFO_SIZE',            'LOC_CIVINFO_NEON_AUSTRIA_SIZE',            20),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CIVINFO_POPULATION',    'LOC_CIVINFO_NEON_AUSTRIA_POPULATION',        30),   
        ('CIVILIZATION_NEON_AUSTRIA',    'LOC_CIVINFO_CAPITAL',         'LOC_CIVINFO_NEON_AUSTRIA_CAPITAL',            40);
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationLeaders
----------------------------------------------------------------------------------------------------------------------------   
INSERT INTO CivilizationLeaders   
        (CivilizationType,                        LeaderType,            CapitalName)
VALUES    ('CIVILIZATION_NEON_AUSTRIA',    'LEADER_NEON_KOERNER',        'Vienna');






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



















--==========================================================================================================================
-- LEADERS: TRAITS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO Types   
        (Type,                                                        Kind)
VALUES    ('TRAIT_LEADER_NEON_KOERNER_LTRAIT',                        'KIND_TRAIT');   
--------------------------------------------------------------------------------------------------------------------------           
-- Traits           
--------------------------------------------------------------------------------------------------------------------------               
INSERT INTO Traits               
        (TraitType,                                                    Name,                                                    Description)
VALUES    ('TRAIT_LEADER_NEON_KOERNER_LTRAIT',                        'LOC_TRAIT_LEADER_NEON_KOERNER_LTRAIT_NAME',            'LOC_TRAIT_LEADER_NEON_KOERNER_LTRAIT_DESCRIPTION');   
--------------------------------------------------------------------------------------------------------------------------       
-- TraitModifiers       
--------------------------------------------------------------------------------------------------------------------------           
INSERT INTO TraitModifiers           
        (TraitType,                                                    ModifierId)
VALUES    ('TRAIT_LEADER_NEON_KOERNER_LTRAIT',                        'NEON_KOERNER_LTRAIT_EXTRA_SLOT_1');
--------------------------------------------------------------------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Modifiers   
        (ModifierId,                                                ModifierType)
VALUES    ('NEON_KOERNER_LTRAIT_EXTRA_SLOT_1',                        'MODIFIER_PLAYER_CULTURE_ADJUST_GOVERNMENT_SLOTS_MODIFIER');
--------------------------------------------------------------------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierArguments
        (ModifierId,                                                Name,                            Value)
VALUES    ('NEON_KOERNER_LTRAIT_EXTRA_SLOT_1',                        'GovernmentSlotType',            'SLOT_ECONOMIC');













--==========================================================================================================================
-- CIVILIZATIONS: TRAITS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO Types   
        (Type,                                                    Kind)
VALUES    ('TRAIT_CIVILIZATION_NEON_CIV_TRAIT',                    'KIND_TRAIT'),
        ('TRAIT_CIVILIZATION_BUILDING_NEON_CUSTOM',                'KIND_TRAIT'),
        ('TRAIT_CIVILIZATION_UNIT_NEON_CUSTOM_I',                'KIND_TRAIT'),
        ('TRAIT_CIVILIZATION_UNIT_NEON_CUSTOM_II',                'KIND_TRAIT');
--------------------------------------------------------------------------------------------------------------------------           
-- Traits           
--------------------------------------------------------------------------------------------------------------------------               
INSERT INTO Traits               
        (TraitType,                                                    Name,                                                    Description)
VALUES    ('TRAIT_CIVILIZATION_NEON_CIV_TRAIT',                    'LOC_TRAIT_CIVILIZATION_NEON_CIV_TRAIT_NAME',                'LOC_TRAIT_CIVILIZATION_NEON_CIV_TRAIT_DESCRIPTION'),
        ('TRAIT_CIVILIZATION_BUILDING_NEON_CUSTOM',                'LOC_TRAIT_CIVILIZATION_BUILDING_NEON_CUSTOM_NAME',            'LOC_TRAIT_CIVILIZATION_BUILDING_NEON_CUSTOM_DESCRIPTION'),
        ('TRAIT_CIVILIZATION_UNIT_NEON_CUSTOM_I',                'LOC_UNIT_NEON_CUSTOM_I_NAME',                                'LOC_UNIT_NEON_CUSTOM_I_DESCRIPTION'),           
        ('TRAIT_CIVILIZATION_UNIT_NEON_CUSTOM_II',                'LOC_UNIT_NEON_CUSTOM_II_NAME',                                'LOC_UNIT_NEON_CUSTOM_II_DESCRIPTION');           
--------------------------------------------------------------------------------------------------------------------------       
-- TraitModifiers       
--------------------------------------------------------------------------------------------------------------------------           
INSERT INTO TraitModifiers           
        (TraitType,                                            ModifierId)
VALUES    ('TRAIT_CIVILIZATION_NEON_CIV_TRAIT',                    'NEON_TRAIT_BORDER');                                                                                   
--------------------------------------------------------------------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Modifiers   
        (ModifierId,                                                ModifierType)
VALUES    ('NEON_TRAIT_BORDER',                                        'MODIFIER_ALL_CITIES_CULTURE_BORDER_EXPANSION');   
--------------------------------------------------------------------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierArguments
        (ModifierId,                                                Name,                        Value)
VALUES    ('NEON_TRAIT_BORDER',                                        'Amount',                    '100');
















--------------------------------------------------------------------------------------------------------------------------
-- LeaderTraits
--------------------------------------------------------------------------------------------------------------------------   
INSERT INTO LeaderTraits   
        (LeaderType,            TraitType)
VALUES    ('LEADER_NEON_KOERNER',    'TRAIT_LEADER_NEON_KOERNER_LTRAIT');   



----------------------------------------------------------------------------------------------------------------------------
-- CivilizationTraits
----------------------------------------------------------------------------------------------------------------------------   
INSERT INTO CivilizationTraits   
        (TraitType,                                                            CivilizationType)
VALUES    ('TRAIT_CIVILIZATION_NEON_CIV_TRAIT',                                'CIVILIZATION_NEON_AUSTRIA'),
        ('TRAIT_CIVILIZATION_BUILDING_NEON_CUSTOM',                            'CIVILIZATION_NEON_AUSTRIA'),
        ('TRAIT_CIVILIZATION_UNIT_NEON_CUSTOM_I',                            'CIVILIZATION_NEON_AUSTRIA'),
        ('TRAIT_CIVILIZATION_UNIT_NEON_CUSTOM_II',                            'CIVILIZATION_NEON_AUSTRIA');

 

[isau]

You're missing a semi colon at the end of the entries to the CivilizationCitizenNames insert.

I recommend downloading a tool like SQLite Studio to paste your code into. Even if you don't actually insert the code with the tool it will highlight errors.

 

[neonpinku]

Oh, my gosh. Such a small silly mistake. Thank you so much. I now also realize why this happened. The template I used had ten names for each category of citizen names, I however only wanted to use five, resulting in me also deleting the last semicolon. Thank you so much again for pointing it out.

Definitely gonna do that, thanks for the recommendation.

 

[isau]

Oh, my gosh. Such a small silly mistake. Thank you so much. I now also realize why this happened. The template I used had ten names for each category of citizen names, I however only wanted to use five, resulting in me also deleting the last semicolon. Thank you so much again for pointing it out.

Definitely gonna do that, thanks for the recommendation.

Missing semi colons are one of my most common errors. Don't worry too much about it but yes definitely get a tool that can parse SQL to help you debug. I can't imagine trying to code without it.