World Server Crashes

[thefoof]

Hi I'm new here, not sure if this was the right section or not. I tried logging into your test server today and was able to login and connect to the login server, but each time the world servers all appeared to crash (then come back up 30 seconds or so later). I tried with both the 9502l and 6118l clients. On 6118l I was able to get through the character creation screen once but once I selected the server (EQ2Emulator) this is when the crashes started. After that the farthest I would make it before the crashes; would be hitting the character select screen. Not sure if it has anything to do with account permissions on the server or what I'm not a developer , but I don't have any characters associated with the login yet.

PS: Love this project, if there's anything that can be done by someone who is technical but inexperienced with coding (only understands basics of the basic) let me know

[John Adams]

Thanks for the heads up, Foof. Apparently, no one has been able to connect since I last patched the EQ2Emulator server. I cannot look into it right now (at work) but when I get home later I'll try and log in to see if I can root out the problem. Meanwhile I have restarted EQ2TC with the latest code/structs, so give 6118L another try. That client should definitely still work. Let us know if it does not.

[John Adams]

Holy crap. It's LoginServer that's crashing We have never had that happen in all my years with the project. Thanks even more now for the heads up. I would have never known because it recovers so quickly.


Anyone using Minilogin, you should be fine locally.

Devs, you'll need to run these queries on your eq2ls (login db) using any new public login code locally -

Code: Select all

ALTER TABLE `login_char_colors` CHANGE `char_id` `login_characters_id` INT(10) UNSIGNED NOT NULL;
ALTER TABLE `login_characters` ADD COLUMN `tradeskill_class` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL AFTER `level`; 
ALTER TABLE `login_worldstats` ADD COLUMN `world_max_level` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL AFTER `last_update`; 

I mistakenly committed LoginDatabase.cpp before finishing my work on veteran bonus calc for Xinux. Oops.