City-State Mod

Bonyduck Campersang

The Anti Amadeus
Joined
Dec 11, 2022
Messages
4,290
I'm seeing this in the log from my city-state mod but I can't understand what they mean and how do I go about fixing it. The XML files look alright to me


Code:
[853.859] column Type is not unique
[853.859] While executing - 'insert into MinorCivilizations('Type', 'Description', 'ShortDescription', 'Adjective', 'Civilopedia', 'DefaultPlayerColor', 'ArtDefineTag', 'ArtStyleType', 'ArtStyleSuffix', 'ArtStylePrefix', 'MinorCivTrait') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);'
[853.859] In XMLSerializer while inserting row into table insert into MinorCivilizations('Type', 'Description', 'ShortDescription', 'Adjective', 'Civilopedia', 'DefaultPlayerColor', 'ArtDefineTag', 'ArtStyleType', 'ArtStyleSuffix', 'ArtStylePrefix', 'MinorCivTrait') with  values (MINOR_CIV_MUSASIR, TXT_KEY_CITYSTATE_MUSASIR, TXT_KEY_CITYSTATE_MUSASIR, TXT_KEY_CITYSTATE_MUSASIR_ADJ, TXT_KEY_CITYSTATE_MUSASIR_PEDIA, PLAYERCOLOR_MINOR_MUSASIR, ART_DEF_CIVILIZATION_MINOR, ARTSTYLE_MIDDLE_EAST, _AFRI, AFRICAN, MINOR_TRAIT_RELIGIOUS, ).
[853.859] In XMLSerializer while updating table MinorCivilizations from file Musasir.xml.
[853.859] column Type is not unique
[855.781] column Type is not unique
[855.781] While executing - 'insert into MinorCivilizations('Type', 'Description', 'ShortDescription', 'Adjective', 'Civilopedia', 'DefaultPlayerColor', 'ArtDefineTag', 'ArtStyleType', 'ArtStyleSuffix', 'ArtStylePrefix', 'MinorCivTrait') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);'
[855.781] In XMLSerializer while inserting row into table insert into MinorCivilizations('Type', 'Description', 'ShortDescription', 'Adjective', 'Civilopedia', 'DefaultPlayerColor', 'ArtDefineTag', 'ArtStyleType', 'ArtStyleSuffix', 'ArtStylePrefix', 'MinorCivTrait') with  values (MINOR_CIV_SHUSHA, TXT_KEY_CITYSTATE_SHUSHA, TXT_KEY_CITYSTATE_SHUSHA, TXT_KEY_CITYSTATE_SHUSHA_ADJ, TXT_KEY_CITYSTATE_SHUSHA_PEDIA, PLAYERCOLOR_MINOR_SHUSHA, ART_DEF_CIVILIZATION_MINOR, ARTSTYLE_MIDDLE_EAST, _AFRI, AFRICAN, MINOR_TRAIT_CULTURED, ).
[855.781] In XMLSerializer while updating table MinorCivilizations from file Barda.xml.
 

Attachments

  • Yet Another City-States Pack (v 2).zip
    147.5 KB · Views: 21
So in Barda.xml the Type for Minor Civilizations was set to MINOR_CIV_SHUSHA, which conflicts with Shusha.xml. However I can't find another instance of <Type>MINOR_CIV_MUSASIR</Type> outside of Musasir.xml, even though the error is the same. I'll return to this later
 
Musasir.xml has two separate UpdateDatabase actions trying to load it:

Spoiler :

<OnModActivated>
<UpdateDatabase>Abu-Dhabi.xml</UpdateDatabase>
<UpdateDatabase>Amman.xml</UpdateDatabase>
<UpdateDatabase>Aror.xml</UpdateDatabase>
<UpdateDatabase>Calabar.xml</UpdateDatabase>
<UpdateDatabase>Derbent.xml</UpdateDatabase>
<UpdateDatabase>Dunbar.xml</UpdateDatabase>
<UpdateDatabase>Gangtok.xml</UpdateDatabase>
<UpdateDatabase>Irqata.xml</UpdateDatabase>
<UpdateDatabase>Pushkalavati.xml</UpdateDatabase>
<UpdateDatabase>Sagala.xml</UpdateDatabase>
<UpdateDatabase>Tamralipta.xml</UpdateDatabase>
<UpdateDatabase>Amida.xml</UpdateDatabase>
<UpdateDatabase>Colours.xml</UpdateDatabase>
<UpdateDatabase>PlayerColours.xml</UpdateDatabase>
<UpdateDatabase>Arzashkun.xml</UpdateDatabase>
<UpdateDatabase>Dubai.xml</UpdateDatabase>
<UpdateDatabase>Dushanbe.xml</UpdateDatabase>
<UpdateDatabase>Hisar.xml</UpdateDatabase>
<UpdateDatabase>Hulbuk.xml</UpdateDatabase>
<UpdateDatabase>Krokola.xml</UpdateDatabase>
<UpdateDatabase>Osh.xml</UpdateDatabase>
<UpdateDatabase>Port Royal.xml</UpdateDatabase>
<UpdateDatabase>Tushpa.xml</UpdateDatabase>
<UpdateDatabase>Sugunia.xml</UpdateDatabase>
<UpdateDatabase>Arzen.xml</UpdateDatabase>
<UpdateDatabase>Carcathiocerta.xml</UpdateDatabase>
<UpdateDatabase>Musasir.xml</UpdateDatabase>
<UpdateDatabase>Mylasa.xml</UpdateDatabase>
<UpdateDatabase>Sardis.xml</UpdateDatabase>
<UpdateDatabase>Shaki.xml</UpdateDatabase>
<UpdateDatabase>Teishebaini.xml</UpdateDatabase>
<UpdateDatabase>Korla.xml</UpdateDatabase>
<UpdateDatabase>Kharberd.xml</UpdateDatabase>
<UpdateDatabase>Ura.xml</UpdateDatabase>
<UpdateDatabase>Ubbumu.xml</UpdateDatabase>
<UpdateDatabase>Shamakhi.xml</UpdateDatabase>
<UpdateDatabase>Ganja.xml</UpdateDatabase>
<UpdateDatabase>Agsu.xml</UpdateDatabase>
<UpdateDatabase>Aqsu.xml</UpdateDatabase>
<UpdateDatabase>Uch.xml</UpdateDatabase>
<UpdateDatabase>Isin.xml</UpdateDatabase>
<UpdateDatabase>ReplaceBelgrade.xml</UpdateDatabase>
<UpdateDatabase>ReplaceBudapest.xml</UpdateDatabase>
<UpdateDatabase>ReplaceHanoi.xml</UpdateDatabase>
<UpdateDatabase>ReplaceTbilisi.xml</UpdateDatabase>
<UpdateDatabase>ReplaceKabul.xml</UpdateDatabase>
<UpdateDatabase>Artush.xml</UpdateDatabase>
<UpdateDatabase>Jabulqa.xml</UpdateDatabase>
<UpdateDatabase>Jabulsa.xml</UpdateDatabase>
<UpdateDatabase>Clevsin.xml</UpdateDatabase>
<UpdateDatabase>Perusna.xml</UpdateDatabase>
<UpdateDatabase>Veii.xml</UpdateDatabase>
<UpdateDatabase>Tarchuna.xml</UpdateDatabase>
<UpdateDatabase>Vulci.xml</UpdateDatabase>
<UpdateDatabase>Pyrgi.xml</UpdateDatabase>
<UpdateDatabase>Cisra.xml</UpdateDatabase>
<UpdateDatabase>Adria.xml</UpdateDatabase>
<UpdateDatabase>Spina.xml</UpdateDatabase>
<UpdateDatabase>Prosek.xml</UpdateDatabase>
<UpdateDatabase>Strumica.xml</UpdateDatabase>
<UpdateDatabase>Perinthus.xml</UpdateDatabase>
<UpdateDatabase>Stobi.xml</UpdateDatabase>
<UpdateDatabase>Bylazora.xml</UpdateDatabase>
<UpdateDatabase>Suakin.xml</UpdateDatabase>
<UpdateDatabase>Abuja.xml</UpdateDatabase>
<UpdateDatabase>Callao.xml</UpdateDatabase>
<UpdateDatabase>Debal.xml</UpdateDatabase>
<UpdateDatabase>Mytilene.xml</UpdateDatabase>
<UpdateDatabase>Kosice.xml</UpdateDatabase>
<UpdateDatabase>Myrmekion.xml</UpdateDatabase>
<UpdateDatabase>Text.xml</UpdateDatabase>
<UpdateDatabase>Musasir.xml</UpdateDatabase>
<UpdateDatabase>Asmara.xml</UpdateDatabase>
<UpdateDatabase>Barbarikon.xml</UpdateDatabase>
<UpdateDatabase>Bern.xml</UpdateDatabase>
<UpdateDatabase>Lankaran.xml</UpdateDatabase>
<UpdateDatabase>Nerik.xml</UpdateDatabase>
<UpdateDatabase>Uqair.xml</UpdateDatabase>
<UpdateDatabase>Dilmun.xml</UpdateDatabase>
<UpdateDatabase>Gerrha.xml</UpdateDatabase>
<UpdateDatabase>Hofuf.xml</UpdateDatabase>
<UpdateDatabase>Dammam.xml</UpdateDatabase>
<UpdateDatabase>Khobar.xml</UpdateDatabase>
<UpdateDatabase>Kuwait.xml</UpdateDatabase>
<UpdateDatabase>Manama.xml</UpdateDatabase>
<UpdateDatabase>Doha.xml</UpdateDatabase>
<UpdateDatabase>Ashgabat.xml</UpdateDatabase>
<UpdateDatabase>Polyrrhenia.xml</UpdateDatabase>
<UpdateDatabase>Pergamon.xml</UpdateDatabase>
<UpdateDatabase>Elaea.xml</UpdateDatabase>
<UpdateDatabase>Pitane.xml</UpdateDatabase>
<UpdateDatabase>Nymphaion.xml</UpdateDatabase>
<UpdateDatabase>Madaba.xml</UpdateDatabase>
<UpdateDatabase>Gerasa.xml</UpdateDatabase>
<UpdateDatabase>Gwadar.xml</UpdateDatabase>
<UpdateDatabase>Naucratis.xml</UpdateDatabase>
<UpdateDatabase>Lothal.xml</UpdateDatabase>
<UpdateDatabase>Charax Spasinu.xml</UpdateDatabase>
<UpdateDatabase>Dhahran.xml</UpdateDatabase>
<UpdateDatabase>Teredon.xml</UpdateDatabase>
<UpdateDatabase>Avan.xml</UpdateDatabase>
<UpdateDatabase>UmmQasr.xml</UpdateDatabase>
<UpdateDatabase>RasTanura.xml</UpdateDatabase>
<UpdateDatabase>Jeddah.xml</UpdateDatabase>
<UpdateDatabase>Douala.xml</UpdateDatabase>
<UpdateDatabase>Dakar.xml</UpdateDatabase>
<UpdateDatabase>Saint-Louis.xml</UpdateDatabase>
<UpdateDatabase>Mwanza.xml</UpdateDatabase>
<UpdateDatabase>Kisumu.xml</UpdateDatabase>
<UpdateDatabase>Ndajmena.xml</UpdateDatabase>
<UpdateDatabase>Khare.xml</UpdateDatabase>
<UpdateDatabase>Opar.xml</UpdateDatabase>
<UpdateDatabase>SriKstera.xml</UpdateDatabase>
<UpdateDatabase>Macau.xml</UpdateDatabase>
<UpdateDatabase>Qatna.xml</UpdateDatabase>
<UpdateDatabase>Apum.xml</UpdateDatabase>
<UpdateDatabase>Ebla.xml</UpdateDatabase>
<UpdateDatabase>Mari.xml</UpdateDatabase>
<UpdateDatabase>Carchemish.xml</UpdateDatabase>
<UpdateDatabase>Urshu.xml</UpdateDatabase>
<UpdateDatabase>Sura.xml</UpdateDatabase>
<UpdateDatabase>Pumbedita.xml</UpdateDatabase>
<UpdateDatabase>Nehardea.xml</UpdateDatabase>
<UpdateDatabase>Emar.xml</UpdateDatabase>
<UpdateDatabase>Kurda.xml</UpdateDatabase>
<UpdateDatabase>Andarig.xml</UpdateDatabase>
<UpdateDatabase>Razama.xml</UpdateDatabase>
<UpdateDatabase>Zahiran.xml</UpdateDatabase>
<UpdateDatabase>Mane.xml</UpdateDatabase>
<UpdateDatabase>Tuttul.xml</UpdateDatabase>
<UpdateDatabase>Arpad.xml</UpdateDatabase>
<UpdateDatabase>Terqa.xml</UpdateDatabase>
<UpdateDatabase>Shianu.xml</UpdateDatabase>
<UpdateDatabase>Ruhizzi.xml</UpdateDatabase>
<UpdateDatabase>Samal.xml</UpdateDatabase>
<UpdateDatabase>Zalpuwa.xml</UpdateDatabase>
<UpdateDatabase>Kampala.xml</UpdateDatabase>
<UpdateDatabase>Arwad.xml</UpdateDatabase>
<UpdateDatabase>Zobah.xml</UpdateDatabase>
<UpdateDatabase>Shusha.xml</UpdateDatabase>
<UpdateDatabase>Barda.xml</UpdateDatabase>
<UpdateDatabase>Hassum.xml</UpdateDatabase>
<UpdateDatabase>Irridu.xml</UpdateDatabase>
<UpdateDatabase>Kummanni.xml</UpdateDatabase>
<UpdateDatabase>Alalakh.xml</UpdateDatabase>
<UpdateDatabase>Kumme.xml</UpdateDatabase>
<UpdateDatabase>Jaffa.xml</UpdateDatabase>
<UpdateDatabase>Solnitsata.xml</UpdateDatabase>
<UpdateDatabase>Anhialos.xml</UpdateDatabase>
<UpdateDatabase>Perperikon.xml</UpdateDatabase>
<UpdateDatabase>Noreia.xml</UpdateDatabase>
<UpdateDatabase>Solona.xml</UpdateDatabase>
<UpdateDatabase>Tylis.xml</UpdateDatabase>
<UpdateDatabase>Timgad.xml</UpdateDatabase>
<UpdateDatabase>Adulis.xml</UpdateDatabase>
<UpdateDatabase>Qohaito.xml</UpdateDatabase>
<UpdateDatabase>Kubar.xml</UpdateDatabase>
<UpdateDatabase>Hubat.xml</UpdateDatabase>
<UpdateDatabase>Loulan.xml</UpdateDatabase>
<UpdateDatabase>Mangazeya.xml</UpdateDatabase>
<UpdateDatabase>Ekallatum.xml</UpdateDatabase>
<UpdateDatabase>Telja.xml</UpdateDatabase>
<UpdateDatabase>Quentovic.xml</UpdateDatabase>
<UpdateDatabase>Damasia.xml</UpdateDatabase>
<UpdateDatabase>Vineta.xml</UpdateDatabase>
<UpdateDatabase>Sybaris.xml</UpdateDatabase>
<UpdateDatabase>Dorestad.xml</UpdateDatabase>
<UpdateDatabase>Etzanoa.xml</UpdateDatabase>
<UpdateDatabase>Cadota.xml</UpdateDatabase>
<UpdateDatabase>Abaskun.xml</UpdateDatabase>
<UpdateDatabase>Yamatai.xml</UpdateDatabase>
<UpdateDatabase>Muziris.xml</UpdateDatabase>
<UpdateDatabase>Gibala.xml</UpdateDatabase>
<UpdateDatabase>Gidara.xml</UpdateDatabase>
<UpdateDatabase>Seri Bahlol.xml</UpdateDatabase>
<UpdateDatabase>Pasni.xml</UpdateDatabase>
<UpdateDatabase>Purushanda.xml</UpdateDatabase>
<UpdateDatabase>Pitassi.xml</UpdateDatabase>
<UpdateDatabase>Menouthias.xml</UpdateDatabase>
<UpdateDatabase>Rhapta.xml</UpdateDatabase>
<UpdateDatabase>Paus.xml</UpdateDatabase>
<UpdateDatabase>Atakpa.xml</UpdateDatabase>
<UpdateDatabase>Khambhat.xml</UpdateDatabase>
</OnModActivated>


You can match the timestamp of the database.log error up with the timestamps in stopwatch.log to see what file(s) the game was working on when it threw the error, and you'll see that the error is being thrown on the second UpdateDatabase call, because at that point it's trying to add a minor civ that's already been added the first time around.
 
Top Bottom