I added 2 city-states, it's messed up existing ones

[pokiehl]

Hi all,

I've added two city states via mod (one trade and one religious). The icons and everything show up properly, but e xisting city states get messed up. For example, Brussels appears in-game with an all-white background instead of black, and no text or icon. It changes every game. I have no idea what's wrong since there are no database errors.

The only weird thing about this mod is that instead of one atlas with 2 icons, I had to make 2 atlases with 1 icon each since I don't know how to add icons to rows. Not sure if that would affect it though.

Anyone ever seen this before?

 

[thecrazyscot]

I think what may be causing that is some missing commas in your PortRoyal.sql file (lines 60 and 71 at least). These are preventing the correct colors from loading for Port Royal, and my initial experiments indicated that could have cascading effects on random other CS colors. Make sure there are no syntax errors in both of your files and then give it a go.

 

[thecrazyscot]

Also, to make a larger icon atlas you just need to expand the initial canvas size. So instead of a 256x256 canvas for a single icon you make a 512x256 canvas for two, 768x256 for three, etc. Then create a grid of 256x256 boxes for your icons to go in. After making your icons, delete the grid and export.

 

[pokiehl]

Thanks a lot TCS! As you could tell from the mod, it heavily borrows from your mod (I think I mentioned that to you on Steam as well ). If I can get this working and upload it, I'll definitely credit you in the SpecialThanks for your help. You and your mods are awesome.

I'll fix the comma issue and see if that helps. BTW one more thing I noticed that was different from my mod and yours -- yours generates a .DEP file. Granted, I haven't created ArtDefs yet, but should ModBuddy be creating .DEP for me just based on my Icon XLP?

 

[thecrazyscot]

Thank you

No, I wouldn't worry about the .dep file until you create the ArtDefs.

 

[pokiehl]

Thank you

No, I wouldn't worry about the .dep file until you create the ArtDefs.

Man, you have eagle eyes! The comma issue seems to have fixed everything! What's weird is the database.log and SQLite didn't present any errors despite that.

Thanks again for your help man! I really, really appreciate it! I was slamming my head against the wall for like 6 hours over this.

 

[thecrazyscot]

Sometimes another pair of eyes is all it takes!

 

[LeeS]

You were getting an error. Database.log

[731288.201] [Gameplay] ERROR: near "(": syntax error

Modding.log

[731288.199] Status: UpdateDatabase - Loading Database/PortRoyal.sql
[731288.201] Warning: UpdateDatabase - Error Loading SQL.

Since SQL files only throw one error line into Database.log for a syntax error they're easy to miss.

 

[pokiehl]

You were getting an error. Database.log

[731288.201] [Gameplay] ERROR: near "(": syntax error

Modding.log

[731288.199] Status: UpdateDatabase - Loading Database/PortRoyal.sql
[731288.201] Warning: UpdateDatabase - Error Loading SQL.

Since SQL files only throw one error line into Database.log for a syntax error they're easy to miss.

Thanks LeeS! I'll be more careful about checking the logs. I really appreciate your help.