Misc. DB errors. Which files to re-input

[msulli1355]

I've been away for several months. I updated to revision 2651 and rebuilt my servers today. I thought that I fed in all the new db files, but when I rebuilt my servers and ran dsgame, I see a whole bunch of these errors:

michael@carter /home/work/dsp $ ./dsgame
[Status] Memory manager initialised: log/DSP.leaks
[Info] DarkStar - onetimexi - SVN Revision: Unknown.
[Status] do_init: begin server initialization...
[16:12:39][Info] Console Silent Setting: 0 - [OK]
[16:12:39][Status] do_init: map_config is reading - [OK]
[16:12:39][Status] luautils::init:lua initializing... - [OK]
[16:12:39][Status] cmdhandler::init: initializing... - [OK]
[16:12:39][Status] do_init: sqlhandle is allocating - [OK]
[16:12:39][Status] do_init: zlib is reading - [OK]
[16:12:39][Status] do_init: loading items[16:12:39][SQL] DB error - Unknown column 'w.unlock_index' in 'field list'
[16:12:39][SQL] DB error - Table 'dspdb.item_latents' doesn't exist
- [OK]
[16:12:39][Status] do_init: loading spells[16:12:39][SQL] DB error - Table 'dspdb.blue_spell_list' doesn't exist
[16:12:39][SQL] DB error - Table 'dspdb.blue_spell_mods' doesn't exist
- [OK]
[16:12:39][SQL] DB error - Table 'dspdb.item_weapon_unlocked' doesn't exist
[16:12:39][SQL] DB error - Unknown column 'addType' in 'field list'
[16:12:39][SQL] DB error - Unknown column 'mob_family_system.HP' in 'field list'
[16:12:39][Status] do_init: loading zones[16:12:39][SQL] DB error - Unknown column 'animationsub' in 'field list'
[16:12:39][SQL] DB error - Unknown column 'animationsub' in 'field list'
[Several lines repeating the line immeditately above have been trimmed. - MAS]
[16:12:39][Debug] UpdateWeather Finished
- [OK]
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17649693> not found
[16:12:39][Debug] SpawnMob: mob <17649693> not found
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17645578> not found
[16:12:39][Debug] SpawnMob: mob <17645578> not found
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17240413> not found
[16:12:39][Debug] SpawnMob: mob <17240413> not found
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17490234> not found
[16:12:39][Debug] SpawnMob: mob <17490234> not found
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17289575> not found
[16:12:39][Debug] SpawnMob: mob <17289575> not found
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17244539> not found
[16:12:39][Debug] SpawnMob: mob <17244539> not found
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17244372> not found
[16:12:39][Debug] SpawnMob: mob <17244372> not found
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17408018> not found
[16:12:39][Debug] SpawnMob: mob <17408018> not found
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17596720> not found
[16:12:39][Debug] SpawnMob: mob <17596720> not found
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17596506> not found
[16:12:39][Debug] SpawnMob: mob <17596506> not found
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17596507> not found
[16:12:39][Debug] SpawnMob: mob <17596507> not found
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17269106> not found
[16:12:39][Debug] SpawnMob: mob <17269106> not found
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17297440> not found
[16:12:39][Debug] SpawnMob: mob <17297440> not found
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17228242> not found
[16:12:39][Debug] SpawnMob: mob <17228242> not found
[16:12:39][Debug] UpdateNMSpawnPoint: mob <17301537> not found
[16:12:39][Debug] SpawnMob: mob <17301537> not found
[16:12:39][Status] do_init: server is binding with port 54230 - [OK]
[16:12:39][Status] The map-server is ready to work...
=======================================================================
[16:12:39][Error] Transport <6>: transport or door not found
[16:12:39][Error] Transport <7>: transport or door not found

[msulli1355]

The most prominent error above was the one about animationsub repeated over and over. I did a brief search for that table:

michael@carter /home/work/dsp $ grep animationsub sql/*
sql/mob_pools.sql: `animationsub` tinyint(1) NOT NULL DEFAULT '0',
sql/npc_list.sql: `animationsub` tinyint(3) unsigned NOT NULL DEFAULT '0',


I fed those two files back into the database and restarted the server, but the errors persisted. Also, the second-from-top error in the listing references 'dspdb.item_latents' which to my understanding was removed from svn some time ago. Apparently something is still trying to use it...

[kjLotus]

Also, the second-from-top error in the listing references 'dspdb.item_latents' which to my understanding was removed from svn some time ago.

this is not the case

all of these errors are due to an out of date DB

[msulli1355]

So am I supposed to completely recreate my db every time I upgrade?

[PrBlahBlahtson]

When a table is updated, you can either create a query based on the diff, or just run the trunk's script that will recreate the table with the updated data.

Unless it starts with char_, or it's an accounts/linkshell table. Obviously, you need to be careful with those, and should be altering them by hand.

[kjLotus]

So am I supposed to completely recreate my db every time I upgrade?

every time a .sql changes, you have to rerun that file
or, in the case of character tables, most likely recreate the table by hand so you don't lose your characters

[bluekirby0]

or just learn mysql ALTER TABLE syntax. Google is your friend.

[kjLotus]

or just learn mysql ALTER TABLE syntax. Google is your friend.

that falls under what my definition of "by hand" was :p