How does one track down XML reference problems? (No evidence in Database.log)

[Pazyryk]

It's a pretty basic question and I'm probably missing something really obvious. It seems to me that I should see these errors in Database.log (or some other log). However, these logs look identical when I run unmodded civ5 or a mod that I know has many, many missing references (because I stripped out the whole tech tree). I've pasted my Database.log below after running unmodded civ5. But it's absolutely identical when I run my tech stripped mod that should have dozens of missing references (and the time modified indicates that the file was re-written by my mod). So where do I look to track down these missing references?

[2873.569] Validating Foreign Key Constraints...
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_UNITEDSTATES" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_ARABIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_AZTECS" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_CHINA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_EGYPT" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_ENGLAND" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_FRANCE" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_GERMANY" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_GREECE" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_INDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_IROQUOIS" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_JAPAN" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_OTTOMAN" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_PERSIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_ROME" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_RUSSIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_SIAM" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_SONGHAI" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.CivilopediaTag - "TXT_KEY_CIV5_BABYLON" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_AMERICA_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_ARABIA_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_AZTEC_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_CHINA_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_EGYPT_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_ENGLAND_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_FRANCE_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_GERMANY_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_GREECE_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_INDIA_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_IROQUOIS_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_JAPAN_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_OTTOMAN_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_PERSIA_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_ROME_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_RUSSIA_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_SIAM_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_SONGHAI_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_MINOR_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_BARBARIAN_PEDIA" does not exist in Language_en_US
[2873.585] Invalid Reference on Civilizations.Civilopedia - "TXT_KEY_CIV_BABYLON_PEDIA" does not exist in Language_en_US
[2873.600] Invalid Reference on Feature_YieldChanges.FeatureType - "FEATURE_RIVER" does not exist in Features
[2873.600] Invalid Reference on Feature_YieldChanges.FeatureType - "FEATURE_LAKE" does not exist in Features
[2873.600] Invalid Reference on Feature_YieldChanges.FeatureType - "FEATURE_LAKE" does not exist in Features
[2873.616] Failed Validation.
[2873.990] 
-- SQLite Memory Statistics --
Memory Usage:
		[Cur]		[Max]
Malloc:		258312		2241200
PageCache:	2508		3480
LookAside:	26		1763
Scratch:	0		1

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

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

Prepared Statements:
Current:		3
------------------------------

 

[Laurino]

I'm having the same issue here, the log files always remain the same.

 

[SamBC]

Sounds like a general issue... I've never seen it vary, although I don't know for sure there are errors it's missing.

 

[salaminizer]

Kael said that these errors are from "legacy" stuff that is not used anymore.

I'm having similar problems because I can't track what's wrong with my files. certain changes in my mod (new civ and leader, new build type) appear in the database, but others (new units) are simply not there.

 

[Pazyryk]

I see. So until this is fixed, any xml modding is basically "blind modding." Try it. If it works, great. If not, it's your best guess as to the specific error...

Civ4 was not ideal, but you would get those xml loading errors during game start that at least told you where to look. I'll stay optimistic that some solution is coming in civ5.