Odd Client Disconnects and Server Crashes

[xarisd]

Yeah, I'm really starting to see that now. I need to be more careful with what I do.

No, just trying to restore my server back to a few days ago because of screwed up code. It's RoF2 to RoF2, nothing weird. It's decided to throw this error at me, so what I've done since posting is redo each table one a time to be sure I have everything replicated exactly as it was, based on the SQL backups I made. The tables I'm working with are:
"Account", "Account_IP", "Account_Rewards", "Character_Activities", "Character_Alternate_Abilities", "Character_Alt_Currency", "Character_Auras", "Character_Bind", "Character_Buffs", "Character_Currency", "Character_Data", "Character_Enabled_Tasks", "Character_Item_Recasts", "Character_Languages", "Character_Memmed_Spells", "Character_Pet_Info", "Character_Skills", "Character_Spells", Tasks, Create_Combinations, Inventory, Event_Logs, and Timers.

This is the second fresh install I've done, but I think I know where I messed up last night when I started working on the restore. I thought I had everything figured out until I ran into the problem of "[World Server] Zone bootup timer expired, bootup failed or too slow." I tried logging as the new character as well as the old, EQ locked up for about two minutes, then started moving again on the character select. I looked at the CLI window and it said "[World Server] Zone bootup timer expired, bootup failed or too slow."

I also found out that I apparently don't have the zone file for misty thicket, which would explain why the Rivervale PoK stone never worked, as just to test I ran a halfling to Misty to see if a new character could cross zone lines. Logged back in and that new halfling couldn't log in, nor could the human that I made, ran to PoK, and logged out. I'm hoping that with this fresh install the problem is solved once and for all. Then I can focus on finding a MistyThicket file for my client.

[Huppy]

You might find find this link handy
http://www.projecteq.net/forums/inde...d-zones.15199/

[xarisd]

Okay, it's fixed for the time being, although I really hate having go scorched earth to fix anything. I feel like there was a much more elegant solution, a scalpel rather than an atom bomb. I'm not adding any queries or code from now on, my lesson has been learned. Like I indicated in the other thread, I'm just going to be happy with what I have and not care about how green the grass is anywhere else.

I do still want that Misty Thicket client map, though - not sure how that got missed. I invented halfling bards and I insist on playing them in their start zone! That and Misty Thicket always was a fun place back in the day, a nice comfortable zone for levelling a newbie with death traps all around. You know, like Kithicor at night. I'll never forget the first time I did that and was dead from reds not two minutes later. Never knew zombies could run that fast!

[Huppy]

Not sure if you're aware, but there is a file in your main server folder called eqemu_server.pl
Normally, in windows, you should be able to just double click on that file to run it, for a menu to pop up. It has various functions, but also an option to backup your entire database.