Server update help needed please

[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 ?

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

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

[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

[Virtualchronos]

thanks

is this really usefull ? and should I really update this ?

I updated char_exp and char_jobs

did I missed something else ?