DB ERROR

[greenieken]

this error comes out everytime i log my character..

if anyone of you knows the cause of this error, kindly help me. thanks!

[Emistry]

run this

trunk/sql-files/upgrades/upgrade_svn16518.sql

refer this Favorite_tab

please use search engine next time

[greenieken]

this comes out when i tried to run it using mysql workbench.

[BruceW]

check your table make sure it comes after expiry_time otherwise edit it....

you can choose to delete the field first then redo the command Emistry ask you to run...

Also do it only one time... it'll give you error if you run it twice hence duplicate...

last part of the fields should look like "....card0, card1, card2, card3, expire_time, favorite"

also re-run you sql and server.

Since your using workbench, it would be easy without command... go to ragnarok database, right click the inventory table, choose alter table...

from here delete the Column Name favorite, hit apply

then add it at the very last as a column Name, Datatype will be TINYINT(3) then tick the boxes NN and UN default will be '0', click apply again.

Edited December 14, 2012 by BruceW

[greenieken]

What i need to edit is just the SQL right? not the char.c anymore?

I did everything from executing the commands and by doing it manually. still the errors pops out. does my client causes that error? coz i am using 20100730 client exe

BUMP

[BruceW]

since error is pointing at the field, yes check the sql first

also you need to make sure your server and client has the same version....