Database log file produces errors from clean install

Watiggi · Oct 4, 2010

The Database log file produces these error messages. Note that this is from a clean install, with no modding done what so ever. For the record, I use Win 7 64 bit. I would LOVE some answers please.

Spoiler :

edit: I've added an attachment of the entire log folder. Hopefully someone can make sense of why it is happening, given that it doesn't seem to be happening to anyone else. The game itself (afaik) works fine.

I'm wondering whether the Localization.log errors have anything to do with it.

The_J · Oct 4, 2010

Try to clear the civ5 cache and check the integrity of teh files (there should be somewhere an option for this in steam).

Watiggi · Oct 4, 2010

Ok. I deleted the cache and then did the integrity check (off of a fresh install from the disk mind you!)

First, it said that one file failed the integrity check. Second, it then downloaded the file. Third, it STILL fails the integrity check (and preceeds to download it again!).

Afterwards, I started the game and it produced the same database log file results as above.

Spoiler :

Seriously, how ridiculous can it get when the DISK has integrity issues with the game files >.<

edit: btw, the [1865.350] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
entry will disapear the next time I run the game, bringing me back to where I started at.

magzhi · Oct 5, 2010

I have same problem and I am also using Win 7 64 bit.

Watiggi · Oct 6, 2010

Interesting.... I might make another thread in the modders section asking for Win 7 64 bit users to look at there Database log file to see if it's corrupted.

I'll report the results here.

JammerK · Jun 18, 2011

I have a similar problem running a vanilla game - NO mods. I am current under steam with all DLCs installed. Please tell me how to clear the cache. There are 2 subfolders under folder cache that are empty (downloads & images), but in the cache folder itself are several database files. Do I delete those?

btw, the DB log on a vanilla game launch is as follows;

[48206.321] constraint failed
[48206.321] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[48210.751] Validating Foreign Key Constraints...
[48210.767] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[48210.767] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[48210.767] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
[48212.046] Failed Validation.
[48212.592]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 287120 2359896
PageCache: 4128 4332
LookAside: 45 1840
Scratch: 0 1

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

Largest Allocations:
Malloc: 65280
PageCache: 1160
Scratch: 6640

Prepared Statements:
Current: 5
------------------------------

Database log file produces errors from clean install

Watiggi

Deity

Attachments

The_J

Say No 2 Net Validations

Watiggi

Deity

magzhi

Warlord

Watiggi

Deity

JammerK

Chieftain

Similar threads