Page 1 of 1
Server update help needed please
Posted: Mon Apr 15, 2013 5:42 pm
by Virtualchronos
Due to a connection problem it's been nearly a month that I couldn't update my server. I tried a few days ago but since then I cannot use my server anymore. I've an error unknown column geo in field list and I should update many chars sql files but I don't qnow how to do it without losing my players data...
Can someone help me ?
Re: Server update help needed please
Posted: Mon Apr 15, 2013 6:21 pm
by whasf
Probably easier to go into NaviCat (or whatever program you're using for SQL) and modify the design of the table. Open the .sql file in Notepad and see what columns you need to add and where they should be.
Re: Server update help needed please
Posted: Mon Apr 15, 2013 10:21 pm
by Virtualchronos
unfortunately I'm a total noob in SQL and stuffs like this... the new core have made many updates and I don't have the list of the changes I must do...
Re: Server update help needed please
Posted: Mon Apr 15, 2013 11:14 pm
by joshr45
one of the changes that was made to the accounts.sql file was email and email2 column between password and timecreate
check if those 2 columns are in there, if not add them
Re: Server update help needed please
Posted: Wed Apr 17, 2013 12:28 pm
by Virtualchronos
thanks
is this really usefull ? and should I really update this ?
I updated char_exp and char_jobs
did I missed something else ?