I just got back from vacation and I wanted to update my server (Zebuxoruk), before I was at 7.800 and I went to 7.806. I'm using MySQL4 and plan on using that until the dev team switches to 5 (if they do). So I downloaded the new windows binaries as usual. Since i didn't know when if ever I would switch to mysql5 I went ahead and added those "compatability" lines of code in the log to SQL.
After I did all that I rebooted the server and all of my players were see'ing blank chracter select screens (the characters are still in the database just not showing up). I'm assuing it broke with the compatability.
Here are the lines I plugged in, anyone out there know enough SQL to reverse this?
ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT(
UNSIGNED NOT
NULL DEFAULT '0';
alter table account DROP packencrypt;
alter table character_ change extprofile extprofile blob NULL;
alter table player_corpses change data data blob NULL;
alter table player_corpses_backup change data data blob NULL;
Thanks for any help, if any of my playerbase sees this hop to
www.zebuxorukserver.com/forum (I'm working through this mess over there to keep you updated on when it will be back up)
Forgot to mention: My GM Account seems to work ok atleast my GM chracters always shows up and some of the other characters I've made for events show up (but not all of them) a lvl 85 my gm level 100 show up no other ones
MySQL5 Compatablity broke my char-select
Threaded Mode
