greenieken Posted December 14, 2012 Group: Members Topic Count: 54 Topics Per Day: 0.01 Content Count: 154 Reputation: 1 Joined: 05/02/12 Last Seen: June 5, 2020 Share Posted December 14, 2012 this error comes out everytime i log my character.. if anyone of you knows the cause of this error, kindly help me. thanks! Quote Link to comment Share on other sites More sharing options...
Emistry Posted December 14, 2012 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10017 Reputation: 2369 Joined: 10/28/11 Last Seen: Wednesday at 12:29 PM Share Posted December 14, 2012 run this trunk/sql-files/upgrades/upgrade_svn16518.sql refer this Favorite_tab please use search engine next time Quote Link to comment Share on other sites More sharing options...
greenieken Posted December 14, 2012 Group: Members Topic Count: 54 Topics Per Day: 0.01 Content Count: 154 Reputation: 1 Joined: 05/02/12 Last Seen: June 5, 2020 Author Share Posted December 14, 2012 this comes out when i tried to run it using mysql workbench. Quote Link to comment Share on other sites More sharing options...
BruceW Posted December 14, 2012 Group: Members Topic Count: 6 Topics Per Day: 0.00 Content Count: 29 Reputation: 0 Joined: 11/15/12 Last Seen: December 17, 2012 Share Posted December 14, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
greenieken Posted December 15, 2012 Group: Members Topic Count: 54 Topics Per Day: 0.01 Content Count: 154 Reputation: 1 Joined: 05/02/12 Last Seen: June 5, 2020 Author Share Posted December 15, 2012 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 Quote Link to comment Share on other sites More sharing options...
BruceW Posted December 16, 2012 Group: Members Topic Count: 6 Topics Per Day: 0.00 Content Count: 29 Reputation: 0 Joined: 11/15/12 Last Seen: December 17, 2012 Share Posted December 16, 2012 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.... Quote Link to comment Share on other sites More sharing options...
Question
greenieken
this error comes out everytime i log my character..
if anyone of you knows the cause of this error, kindly help me. thanks!
Link to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.