Deprecated Darkstar fourms

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

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...

msulli1355 wrote: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

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

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.

msulli1355 wrote: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

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

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

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