Need Help with my first Mod, Please

[MR.Pat]

Hello
I want to learn the Basics of Civ6 Modding, my Refference is :
LeeS' Civilization 6 Modding Guide and The Documentation from the SDK.
I just bought the Vanile Game.

At first i would like to adress the Database.Log file, because i get these Error Messages, regardeless, if i start the Game with any kind of Mod, or without a Mod:
[1762796.238] [Localization]: StartupErrorMessages.xml
[1762796.239] [Localization]: Input XML does not contain database entry tags. GameData, GameInfo or Database.
I dont know what that means.

My Second question would be about my first TestMod ( GameSpeedUltra)
I want add another GameSpeed to the Game, like Marathon, or Epic, my GameSpeed is called Ultra
it should have about 4500 Turns.
my Problems are for example that i cant get the "Ultra" GameSpeed to show in the Setting Menue foer selection when you create a Game.

Here is the DataBase.Log

Spoiler Database.log :

[1762796.238] [Localization]: StartupErrorMessages.xml
[1762796.239] [Localization]: Input XML does not contain database entry tags. GameData, GameInfo or Database
[1762802.587] [Localization]: Validating Foreign Key Constraints...
[1762802.588] [Localization]: Passed Validation.
[1762802.719] [Configuration]: Validating Foreign Key Constraints...
[1762802.720] [Configuration]: Passed Validation.
[1762813.572] [FullTextSearch]: Initializing FullTextSearch
[1762815.192] [Gameplay]: Validating Foreign Key Constraints...
[1762815.219] [Gameplay]: Passed Validation.
[1762815.852] [Configuration] ERROR: no such table: Types
[1762815.852] [Configuration]: In Query - insert into Types('Type', 'Kind') values (?, ?);
[1762815.852] [Configuration]: In XMLSerializer while updating table Types from file GameSpeed.xml.
[1762816.545] [Configuration]: Validating Foreign Key Constraints...
[1762816.546] [Configuration]: Passed Validation.
[1762818.414] [HallofFame]: Database found. Checking versions...
[1762818.427] [HallofFame]: Database is up-to-date!
[1762846.242] [FullTextSearch]: FTS - Creating Context

Here the Modinfo:

Spoiler Modinfo :

<?xml version="1.0" encoding="utf-8"?>
<Mod id="c692f32b-0c66-4c05-a53f-af709dde37f0" version="1">
<Properties>
<Name>GameSpeedUltra</Name>
<Description>This is a brief description of the mod.</Description>
<Teaser>This is a brief description of the mod.</Teaser>
<Authors>mille</Authors>
<CompatibleVersions>1.2,2.0</CompatibleVersions>
</Properties>
<FrontEndActions>
<UpdateDatabase id="GameSpeed">
<File>GameSpeed.xml</File>
</UpdateDatabase>
<UpdateText id="GameSpeedText">
<File>GameSpeed_Text.xml</File>
</UpdateText>
</FrontEndActions>
<InGameActions>
<UpdateDatabase id="GameSpeed">
<File>GameSpeed.xml</File>
</UpdateDatabase>
</InGameActions>
<Files>
<File>GameSpeed.xml</File>
<File>GameSpeed_Text.xml</File>
</Files>
</Mod>

Here the XML files:

Spoiler GameSpees.xml :

<?xml version="1.0" encoding="utf-8"?>
<!-- GameData1 -->
<!-- Author: mille -->
<!-- DateCreated: 4/26/2019 5:03:14 AM -->

<GameData>
<Types>
<Row>
<Type>GAMESPEED_ULTRA</Type>
<Kind>KIND_GAMESPEED</Kind>
</Row>
</Types>
<GameSpeeds>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<Name>LOC_GAMESPEED_ULTRA_NAME</Name>
<Description>LOC_GAMESPEED_ULTRA_HELP</Description>
<CostMultiplier>450</CostMultiplier>
<CivicUnlockMaxCost>450</CivicUnlockMaxCost>
<CivicUnlockPerTurnDrop>45</CivicUnlockPerTurnDrop>
<CivicUnlockMinCost>90</CivicUnlockMinCost>
</Row>
</GameSpeeds>
<GameSpeed_Turns>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>140</MonthIncrement>
<TurnsPerIncrement>150</TurnsPerIncrement>
</Row>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>100</MonthIncrement>
<TurnsPerIncrement>400</TurnsPerIncrement>
</Row>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>50</MonthIncrement>
<TurnsPerIncrement>250</TurnsPerIncrement>
</Row>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>20</MonthIncrement>
<TurnsPerIncrement>270</TurnsPerIncrement>
</Row>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>10</MonthIncrement>
<TurnsPerIncrement>180</TurnsPerIncrement>
</Row>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>5</MonthIncrement>
<TurnsPerIncrement>280</TurnsPerIncrement>
</Row>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>3</MonthIncrement>
<TurnsPerIncrement>370</TurnsPerIncrement>
</Row>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>1</MonthIncrement>
<TurnsPerIncrement>250</TurnsPerIncrement>
</Row>
</GameSpeed_Turns>
</GameData>

Spoiler GameSpeed_Text.xml :

<?xml version="1.0" encoding="utf-8"?>
<!-- GameSpeed_Text -->
<!-- Author: mille -->
<!-- DateCreated: 4/26/2019 10:55:21 AM -->
<GameData>
<LocalizedText>
<Row Tag="LOC_GAMESPEED_ULTRA_NAME" Language="de_DE">
<Text>Ultra</Text>
</Row>
<Row Tag="LOC_GAMESPEED_ULTRA_HELP" Language="de_DE">
<Text>Still in Development</Text>
</Row>
</LocalizedText>
</GameData>

Ok t guess that are all the Files,
Perhaps someone has an Idea,
Thank You

 

[LeeS]

No file that is loaded via an UpdateDatabase type action in the FrontEndActions can also be loaded via an UpdateDatabase type action in the InGameActions, and vice versa. These two databases are mutually exclusive to each other. This is why you are getting this error:

[1762815.852] [Configuration] ERROR: no such table: Types
 [1762815.852] [Configuration]: In Query - insert into Types('Type', 'Kind') values (?, ?);
 [1762815.852] [Configuration]: In XMLSerializer while updating table Types from file GameSpeed.xml.

Table <Types> is not valid in FrontEndActions.

If we look in the Schema folder at C:\Program Files (x86)\Steam\SteamApps\common\Sid Meier's Civilization VI\Base\Assets\Configuration\Data\Schema we find a file called AdditionalTables.sql, which contains this definition of a table called GameSpeeds which defines what can be used in that table-name for FrontEndActions:

CREATE TABLE 'GameSpeeds' (
	'Domain' TEXT NOT NULL DEFAULT 'StandardGameSpeeds',
	'GameSpeedType' TEXT NOT NULL,
	'Name' TEXT,
	'Description' TEXT,
	'SortIndex' INTEGER NOT NULL,
	PRIMARY KEY('Domain', 'GameSpeedType')
);

There is a second similarly-named but different table called GameSpeeds that is used in InGameActions, and which has the following definition

CREATE TABLE "GameSpeeds" (
		"GameSpeedType" TEXT NOT NULL,
		"Name" TEXT,
		"Description" TEXT,
		"CostMultiplier" INTEGER NOT NULL DEFAULT 100,
		"CivicUnlockMaxCost" INTEGER NOT NULL,
		"CivicUnlockPerTurnDrop" INTEGER NOT NULL,
		"CivicUnlockMinCost" INTEGER NOT NULL,
		PRIMARY KEY(GameSpeedType));

This definition is found in file 01_GameplaySchema.sql at folder location C:\Program Files (x86)\Steam\SteamApps\common\Sid Meier's Civilization VI\Base\Assets\Gameplay\Data\Schema

In order to add a new GameSpeed to the game, you must include correct data in both the FrontEndActions and the InGameActions, and the same file cannot be used for both "ends" of the game. You must have two different files.

 

[LeeS]

Everyone gets these error messages

[1715143.606] [Localization]: StartupErrorMessages.xml
[1715143.606] [Localization]: Input XML does not contain database entry tags. GameData, GameInfo or Database
[1715159.474] [Localization]: Validating Foreign Key Constraints...
[1715159.475] [Localization]: Passed Validation.

They are caused by a Firaxis-oops induced a few patches ago which they've never fixed as yet. They're pretty much meaningless anyway and you can certainly ignore them since they have nothing at all to do with any mod.

 

[MR.Pat]

Thank you LeeS thar was very Helpfull,i guess i got it running now, i will Upload it later

 

[MR.Pat]

Ok Like i sad i think i got it kind of Running, its an Start i think, but i not right sure here are the Files

Spoiler ModInfo :

<?xml version="1.0" encoding="utf-8"?>
<Mod id="c692f32b-0c66-4c05-a53f-af709dde37f0" version="1">
<Properties>
<Name>GameSpeedUltra</Name>
<Description>This is a brief description of the mod.</Description>
<Teaser>This is a brief description of the mod.</Teaser>
<Authors>mille</Authors>
<CompatibleVersions>1.2,2.0</CompatibleVersions>
</Properties>
<FrontEndActions>
<UpdateDatabase id="GameSpeed">
<File>GameSpeed.xml</File>
</UpdateDatabase>
<UpdateText id="GameSpeedText">
<File>GameSpeed_Text.xml</File>
</UpdateText>
</FrontEndActions>
<InGameActions>
<UpdateDatabase id="Config">
<File>GameSpeedConfig.xml</File>
</UpdateDatabase>
<UpdateText id="GameSpeedText">
<File>GameSpeed_Text.xml</File>
</UpdateText>
</InGameActions>
<Files>
<File>GameSpeed.xml</File>
<File>GameSpeedConfig.xml</File>
<File>GameSpeed_Text.xml</File>
</Files>
</Mod>

Spoiler GameSpeed.xml :

<?xml version="1.0" encoding="utf-8"?>
<!-- GameData1 -->
<!-- Author: mille -->
<!-- DateCreated: 4/26/2019 5:03:14 AM -->

<GameInfo>


<GameSpeeds>
<Replace GameSpeedType="GAMESPEED_ULTRA" Name="LOC_GAMESPEED_ULTRA_NAME" Description="LOC_GAMESPEED_ULTRA_HELP" SortIndex="60" />
</GameSpeeds>

</GameInfo>

Spoiler GameSpeed_Text.xml :

<?xml version="1.0" encoding="utf-8"?>
<!-- GameSpeed_Text -->
<!-- Author: mille -->
<!-- DateCreated: 4/26/2019 10:55:21 AM -->
<GameData>
<LocalizedText>
<Row Tag="LOC_GAMESPEED_ULTRA_NAME" Language="de_DE">
<Text>Ultra</Text>
</Row>
<Row Tag="LOC_GAMESPEED_ULTRA_NAME" Language="en_US">
<Text>Ultra</Text>
</Row>
<Row Tag="LOC_GAMESPEED_ULTRA_HELP" Language="de_DE">
<Text>In Entwicklung (2150 Runden) </Text>
</Row>
<Row Tag="LOC_GAMESPEED_ULTRA_HELP" Language="en_US">
<Text>In Development (2150 Turns) </Text>
</Row>
</LocalizedText>
</GameData>

Spoiler GameSpeedConfig.xml :

<?xml version="1.0" encoding="utf-8"?>
<!-- GameData1 -->
<!-- Author: mille -->
<!-- DateCreated: 4/29/2019 11:08:20 PM -->
<GameData>
<Types>
<Row Type="GAMESPEED_ULTRA" Kind="KIND_GAMESPEED"/>
<Row Type="ULTRA_HALF" Kind="KIND_GAMESPEED_SCALING"/>
</Types>

<GameSpeeds>
<Row GameSpeedType="GAMESPEED_ULTRA" Name="LOC_GAMESPEED_ULTRA_NAME" Description="LOC_GAMESPEED_ULTRA_HELP" CostMultiplier="450" CivicUnlockMaxCost="450" CivicUnlockPerTurnDrop="45" CivicUnlockMinCost="90"/>
</GameSpeeds>


<GameSpeed_Turns>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>140</MonthIncrement>
<TurnsPerIncrement>150</TurnsPerIncrement>

</Row>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>100</MonthIncrement>
<TurnsPerIncrement>400</TurnsPerIncrement>

</Row>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>50</MonthIncrement>
<TurnsPerIncrement>250</TurnsPerIncrement>

</Row>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>20</MonthIncrement>
<TurnsPerIncrement>270</TurnsPerIncrement>

</Row>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>10</MonthIncrement>
<TurnsPerIncrement>180</TurnsPerIncrement>

</Row>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>5</MonthIncrement>
<TurnsPerIncrement>280</TurnsPerIncrement>

</Row>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>3</MonthIncrement>
<TurnsPerIncrement>370</TurnsPerIncrement>

</Row>
<Row>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<MonthIncrement>1</MonthIncrement>
<TurnsPerIncrement>250</TurnsPerIncrement>

</Row>
</GameSpeed_Turns>

<GameSpeed_Scalings>
<Row>
<GameSpeedScalingType>ULTRA_HALF</GameSpeedScalingType>
<GameSpeedType>GAMESPEED_ULTRA</GameSpeedType>
<ScalingType>SCALING_HALF</ScalingType>
<DefaultCostMultiplier>300</DefaultCostMultiplier>
</Row>
</GameSpeed_Scalings>

<GameSpeed_Durations>
<Row>
<GameSpeedScalingType>ULTRA_HALF</GameSpeedScalingType>
<NumberOfTurnsOnStandard>5</NumberOfTurnsOnStandard>
<NumberOfTurnsScaled>20</NumberOfTurnsScaled>
</Row>
<Row>
<GameSpeedScalingType>ULTRA_HALF</GameSpeedScalingType>
<NumberOfTurnsOnStandard>10</NumberOfTurnsOnStandard>
<NumberOfTurnsScaled>30</NumberOfTurnsScaled>
</Row>
<Row>
<GameSpeedScalingType>ULTRA_HALF</GameSpeedScalingType>
<NumberOfTurnsOnStandard>15</NumberOfTurnsOnStandard>
<NumberOfTurnsScaled>40</NumberOfTurnsScaled>
</Row>
<Row>
<GameSpeedScalingType>ULTRA_HALF</GameSpeedScalingType>
<NumberOfTurnsOnStandard>30</NumberOfTurnsOnStandard>
<NumberOfTurnsScaled>80</NumberOfTurnsScaled>
</Row>
<Row>
<GameSpeedScalingType>ULTRA_HALF</GameSpeedScalingType>
<NumberOfTurnsOnStandard>60</NumberOfTurnsOnStandard>
<NumberOfTurnsScaled>150</NumberOfTurnsScaled>
</Row>
</GameSpeed_Durations>

</GameData>

I think it still needs alot of Balancing but i Works somwhow