Page 1 of 1

Server Error after updated to rev.3051 last night

Posted: Mon Mar 18, 2013 1:28 pm
by Silverwolf
Hey I need some help please. I updated my server last night with the auto updater last night to the newest rev.3051 from .2840 and now game server crashes when I start up. here is the screen shot

Image


Thanks

Silverwolf

Re: Server Error after updated to rev.3051 last night

Posted: Mon Mar 18, 2013 1:41 pm
by kjLotus
update your db tables

spell_list and item_weapon specifically for those

Re: Server Error after updated to rev.3051 last night

Posted: Mon Mar 18, 2013 1:47 pm
by Silverwolf
Whats the best way to do that? I havent had to do it that way before.......

Re: Server Error after updated to rev.3051 last night

Posted: Mon Mar 18, 2013 2:20 pm
by kjLotus
how do you normally update your db tables?

Re: Server Error after updated to rev.3051 last night

Posted: Mon Mar 18, 2013 2:34 pm
by Silverwolf
I have been using this DSPServerUpdater

Re: Server Error after updated to rev.3051 last night

Posted: Mon Mar 18, 2013 2:35 pm
by Silverwolf
Isn't also possible to right click on the file and select svn update?

Re: Server Error after updated to rev.3051 last night

Posted: Mon Mar 18, 2013 2:38 pm
by kjLotus
Silverwolf wrote:Isn't also possible to right click on the file and select svn update?
for core and scripts, yeah

.sql files aren't actually read by anything, and are only a long series of commands that are executed when the script is run

i don't know how DSPServerUpdater works, but you'll have to rerun those .sql files to update your database

Re: Server Error after updated to rev.3051 last night

Posted: Mon Mar 18, 2013 2:52 pm
by Silverwolf
I remember Whasf directing me through this before, but I don't remember how to do it :( Damn.....

Re: Server Error after updated to rev.3051 last night

Posted: Mon Mar 18, 2013 2:53 pm
by kjLotus
same way as when you installed it - reread the install guide on how to set up the db :p

Re: Server Error after updated to rev.3051 last night

Posted: Mon Mar 18, 2013 3:44 pm
by Silverwolf
That seemed to do the trick. I forgot to execute batch after updating tables. Thanks for your help.