SQL Errors help

Firebug

Firebug

Not-so Great Engineer
Joined
Sep 25, 2014
Messages
1,271
Location
Clevedon, England
I'm hitting a few errors with my SQL.

Code: 
ERROR: CHECK constraint failed: Units
ERROR: near ")": syntax error

I'm hoping someone will knowledge of SQL could poke around in my code and see what i've screwed up. I just can't see it.

Code: 
--==========================================================================================================================
-- LOADING INFO
--==========================================================================================================================
-- LoadingInfo
-------------------------------------   
INSERT INTO LoadingInfo   
        (LeaderType,                ForegroundImage,                        PlayDawnOfManAudio)
VALUES    ('LEADER_FB_KARL',        'LEADER_FB_KARL_NEUTRAL.dds',        0);   
--==========================================================================================================================
-- DIPLOMACY INFO
--==========================================================================================================================
-- DiplomacyInfo
-------------------------------------   
--INSERT INTO DiplomacyInfo   
--         (Type,                        BackgroundImage)
--VALUES    ('LEADER_FB_KARL',        'FALLBACK_NEUTRAL_FB_KARL.dds');
--==========================================================================================================================
-- COLOURS
--==========================================================================================================================
-- PlayerColors
-------------------------------------   
INSERT INTO PlayerColors   
        (Type,                            Usage,                PrimaryColor,                                         SecondaryColor,                                        TextColor)
VALUES    ('LEADER_FB_KARL',            'Unique',            'COLOR_PLAYER_FB_SWEDEN_PRIMARY',            'COLOR_PLAYER_FB_SWEDEN_SECONDARY',     'COLOR_PLAYER_WHITE_TEXT');   

INSERT INTO Colors
        (Type,                                                 Red,     Green,     Blue,     Alpha)
VALUES    ('COLOR_PLAYER_FB_SWEDEN_PRIMARY',             0.40,    0.07,    0.20,    1),
        ('COLOR_PLAYER_FB_SWEDEN_SECONDARY',         1.00,    0.78,    0.20,    1);
--==========================================================================================================================
-- LEADERS
--==========================================================================================================================
-- Types
-------------------------------------   
INSERT INTO Types   
        (Type,                            Kind)
VALUES    ('LEADER_FB_KARL',            'KIND_LEADER');   
-------------------------------------
-- Leaders
-------------------------------------   
INSERT INTO Leaders   
        (LeaderType,                    Name,                                                InheritFrom,        SceneLayers)
VALUES    ('LEADER_FB_KARL',                'LOC_LEADER_FB_KARL_NAME',                            'LEADER_DEFAULT',    3);   
-------------------------------------
-- LeaderQuotes
-------------------------------------   
INSERT INTO LeaderQuotes   
        (LeaderType,                    Quote)
VALUES    ('LEADER_FB_KARL',            'LOC_PEDIA_LEADERS_PAGE_FB_KARL_QUOTE');   

-------------------------------------
-- LeaderTraits
-------------------------------------   
INSERT INTO LeaderTraits   
        (LeaderType,                    TraitType)
VALUES    ('LEADER_FB_KARL',            'TRAIT_LEADER_FB_CAROLUS_REX');   
-- -------------------------------------
-- -- FavoredReligions
-- -------------------------------------   
--INSERT INTO FavoredReligions   
--         (LeaderType,                    ReligionType)
-- VALUES    ('LEADER_FB_KARL',            'RELIGION_PROTESTANTISM');
--==========================================================================================================================
-- CIVILIZATIONS
--==========================================================================================================================
-- Types
-------------------------------------   
INSERT INTO Types   
        (Type,                                Kind)
VALUES    ('CIVILIZATION_FB_SWEDEN',            'KIND_CIVILIZATION'),   
        ('BUILDING_FB_ROYAL_ACADEMY',        'KIND_BUILDING'),   
        ('UNIT_FB_CAROLEAN',                'KIND_UNIT');   
-------------------------------------           
-- Civilizations           
-------------------------------------   
INSERT INTO Civilizations
        (CivilizationType,                    Name,                                Description,                                            Adjective,                                    StartingCivilizationLevelType,        RandomCityNameDepth,        Ethnicity        )
VALUES    ('CIVILIZATION_FB_SWEDEN',            'LOC_CIVILIZATION_FB_SWEDEN_NAME',    'LOC_CIVILIZATION_FB_SWEDEN_DESCRIPTION',                'LOC_CIVILIZATION_FB_SWEDEN_ADJECTIVE',        'CIVILIZATION_LEVEL_FULL_CIV',        '10',                        'ETHNICITY_EURO');   
--==========================================================================================================================
-- TRAITS
--==========================================================================================================================
-- Types
-------------------------------------   
INSERT INTO Types   
        (Type,                                                Kind)
VALUES    ('TRAIT_LEADER_FB_CAROLUS_REX',                        'KIND_TRAIT'),
        ('TRAIT_CIVILIZATION_FB_GREAT_POWER',                'KIND_TRAIT'),   
        ('TRAIT_CIVILIZATION_UNIT_FB_CAROLEAN',                'KIND_TRAIT'),   
        ('TRAIT_CIVILIZATION_BUILDING_FB_ROYAL_ACADEMY',    'KIND_TRAIT');   
-------------------------------------           
-- Traits           
-------------------------------------               
INSERT INTO Traits               
        (TraitType,                                        Name,                                                Description)
VALUES    ('TRAIT_LEADER_FB_CAROLUS_REX',                    'LOC_TRAIT_LEADER_FB_CAROLUS_REX_NAME',                'LOC_TRAIT_LEADER_FB_CAROLUS_REX_DESCRIPTION'),
        ('TRAIT_CIVILIZATION_FB_GREAT_POWER',            'LOC_TRAIT_CIVILIZATION_FB_GREAT_POWER_NAME',        'LOC_TRAIT_CIVILIZATION_FB_GREAT_POWER_DESCRIPTION'),
        ('TRAIT_CIVILIZATION_UNIT_FB_CAROLEAN',            'LOC_TRAIT_CIVILIZATION_UNIT_FB_CAROLEAN_NAME',        'LOC_TRAIT_CIVILIZATION_UNIT_FB_CAROLEAN_DESCRIPTION'),
        ('TRAIT_CIVILIZATION_BUILDING_FB_ROYAL_ACADEMY',    'LOC_TRAIT_CIVILIZATION_BUILDING_FB_ROYAL_ACADEMY',        'LOC_TRAIT_CIVILIZATION_BUILDING_FB_ROYAL_ACADEMY');
-------------------------------------           
-- StartBias           
-------------------------------------           
INSERT INTO StartBiasFeatures   
        (CivilizationType,                    FeatureType,        Tier    )
VALUES    ('CIVILIZATION_FB_SWEDEN',            'FEATURE_FOREST',    '3'        );   
INSERT INTO StartBiasTerrains
        (CivilizationType,                    TerrainType,            Tier    )
VALUES    ('CIVILIZATION_FB_SWEDEN',            'TERRAIN_TUNDRA',        '3'        ),   
        ('CIVILIZATION_FB_SWEDEN',            'TERRAIN_TUNDRA_HILLS',    '3'        ),   
        ('CIVILIZATION_FB_SWEDEN',            'TERRAIN_GRASS',        '3'        );
INSERT INTO StartBiasRivers
        (CivilizationType,                    Tier    )
VALUES    ('CIVILIZATION_FB_SWEDEN',            '5'        );   
-------------------------------------       
-- TraitModifiers       
-------------------------------------           
INSERT INTO TraitModifiers           
        (TraitType,                                                    ModifierId)
VALUES    ('TRAIT_LEADER_FB_CAROLUS_REX',                                'TRAIT_FB_CAROLUS_REX_BARRACKS_YIELD'),
        ('TRAIT_LEADER_FB_CAROLUS_REX',                                'TRAIT_FB_CAROLUS_REX_STABLE_YIELD'),
        ('TRAIT_LEADER_FB_CAROLUS_REX',                                'TRAIT_FB_CAROLUS_REX_ARMORY_YIELD'),
        ('TRAIT_LEADER_FB_CAROLUS_REX',                                'TRAIT_FB_CAROLUS_REX_MILITARY_ACADEMY_YIELD'),
        ('TRAIT_CIVILIZATION_FB_GREAT_POWER',                        'TRAIT_FB_GREAT_POWER_RENAISSANCE_PRODUCTION');
                    
--------------------------------------------------------------------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Modifiers   
        (ModifierId,                                                ModifierType,                                                RunOnce,    Permanent)
VALUES    ('TRAIT_FB_CAROLUS_REX_BARRACKS_YIELD',                        'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE',        0,            1),
        ('TRAIT_FB_CAROLUS_REX_STABLE_YIELD',                        'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE',        0,            1),
        ('TRAIT_FB_CAROLUS_REX_ARMORY_YIELD',                        'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE',        0,            1),   
        ('TRAIT_FB_CAROLUS_REX_MILITARY_ACADEMY_YIELD',                'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE',        0,            1);   

        INSERT INTO Modifiers   
        (ModifierId,                                                ModifierType,                                                SubjectRequirementSetId)
VALUES     ('TRAIT_FB_GREAT_POWER_MEDIEVAL_PRODUCTION',                'MODIFIER_PLAYER_CITIES_ADJUST_MILITARY_UNITS_PRODUCTION',        null),
        ('TRAIT_FB_GREAT_POWER_RENAISSANCE_PRODUCTION',                'MODIFIER_PLAYER_CITIES_ADJUST_MILITARY_UNITS_PRODUCTION',        null),
        ('TRAIT_FB_GREAT_POWER_INDUSTRIAL_PRODUCTION',                'MODIFIER_PLAYER_CITIES_ADJUST_MILITARY_UNITS_PRODUCTION',        null);
--------------------------------------------------------------------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierArguments
        (ModifierId,                                                Name,                    Value,                                Extra,                Type)
VALUES    ('TRAIT_FB_CAROLUS_REX_BARRACKS_YIELD',                    'BuildingType',            'BUILDING_BARRACKS',                null,                'ARGTYPE_IDENTITY'),
        ('TRAIT_FB_CAROLUS_REX_BARRACKS_YIELD',                    'YieldType',            'YIELD_SCIENCE',                    null,                'ARGTYPE_IDENTITY'),
        ('TRAIT_FB_CAROLUS_REX_BARRACKS_YIELD',                    'Amount',                1,                                    null,                'ARGTYPE_IDENTITY'),

        ('TRAIT_FB_CAROLUS_REX_STABLE_YIELD',                    'BuildingType',            'BUILDING_STABLE',                    null,                'ARGTYPE_IDENTITY'),
        ('TRAIT_FB_CAROLUS_REX_STABLE_YIELD',                    'YieldType',            'YIELD_SCIENCE',                    null,                'ARGTYPE_IDENTITY'),
        ('TRAIT_FB_CAROLUS_REX_STABLE_YIELD',                    'Amount',                1,                                    null,                'ARGTYPE_IDENTITY'),

        ('TRAIT_FB_CAROLUS_REX_ARMORY_YIELD',                    'BuildingType',            'BUILDING_ARMORY',                    null,                'ARGTYPE_IDENTITY'),
        ('TRAIT_FB_CAROLUS_REX_ARMORY_YIELD',                    'YieldType',            'YIELD_SCIENCE',                    null,                'ARGTYPE_IDENTITY'),
        ('TRAIT_FB_CAROLUS_REX_ARMORY_YIELD',                    'Amount',                2,                                    null,                'ARGTYPE_IDENTITY'),

        ('TRAIT_FB_CAROLUS_REX_MILITARY_ACADEMY_YIELD',            'BuildingType',            'BUILDING_MILITARY_ACADEMY',        null,                'ARGTYPE_IDENTITY'),
        ('TRAIT_FB_CAROLUS_REX_MILITARY_ACADEMY_YIELD',            'YieldType',            'YIELD_SCIENCE',                    null,                'ARGTYPE_IDENTITY'),
        ('TRAIT_FB_CAROLUS_REX_MILITARY_ACADEMY_YIELD',            'Amount',                3,                                    null,                'ARGTYPE_IDENTITY'),

        ('TRAIT_FB_GREAT_POWER_MEDIEVAL_PRODUCTION',            'EraType',                'ERA_MEDIEVAL',                        null,                'ARGTYPE_IDENTITY'),
        ('TRAIT_FB_GREAT_POWER_MEDIEVAL_PRODUCTION',            'Amount',                20,                                    null,                'ARGTYPE_IDENTITY'),

        ('TRAIT_FB_GREAT_POWER_RENAISSANCE_PRODUCTION',            'EraType',                'ERA_RENAISSANCE',                    null,                'ARGTYPE_IDENTITY'),
        ('TRAIT_FB_GREAT_POWER_RENAISSANCE_PRODUCTION',            'Amount',                20,                                    null,                'ARGTYPE_IDENTITY'),

        ('TRAIT_FB_GREAT_POWER_INDUSTRIAL_PRODUCTION',            'EraType',                'ERA_INDUSTRIAL',                    null,                'ARGTYPE_IDENTITY'),
        ('TRAIT_FB_GREAT_POWER_INDUSTRIAL_PRODUCTION',            'Amount',                20,                                    null,                'ARGTYPE_IDENTITY');
--==========================================================================================================================
-- AGENDAS
--==========================================================================================================================
-- Types
-------------------------------------   
INSERT INTO Types   
        (Type,                                    Kind)
VALUES    ('TRAIT_AGENDA_FB_JUST_WAR',        'KIND_TRAIT');           
-------------------------------------           
-- Agendas           
-------------------------------------               
INSERT INTO Agendas               
        (AgendaType,                            Name,                                    Description)
VALUES    ('AGENDA_FB_JUST_WAR',            'LOC_AGENDA_FB_JUST_WAR_NAME',    'LOC_AGENDA_FB_JUST_WAR_DESCRIPTION');   
-- -------------------------------------
-- -- HistoricalAgendas
-- -------------------------------------   
INSERT INTO HistoricalAgendas   
        (LeaderType,                    AgendaType)
VALUES    ('LEADER_FB_KARL',            'AGENDA_FB_JUST_WAR');   
-------------------------------------           
-- Traits           
-------------------------------------               
INSERT INTO Traits               
        (TraitType,                                Name,                                        Description)
VALUES    ('TRAIT_AGENDA_FB_JUST_WAR',        'LOC_AGENDA_FB_JUST_WAR_NAME',        'LOC_AGENDA_FB_JUST_WAR_DESCRIPTION');   
-------------------------------------           
-- AgendaTraits           
-------------------------------------               
INSERT INTO AgendaTraits               
        (AgendaType,                            TraitType)
VALUES    ('AGENDA_FB_JUST_WAR',            'TRAIT_AGENDA_FB_JUST_WAR');   
-------------------------------------       
-- TraitModifiers
-------------------------------------           
INSERT INTO TraitModifiers           
        (TraitType,                                ModifierId)
VALUES    ('TRAIT_AGENDA_FB_JUST_WAR',        'AGENDA_MODIFIER_FB_CLEARS_BARBARIAN_CAMPS'),
        ('TRAIT_AGENDA_FB_JUST_WAR',        'AGENDA_MODIFIER_FB_IGNORES_BARBARIAN_CAMPS');
--------------------------------------------------------------------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Modifiers   
        (ModifierId,                                        ModifierType,                                        SubjectRequirementSetId)
VALUES    ('AGENDA_MODIFIER_FB_CLEARS_BARBARIAN_CAMPS',        'MODIFIER_PLAYER_DIPLOMACY_SIMPLE_MODIFIER',        'FB_PLAYER_CLEARS_BARBARIAN_CAMPS'),
        ('AGENDA_MODIFIER_FB_IGNORES_BARBARIAN_CAMPS',        'MODIFIER_PLAYER_DIPLOMACY_SIMPLE_MODIFIER',        'FB_PLAYER_IGNORES_BARBARIAN_CAMPS');
--------------------------------------------------------------------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierArguments
        (ModifierId,                                        Name,                            Value,                                                    Extra,                Type)
VALUES    ('AGENDA_MODIFIER_FB_CLEARS_BARBARIAN_CAMPS',        'InitialValue',                    7,                                                        null,                'ARGTYPE_IDENTITY'),
        ('AGENDA_MODIFIER_FB_CLEARS_BARBARIAN_CAMPS',        'StatementKey',                    'LOC_DIPLO_KUDO_LEADER_FB_KARL_REASON_ANY',            null,                'ARGTYPE_IDENTITY'),
        ('AGENDA_MODIFIER_FB_CLEARS_BARBARIAN_CAMPS',        'SimpleModifierDescription',    'LOC_DIPLO_MODIFIER_FB_JUST_WAR_CLEARING',        null,                'ARGTYPE_IDENTITY'),
        ('AGENDA_MODIFIER_FB_IGNORES_BARBARIAN_CAMPS',        'InitialValue',                    -7,                                                        null,                'ARGTYPE_IDENTITY'),
        ('AGENDA_MODIFIER_FB_IGNORES_BARBARIAN_CAMPS',        'StatementKey',                    'LOC_DIPLO_WARNING_LEADER_FB_KARL_REASON_ANY',        null,                'ARGTYPE_IDENTITY'),
        ('AGENDA_MODIFIER_FB_IGNORES_BARBARIAN_CAMPS',        'SimpleModifierDescription',    'LOC_DIPLO_MODIFIER_FB_JUST_WAR_IGNORING',        null,                'ARGTYPE_IDENTITY');
-------------------------------------
-- RequirementSets
-------------------------------------
INSERT INTO RequirementSets
        (RequirementSetId,                                            RequirementSetType)
VALUES    ('FB_PLAYER_CLEARS_BARBARIAN_CAMPS',                'REQUIREMENTSET_TEST_ALL'),
        ('FB_PLAYER_IGNORES_BARBARIAN_CAMPS',                'REQUIREMENTSET_TEST_ALL');
-------------------------------------
-- RequirementSetRequirements
-------------------------------------
INSERT INTO RequirementSetRequirements
        (RequirementSetId,                                    RequirementId)
VALUES    ('FB_PLAYER_CLEARS_BARBARIAN_CAMPS',                'REQUIRES_MAJOR_CIV_OPPONENT'),
        ('FB_PLAYER_CLEARS_BARBARIAN_CAMPS',                'REQUIRES_MET_10_TURNS_AGO'),
        ('FB_PLAYER_CLEARS_BARBARIAN_CAMPS',                'REQUIRES_CLEARS_BARBARIAN_CAMPS'),
        ('FB_PLAYER_IGNORES_BARBARIAN_CAMPS',                'REQUIRES_MAJOR_CIV_OPPONENT'),
        ('FB_PLAYER_IGNORES_BARBARIAN_CAMPS',                'REQUIRES_MET_10_TURNS_AGO'),
        ('FB_PLAYER_IGNORES_BARBARIAN_CAMPS',                'REQUIRES_IGNORES_BARBARIAN_CAMPS'),
        ('FB_PLAYER_IGNORES_BARBARIAN_CAMPS',                'REQUIRES_HAS_HIGH_STANDING_ARMY');           
--==========================================================================================================================
-- CivilizationLeaders
--==========================================================================================================================
INSERT INTO CivilizationLeaders
        (LeaderType,             CivilizationType,        CapitalName)
VALUES  ('LEADER_FB_KARL',    'CIVILIZATION_FB_SWEDEN',    'LOC_CITY_NAME_FB_STOCKHOLM');
--==========================================================================================================================
-- Units
--==========================================================================================================================
INSERT INTO Units               
        (UnitType,                    Name,                                        Description,                            BaseMoves,            Cost,            AdvisorType,                    BaseSightRange,            ZoneOfControl,            Domain,                    FormationClass,                                PurchaseYield,                    PromotionClass,                            Maintenance,                    Combat,                    MandatoryObsoleteTech,            TraitType,                                    PrereqTech        )
VALUES    ('UNIT_FB_CAROLEAN',        'LOC_UNIT_FB_CAROLEAN_NAME',                'LOC_UNIT_FB_CAROLEAN_DESCRIPTION',        '2',                '250',            'ADVISOR_CONQUEST',                '2',                    'True',                    'DOMAIN_LAND',            'FORMATION_CLASS_LAND_COMBAT',                'YIELD_GOLD',                    'PROMOTION_CLASS_MELEE',                '4',                            '55',                    'TECH_SATELLITES',                'TRAIT_CIVILIZATION_UNIT_FB_CAROLEAN',        'TECH_GUNPOWDER');
-------------------------------------
-- UnitReplaces
-------------------------------------
INSERT INTO UnitReplaces               
        (CivUniqueUnitType,            ReplacesUnitType           )
VALUES    ('UNIT_FB_CAROLEAN',        'UNIT_MUSKETMAN');
-------------------------------------
-- UnitAiInfos
-------------------------------------
INSERT INTO UnitAiInfos           
        (UnitType,                    AIType                    )
VALUES    ('UNIT_FB_CAROLEAN',        'UNITAI_COMBAT'            ),
        ('UNIT_FB_CAROLEAN',        'UNITAI_EXPLORE'        ),
        ('UNIT_FB_CAROLEAN',        'UNITTYPE_MELEE'        ),
        ('UNIT_FB_CAROLEAN',        'UNITTYPE_LAND_COMBAT'    );
-------------------------------------
-- Tags
-------------------------------------
INSERT INTO Tags           
        (Tag,                        Vocabulary       )
VALUES    ('CLASS_FB_CAROLEAN',        'ABILITY_CLASS');
-------------------------------------
-- TypeTags
-------------------------------------
INSERT INTO TypeTags           
        (Type,                        Tag       )
VALUES    ('UNIT_FB_CAROLEAN',        'CLASS_MELEE'),
        ('UNIT_FB_CAROLEAN',        'CLASS_FB_CAROLEAN');
-------------------------------------
-- UnitUpgrades
-------------------------------------
INSERT INTO UnitUpgrades           
        (Unit,                        UpgradeUnit       )
VALUES    ('UNIT_FB_CAROLEAN',        'UNIT_INFANTRY');
-------------------------------------
-- UnitAbilities
-------------------------------------
INSERT INTO UnitAbilities           
        (UnitAbilityType,                        Name,                                Description                             )
VALUES    ('ABILITY_FB_CAROLEAN',                    'LOC_ABILITY_FB_CAROLEAN_NAME',        'LOC_ABILITY_FB_CAROLEAN_DESCRIPTION');

INSERT INTO UnitAbilityModifiers           
        (UnitAbilityType,                        ModifierId                        )
VALUES    ('ABILITY_FB_CAROLEAN',                    'FB_CAROLEAN_HEAL_EVERY_MOVE'    );

INSERT INTO Modifiers           
        (ModifierId,                                    ModifierType    )
VALUES    ('FB_CAROLEAN_HEAL_EVERY_MOVE',                    'MODIFIER_PLAYER_UNIT_GRANT_HEAL_AFTER_ACTION'    );
--==========================================================================================================================
-- Buildings
--==========================================================================================================================
INSERT INTO Buildings               
        (BuildingsType,                        Name,                                                Description,                                        PreReqCivic,                    Cost,            AdvisorType,                        PreReqDistrict,                        Housing,            CitizenSlots,                    PurchaseYield,                    Maintenance,                    TraitType,                            )
VALUES    ('BUILDING_FB_ROYAL_ACADEMY',        'LOC_BUILDING_FB_ROYAL_ACADEMY_NAME',                'LOC_BUILDING_FB_ROYAL_ACADEMY_DESCRIPTION',        'CIVIC_THEOLOGY',                '225',            'ADVISOR_TECHNOLOGY',                'DISTRICT_CAMPUS',                    '2',                '1',                            'YIELD_GOLD',                    '2',                            'TRAIT_CIVILIZATION_UNIT_FB_CAROLEAN');
-------------------------------------
-- BuildingPreReqs
-------------------------------------
INSERT INTO BuildingPreReqs       
        (Building,                                    PreReqBuilding    )
VALUES    ('BUILDING_FB_ROYAL_ACADEMY',                'BUILDING_LIBRARY'    );
-------------------------------------
-- Building_YieldChanges
-------------------------------------
INSERT INTO Building_YieldChanges       
        (BuildingType,                                YieldType,            YieldChange    )
VALUES    ('BUILDING_FB_ROYAL_ACADEMY',                'YIELD_SCIENCE',    '4'            );
-------------------------------------
-- BuildingGreatPersonPoints
-------------------------------------
INSERT INTO BuildingGreatPersonPoints       
        (BuildingType,                                GreatPersonClassType,                PointsPerTurn    )
VALUES    ('BUILDING_FB_ROYAL_ACADEMY',                'GREAT_PERSON_CLASS_SCIENTIST',        '1'                ),
        ('BUILDING_FB_ROYAL_ACADEMY',                'GREAT_PERSON_CLASS_GENERAL',        '1'                );
--==========================================================================================================================
--==========================================================================================================================

Everything ingame works aside from the Civilization's abilities, the leader and civ are ingame and fine but everything in the code past when i add in the Unit seems to break. But i just can't see it.
 
I don't know if you have figured it out yet but in "INSERT INTO Buildings" you have an extra comma next to "Trait Type". Delete that and you should be good to go.
 
When you get totally stuck like this and can't figure out which part of the code is failing, try creating a ModifierArgument (I like to do the Modifier insert in a top-level "setup" sql file so its always available if I need it.)

Basically create the setup like this:


INSERT INTO Modifiers
(ModifierID, ModifierType, RunOnce, Permanent, OwnerRequirementSetId, SubjectRequirementSetId)
VALUES ('QUO_DEBUG_COUNTER', 'MODIFIER_PLAYER_DIPLOMACY_SIMPLE_MODIFIER', 0, 0, NULL, NULL) ;

INSERT INTO ModifierArguments
(ModifierID, Name, Type, Value, Extra)
VALUES (''QUO_DEBUG_COUNTER', 'Amount', 'ARGTYPE_IDENTITY', '0', NULL) ;


Then sprinkle this throughout your code, wherever you suspect the error might be near:


UPDATE ModifierArguments SET Value=Value+1 WHERE ModifierID=''QUO_DEBUG_COUNTER' AND Name='Amount' ;



That will add 1 to the value each time it increments. Then just go into SQLite and do a SELECT for that ModifierArgument and count how far the code got before it ran into an issue.


You'll notice at the end of every file in my Combined Tweaks mod there is an incrementor. I use it for this exact reason. To spot check and make sure no file failed to complete.
 
You must log in or register to reply here.

Similar threads

B
Looking for help on what I'm doing wrong with my Mod
Replies
1
Views
1K
slushfund
S
W
Stacking Relic Bonus
Replies
5
Views
841
WeaponizedIncontinence
W
C
Adding Diplo Points to Tier 3 Alliances
Replies
0
Views
418
cyberhawk94
C
L
How enable to plant jungle ?
Replies
0
Views
1K
Lochwein
L
A
[GS] Problems with custom civilization traits and features
Replies
1
Views
2K
alex1
A
Back
Top Bottom