Classic help thread

SonOfGreatKoya

SonOfGreatKoya

Warlord
Joined
Feb 4, 2016
Messages
110
Location
Kintelan Caliphate
So, despite all of my troubleshooting, my mod didn't appeared. I need help to find the error. Anyone have spare time? Here's the Database.log

[20039.576] columns StrategicViewType, TileType are not unique
[20039.576] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[20045.894] no such table: ContentPackage.LocalizedText
[20045.894] no such table: ContentPackage.LocalizedText
[20045.894] no such table: ContentPackage.LocalizedText
[20048.218] no such table: ContentPackage.LocalizedText
[20055.363] columns StrategicViewType, TileType are not unique
[20055.363] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[20057.438] no such table: ContentPackage.LocalizedText
[20057.438] no such table: ContentPackage.LocalizedText
[20057.438] no such table: ContentPackage.LocalizedText
[20070.355]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 8555064 78221872
PageCache: 6 12
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 8133216 65347968
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 6
------------------------------
[20071.556]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 8556240 78221872
PageCache: 6 12
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 8134392 65347968
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 6
------------------------------
[20212.113]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 8583280 78221872
PageCache: 7 13
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 8156736 65347968
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 8
------------------------------
Click to expand...
I can attach the project folder if needed
Thanks
 
  1. This is what you have as the definition of your civ:
    Code: 
    <Civilizations>
	<Row>
		<Type>CIVILIZATON_SOGK_DEMAK</Type>
    Which does not match with everywhere else you are refering to the civilization, like here:
    Code: 
    <Row>
	<CivilizationType>CIVILIZATION_SOGK_DEMAK</CivilizationType>
	<CityName>TXT_KEY_CITY_SOGK_DEMAK_1</CityName>
</Row>
  2. This may make it more obvioous:
    Code: 
    	                   CIVILIZATON_SOGK_DEMAK
	<CivilizationType>CIVILIZATION_SOGK_DEMAK</CivilizationType>
	<CityName>TXT_KEY_CITY_SOGK_DEMAK_1</CityName>
  3. You are missing an 'I' here:
    Code: 
    <Civilizations>
	<Row>
		<Type>CIVILIZAT[color="red"][B]I[/B][/color]ON_SOGK_DEMAK</Type>
Also, when looking for errors related to your mod's xml or sql code, the 1st place to look is in the Database.log -- you have quite a few more errors there that are related to not having a TXT_KEY defined anywhere within your two Text files.

I almost never look in the xml.log, and then only to find errors related to characters within TXT_KEY names the game doesn't like, or characters within the <Text> fields the game does not like.
 
So, this is because I miss an 'I'...[pissed]
Anyway, thanks. And yes, I didn't look at xml.log before. It didn't show any error
 
SonOfGreatKoya said:
So, this is because I miss an 'I'...[pissed]
Anyway, thanks. And yes, I didn't look at xml.log before. It didn't show any error
Click to expand...
Are you sure you have error logging turned on, then, because I got a Boatload of errors in the Database.log when I ran your mod? All stemming from the "no I" and some from not having all the TXT_KEYS defined within your Text files.

Double-Check you did the procedure correctly: whoward69's enable error logging tutorial

Also, if you re-'Build' your mod in modbuddy, this makes an updated copy of the mod in the game's MODS folder, but it also un-enables the mod in the Mods Menu, so you have to re-enable the mod.
 
Yeah, I miss ValidateGameDatabase. My test game can show my civ, but take forever to load game if I play using mine.
There's still some that i can't understand tho
[13342.687] Validating Foreign Key Constraints...
[13342.687] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[13342.687] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[13342.687] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[13342.687] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[13342.687] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[13342.687] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[13342.687] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[13342.687] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[13342.687] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[13347.180] Failure to check references for foreign key Units(PolicyType).
[13347.180] no such table: PolicyTypes
[13347.180] Failed Validation.
[13348.350]
Click to expand...
What does that means?
 
Have you checked the Database.log before trying to test this mod?
Spoiler :
(This means: Enable all mods you need for testing your mod, but don't enable your mod yet. Start up a game and check the Database.log (you can copy this to a word document or something). Everything that appears here isn't caused by your mod. Now exit back the the main menu and do all the steps I described previously, but this time enable your mod as well. Any new error messages in the Database.log now? --> those are caused by your mod.) (Don't forget to refresh the database.log file by pressing <F5> or by closing and reopening the file)

About the database.log in your post above: The "[13342.687] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes" are normal I guess, since they appear in my database.log every time, even without enabling mods. I'm not sure about the 'no such table: PolicyTypes', it has never appeared in my logs.
 
It's usually a Firaxian error, you can probably ignore it. BUT it can hide real problems. You'll need to edit one of the core files to fix it
 
You must log in or register to reply here.

Similar threads

C
I need help. An unknown error has occured and it crashes the game..
Replies
1
Views
452
CuteManiac
C
R
Simple tutorial-mod won't work (already tried common stuff)
Replies
2
Views
801
LeeS
LeeS
F
[BNW] I was hoping for some help with trying to create a religion mod
Replies
4
Views
954
FussyBadger
F
L
Problem with debugging simple civilzation mod
Replies
1
Views
2K
Lyokoheros
L
nguyenforthewin13
[BNW] Civs crash scenario, but problem unidentifiable through logs
Replies
2
Views
806
nguyenforthewin13
nguyenforthewin13
Top Bottom