Need help with this mod

Scrinn

Chieftain
Joined
Jul 18, 2017
Messages
3
Every time I try to load the mod to test it crashes back to the main menu.

Spoiler Database.log :

[3925127.746] [Localization]: Validating Foreign Key Constraints...
[3925127.747] [Localization]: Passed Validation.
[3925127.759] [Configuration]: Validating Foreign Key Constraints...
[3925127.759] [Configuration]: Passed Validation.
[3925143.956] [FullTextSearch]: Initializing FullTextSearch
[3925144.720] [Gameplay]: Validating Foreign Key Constraints...
[3925144.737] [Gameplay]: Passed Validation.
[3925145.581] [Configuration] ERROR: no such table: Types
[3925145.582] [Configuration]: In Query - insert into Types('Type', 'Kind') values (?, ?);
[3925145.582] [Configuration]: In XMLSerializer while updating table Types from file GD_Agenda.xml.
[3925145.582] [Configuration] ERROR: no such table: Types
[3925145.582] [Configuration]: In Query - insert into Types('Type', 'Kind') values (?, ?);
[3925145.582] [Configuration]: In XMLSerializer while updating table Types from file GD_Buildings.xml.
[3925145.584] [Configuration] ERROR: no such table: Types
[3925145.584] [Configuration]: In Query - insert into Types('Type', 'Kind') values (?, ?);
[3925145.584] [Configuration]: In XMLSerializer while updating table Types from file GD_Units.xml.
[3925145.588] [Configuration]: Validating Foreign Key Constraints...
[3925145.588] [Configuration]: Passed Validation.
[3925163.963] [FullTextSearch]: FTS - Creating Context
[3925170.805] [Gameplay] ERROR: table Units has no column named Maitenance
[3925170.805] [Gameplay]: In Query - insert into Units('UnitType', 'BaseMoves', 'Cost', 'AdvisorType', 'BaseSightRange', 'Domain', 'FormationClass', 'Name', 'Description', 'PurchaseYield', 'PromotionClass', 'Maitenance', 'Combat', 'Range', 'PrereqTech', 'Bombard', 'TraitType') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
[3925170.805] [Gameplay]: In XMLSerializer while updating table Units from file GD_Units.xml.
[3925170.805] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3925170.805] [Gameplay] ERROR: FOREIGN KEY constraint failed
[3925170.805] [Gameplay]: Validating Foreign Key Constraints...
[3925170.820] [Gameplay] ERROR: Invalid Reference on UnitAiInfos.UnitType - "UNIT_GOA_JAFFA_RANGED" does not exist in Units
[3925170.820] [Gameplay] ERROR: Invalid Reference on UnitAiInfos.UnitType - "UNIT_GOA_JAFFA_RANGED" does not exist in Units
[3925170.820] [Gameplay] ERROR: Invalid Reference on UnitAiInfos.UnitType - "UNIT_GOA_JAFFA_RANGED" does not exist in Units
[3925170.820] [Gameplay] ERROR: Invalid Reference on UnitAiInfos.UnitType - "UNIT_GOA_ALKESH" does not exist in Units
[3925170.820] [Gameplay] ERROR: Invalid Reference on UnitAiInfos.UnitType - "UNIT_GOA_ALKESH" does not exist in Units
[3925170.820] [Gameplay] ERROR: Invalid Reference on UnitAiInfos.UnitType - "UNIT_GOA_ALKESH" does not exist in Units
[3925170.820] [Gameplay] ERROR: Invalid Reference on UnitAiInfos.UnitType - "UNIT_GOA_ALKESH" does not exist in Units
[3925170.821] [Gameplay] ERROR: Invalid Reference on UnitReplaces.CivUniqueUnitType - "UNIT_GOA_ALKESH" does not exist in Units
[3925170.821] [Gameplay] ERROR: Invalid Reference on UnitReplaces.CivUniqueUnitType - "UNIT_GOA_JAFFA_RANGED" does not exist in Units
[3925170.821] [Gameplay]: Failed Validation.
[3925170.858] [Gameplay]: Validating Foreign Key Constraints...
[3925170.875] [Gameplay]: Passed Validation.
[3925172.582] [FullTextSearch]: FTS - Creating Context
[3925172.775] [Configuration] ERROR: no such table: Types
[3925172.775] [Configuration]: In Query - insert into Types('Type', 'Kind') values (?, ?);
[3925172.775] [Configuration]: In XMLSerializer while updating table Types from file GD_Agenda.xml.
[3925172.775] [Configuration] ERROR: no such table: Types
[3925172.775] [Configuration]: In Query - insert into Types('Type', 'Kind') values (?, ?);
[3925172.775] [Configuration]: In XMLSerializer while updating table Types from file GD_Buildings.xml.
[3925172.776] [Configuration] ERROR: no such table: Types
[3925172.776] [Configuration]: In Query - insert into Types('Type', 'Kind') values (?, ?);
[3925172.776] [Configuration]: In XMLSerializer while updating table Types from file GD_Units.xml.
[3925172.781] [Configuration]: Validating Foreign Key Constraints...
[3925172.781] [Configuration]: Passed Validation.
[3925178.900] [FullTextSearch]: FullTextSearch - Shutting down



I'm guessing it's because it's saying units dont exists but

Spoiler GD_Units.xml :

<?xml version="1.0" encoding="utf-8"?>
<!-- Author: Scrinn -->
<!-- DateCreated: 8/2/2017 4:00:00 AM -->
<!--All units and their relevant modifiers are defined here.-->
<GameData>
<Types>
<Row Type="UNIT_GOA_JAFFA" Kind="KIND_UNIT"/>
<Row Type="UNIT_GOA_JAFFA_RANGED" Kind="KIND_UNIT"/>
<Row Type="UNIT_GOA_KULL_WARRIORS" Kind="KIND_UNIT"/>
<Row Type="UNIT_GOA_ALKESH" Kind="KIND_UNIT"/>
</Types>

<UnitAiInfos>
<Row UnitType="UNIT_GOA_JAFFA" AiType="UNITAI_COMBAT"/>
<Row UnitType="UNIT_GOA_JAFFA" AiType="UNITAI_EXPLORE"/>
<Row UnitType="UNIT_GOA_JAFFA" AiType="UNITTYPE_MELEE"/>
<Row UnitType="UNIT_GOA_JAFFA" AiType="UNITTYPE_LAND_COMBAT"/>
<Row UnitType="UNIT_GOA_JAFFA_RANGED" AiType="UNITAI_COMBAT"/>
<Row UnitType="UNIT_GOA_JAFFA_RANGED" AiType="UNITTYPE_RANGED"/>
<Row UnitType="UNIT_GOA_JAFFA_RANGED" AiType="UNITTYPE_LAND_COMBAT"/>
<Row UnitType="UNIT_GOA_KULL_WARRIORS" AiType="UNITAI_COMBAT"/>
<Row UnitType="UNIT_GOA_KULL_WARRIORS" AiType="UNITAI_EXPLORE"/>
<Row UnitType="UNIT_GOA_KULL_WARRIORS" AiType="UNITTYPE_MELEE"/>
<Row UnitType="UNIT_GOA_KULL_WARRIORS" AiType="UNITTYPE_LAND_COMBAT"/>
<Row UnitType="UNIT_GOA_ALKESH" AiType="UNITAI_COMBAT"/>
<Row UnitType="UNIT_GOA_ALKESH" AiType="UNITTYPE_SIEGE"/>
<Row UnitType="UNIT_GOA_ALKESH" AiType="UNITTYPE_RANGED"/>
<Row UnitType="UNIT_GOA_ALKESH" AiType="UNITTYPE_LAND_COMBAT"/>
</UnitAiInfos>

<UnitReplaces>
<Row CivUniqueUnitType="UNIT_GOA_JAFFA" ReplacesUnitType="UNIT_INFANTRY"/>
<Row CivUniqueUnitType="UNIT_GOA_KULL_WARRIORS" ReplacesUnitType="UNIT_MECHANIZED_INFANTRY"/>
<Row CivUniqueUnitType="UNIT_GOA_ALKESH" ReplacesUnitType="UNIT_ROCKET_ARTILLERY"/>
<Row CivUniqueUnitType="UNIT_GOA_JAFFA_RANGED" ReplacesUnitType="UNIT_MACHINE_GUN"/>
</UnitReplaces>

<TypeTags>
<Row Type="UNIT_GOA_KULL_WARRIORS" Tag="CLASS_MELEE"/>
<Row Type="UNIT_GOA_JAFFA" Tag="CLASS_MELEE"/>
<Row Type="UNIT_GOA_ALKESH" Tag="CLASS_SIEGE"/>
<Row Type="UNIT_GOA_ALKESH" Tag="CLASS_FORWARD_OBSERVER"/>
<Row Type="UNIT_GOA_JAFFA_RANGED" Tag="CLASS_RANGED"/>
<Row Type="UNIT_GOA_JAFFA_RANGED" Tag="CLASS_ANTI_AIR"/>
</TypeTags>

<Units>
<Row UnitType="UNIT_GOA_JAFFA" BaseMoves="3" Cost="400" AdvisorType="ADVISOR_CONQUEST" BaseSightRange="2" Domain="DOMAIN_LAND" FormationClass="FORMATION_CLASS_LAND_COMBAT" Name="LOC_UNIT_GOA_JAFFA_NAME" Description="LOC_UNIT_GOA_JAFFA_DESCRIPTION" PurchaseYield="YIELD_GOLD" PromotionClass="PROMOTION_CLASS_MELEE" Maintenance="2" Combat="90" PrereqTech="TECH_REPLACEABLE_PARTS" TraitType="TRAIT_CIVILIZATION_UNIT_GOA_JAFFA"/>
<Row UnitType="UNIT_GOA_KULL_WARRIORS" BaseMoves="3" Cost="500" AdvisorType="ADVISOR_CONQUEST" BaseSightRange="2" Domain="DOMAIN_LAND" FormationClass="FORMATION_CLASS_LAND_COMBAT" Name="LOC_UNIT_GOA_KULL_WARRIORS_NAME" Description="LOC_UNIT_GOA_KULL_WARRIORS_DESCRIPTION" PurchaseYield="YIELD_GOLD" PromotionClass="PROMOTION_CLASS_MELEE" Maintenance="2" Combat="110" PrereqTech="TECH_SATELLITES" TraitType="TRAIT_CIVILIZATION_UNIT_GOA_KULL_WARRIORS"/>
<Row UnitType="UNIT_GOA_ALKESH" BaseMoves="3" Cost="500" AdvisorType="ADVISOR_CONQUEST" BaseSightRange="4" Domain="DOMAIN_LAND" FormationClass="FORMATION_CLASS_LAND_COMBAT" Name="LOC_UNIT_GOA_ALKESH_NAME" Description="LOC_UNIT_ALKESH_DESCRIPTION" PurchaseYield="YIELD_GOLD" PromotionClass="PROMOTION_CLASS_SIEGE" Maitenance="6" Combat="80" Range="5" PrereqTech="TECH_GUIDANCE_SYSTEMS" Bombard="100" TraitType="TRAIT_CIVILIZATION_UNIT_GOA_ALKESH"/>
<Row UnitType="UNIT_GOA_JAFFA_RANGED" BaseMoves="3" Cost="450" AdvisorType="ADVISOR_CONQUEST" BaseSightRange="4" Domain="DOMAIN_LAND" FormationClass="FORMATION_CLASS_LAND_COMBAT" Name="LOC_UNIT_GOA_JAFFA_RANGED_NAME" Description="LOC_UNIT_GOA_JAFFA_RANGED_DESCRIPTION" PurchaseYield="YIELD_GOLD" PromotionClass="PROMOTION_CLASS_RANGED" Maintenance="4" Combat="80" RangedCombat="90" Range="4" PrereqTech="TECH_TELECOMMUNICATIONS" TraitType="TRAIT_CIVILIZATION_UNIT_GOA_JAFFA_RANGED"/>
</Units>

<UnitUpgrades>
<Row Unit="UNIT_GOA_JAFFA" UpgradeUnit="UNIT_GOA_KULL_WARRIORS"/>
<Row Unit="UNIT_FIELD_CANNON" UpgradeUnit="UNIT_GOA_JAFFA_RANGED"/>
<Row Unit="UNIT_MUSKETMAN" UpgradeUnit="UNIT_GOA_JAFFA"/>
<Row Unit="UNIT_ARTILLERY" UpgradeUnit="UNIT_GOA_ALKESH"/>
</UnitUpgrades>

</GameData>



I don't know it's saying they dont exist but I also don't know if that's the reason it's crashing back to the main menu
 
"[3925170.805] [Gameplay] ERROR: table Units has no column named Maitenance"

Fix that first and see if it makes a difference. Sometimes small mistakes like that can **** everything up.
This is indeed the root of the problem. It is causing the game not to load the entire contents of file GD_Units.xml.

Also, @Scrinn
  1. It does not matter what is in the mod, it only matters what successfully loads into the game. The fatal syntax error with your column-name means that neither UNIT_GOA_ALKESH nor UNIT_GOA_JAFFA_RANGED exist within the game. Your confusion as to what the game means by "does not exist" is a common misunderstanding.
  2. This however is no good at all
    Code:
    <UnitUpgrades>
     <Row Unit="UNIT_GOA_JAFFA" UpgradeUnit="UNIT_GOA_KULL_WARRIORS"/>
     <Row Unit="UNIT_FIELD_CANNON" UpgradeUnit="UNIT_GOA_JAFFA_RANGED"/>
     <Row Unit="UNIT_MUSKETMAN" UpgradeUnit="UNIT_GOA_JAFFA"/>
     <Row Unit="UNIT_ARTILLERY" UpgradeUnit="UNIT_GOA_ALKESH"/>
     </UnitUpgrades>
    You are attempting to re-direct the path by which standard game units upgrade. UNIT_FIELD_CANNON, UNIT_MUSKETMAN, and UNIT_ARTILLERY should not be redirected in this manner. Your code here
    Code:
    <UnitReplaces>
     <Row CivUniqueUnitType="UNIT_GOA_JAFFA" ReplacesUnitType="UNIT_INFANTRY"/>
     <Row CivUniqueUnitType="UNIT_GOA_KULL_WARRIORS" ReplacesUnitType="UNIT_MECHANIZED_INFANTRY"/>
     <Row CivUniqueUnitType="UNIT_GOA_ALKESH" ReplacesUnitType="UNIT_ROCKET_ARTILLERY"/>
     <Row CivUniqueUnitType="UNIT_GOA_JAFFA_RANGED" ReplacesUnitType="UNIT_MACHINE_GUN"/>
     </UnitReplaces>
    should be all that is necessary to deal with the upgrading of UNIT_FIELD_CANNON, UNIT_MUSKETMAN, and UNIT_ARTILLERY into your units for your civ. You just need to make sure that your unique units upgrade to the correct type of "standard" unit when this is correct. For ex Rocket Artillery and Mech Infantry as I recall have no further upgrade so you would not need to set an upgrade unit for UNIT_GOA_KULL_WARRIORS or UNIT_GOA_ALKESH
 
Thank you so much for pointing out the spelling error, I really shouldn't be typing out code and tags at 4 in the morning I'm exhausted lmfao. @LeeS I just wanted to make sure that they have their correct upgrade paths, but if they aren't needed I'll just remove them.
 
Top Bottom