My changes do not show up at all

[XTac]

Hey there. This is my first post here.

I want to be a modder. I really do. I have "basic" understanding of xmls, but no matter how much i have tried to do a mod (back then for civ 5, now for BE), it never worked. It never showed up any changes.

So i need help with making my mod work, and some "Lessons" about whole modding.
My mod consists of few .sql and .xml files, + dds. I am planning to do "European Union" mod.

Can someone help me?
Huge thanks for any post here!

Here is the mod itself: I am sure there are some big bugs, but i intend to fix them after i even get the modded civ to show up in the list.

Best Regards
XTac

 

[Nutty]

You're missing a bunch of the OnModActivated > UpdateDatabase entries in the mod's properties.

 

[XTac]

Well, i made UpdateDatabase entries for all files (both xml and sql), but still the same problem :/
But thanks for notice. I am sure that thing had a part in the problem.

 

[Nutty]

Did you check the database.log file?

 

[XTac]

No. But i have checked it now and here is the whole thing.
There is too much text, so i am just going to send the log by attachment.

 

[Nutty]

The first 2 errors referring to UNIQUE constraints mean that you're trying to add more than one entry with the same name.

GameText.xml: You've got a duplicate TXT_KEY_CIV_JFD_EU_4
Traits.xml: Don't add an <ID> or <rowID> tag unless you've already deleted the entry at that row. Just leave it out, and one will automatically be assigned.

The last one is a SQL error. Less helpful, because it doesn't say which file, but it's easy enough to use a SQLite browser and actually run your SQL code on the database.

In Civilizations.sql on line 40:

('CIVILIZATION_EU', 'TXT_KEY_CITY_NAME_EU_20'),

you need to end your command with a semicolon rather than a comma. Similarly with line 82.

 

[XTac]

Oh thats so helpful! Thank you so much ^^
I am going to apply those fixes and we shall see.

 

[XTac]

YES! It works! I can actually start the game as EU
However, there is problem with dds files. Civ logo does not appear correctly. Instead of my image, white-red checkerboard or some random stripes display.

But i am so happy Finally i see my mod working Big thanks!

 

[Nutty]

Your IconAtlas.sql has the same problem of not finishing your INSERT with a semicolon.

 

[XTac]

Thank you so much! All basic function work now.
Now i am just going to put the whole mod through bug testing, and i am going to release it on workshop. I am going to put your name in "Special thanks" section.

Again, thank you so much with helping in my first steps in Civ mod world ^^

 

[Nutty]

You're welcome! Congrats and good luck!