Server problems
 

I just recently started working with creating emulated servers. I have been trying to make a LAN based one just to play with friends and have been running into a few problems.

With a fresh installed 0.7.0 server files and having both cavedude and peq databases sourced I was able to log into the server and create a characater and join the server (I used the wiki guide to setting up a windows 0.7.0 guide). After I logged off and when I attempted to log back into the server the world.exe continually crashes right after selecting the server in the server select screen.

I decided to update the files to the newest build currently available on the downloads page I copied and pasted the files into the eqemu folder, I did not re-source the databases. I also added the following to the database because of what i had read on these forums:
ALTER TABLE spawnentry DROP spawn_limit;
ALTER TABLE spawngroup ADD spawn_limit tinyint(4) NOT NULL default '0';
ALTER TABLE altadv_vars ADD class_type int unsigned NOT NULL DEFAULT 0;
After making these changes I was able to get past the server select screen and load the character select but when trying to enter the world at the character select screen I keep getting the message that the zone is unavailable. I have read all over these forums and wiki trying to find a possible resolution and haven't been able to. I made a new character and attempted to connect to world in these logs:

Excuse me for the quoted log if its too long, I am not sure exactly what information will be useful so I just want to encompass any possiblity. Thank you for help in advance and if anyone needs any more information or other logs I'll be glad to supply them.

Make sure you didn't copy over your "eqemu_config.xml"

I am not sure if this is what you are refeering to but when I first updated to the new build I found that when I tried to run the server it wouldnt show up in minilogin window so I naturally thought there was a problem with the eqemu_config so I tried again to update with the a fresh install of 0.7.0 and made a backup of that file copied and pasted the new build and then moved back in the backup verison of the eqemu_config

Check this out , maybe close to the same problem.

http://www.eqemulator.net/forums/showthread.php?t=20790

i did another fresh install of the server files and resourced the databases along with updating the build to most current available. I ran the following commands on the database after installing as outlined in the 0.7.0 windows server guide:
ALTER TABLE spawnentry DROP spawn_limit;
ALTER TABLE spawngroup ADD spawn_limit tinyint(4) NOT NULL default '0';
ALTER TABLE altadv_vars ADD class_type int unsigned NOT NULL DEFAULT 0;
ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';

After doing this I am still having the same problem. I can connect to the server and create a character but when I go to enter world the screen turns black for a split second and goes directly back to character select with the message zone unavailable. If anyone else has any suggestions at possible fixs or logs/settings I can check to find possible problems/solutions. I appreciate the help suggestions so far and the work people have put into this project.

Try this out;

http://www.eqemulator.net/forums/showthread.php?t=20778

see if it helps
edit;
It won't help - this is another problem and it may be related with the source lines you are entering.
Read backwards through the changelogs, make sure you applied all the lines needed to the database. also, make sure you are on the same database you are using for the EQ emulator- "status" commad will tell you where you're at, and "use" command will change you. Example: USE peq will set you to peq database.

I went ahead and tried it before you edited that it won't work and as you said it didn't work =). I did notice a new error in the logs though when I tried to see if your possible fix worked.
I am going through the changelogs right now to make sure I didn't miss stuff, thanks a lot for your support.

I went back into the changelogs and after the changes I mentioned it seemed that all of them have already been done, I didn't go all the way down the changelog to check everyone after about 20 lines that had already been done. I am still having the same problem and now I just feel like I am missing something completely stupid and small =P. I am beginning to think I'll just wait until a new build is released and try to do a fresh install and resource the databases with it.

Ok, so actually none of the builds are working now? Did you try an install from here, http://www.eqemulator.net/wiki/wikka...indowsServer70 , following the step-by step directions? (just making sure)
If so, what OS do you have - WindowsXP?, and what CPU are you using - Intel P3 or higher?

I've only tried two builds, the 0.7.0 (I used the EQEmuServerPack-3.52 thats linked on the how to create a 0.7.0 windows server guide that you linked from wiki) and the latest build on the downloads page. With the fresh install of 0.7.0 I get the world.exe crashes when you select the server in the server select screen and when I updated to the newest build I get zone is unavaliable message all the time. What I am going to do is I am going to do a completely fresh install with just the outline of how you are suppose to do it using the http://www.eqemulator.net/wiki/wikka...indowsServer70 guide. After I do a completely fresh install with no changes to the database other than what the EQEmuServerPack-3.52 has it in and will try to work from there. The server I have up now I have changed numerous times over the last few days trying to get this worked out. As far as computer it is a Windows XP computer with SP2 with a P3 processor. I really appreciate the help you are giving me and hopefully I'll end up getting this thing working correctly =)

Sorry to ask more questions, but i'm trying to figure out an answer for you;
What speed is you P3 CPU and how much memory do you have installed? also, I take you have installed MySQL 4x and Perl first?

I have no problems with questions =) ask away. The ram on the computer is 256mb, the procressor is only 1ghz. I decided to use the computer in question because it isn't very useful to me gaming anymore so I just let it sit around =P. And I did install mysql and perl first just as instructed in the guide.

The speed is ok, I'm running it with a P3 870 MhZ - but I think you may have too little ram. Somebody correct me if I'm wrong, but I inderstood the zones load up into memory, and need a lot of it. I have 1.25 GB of Ram in mine. Probably your 256mb is getting mostly ate up by your XP OS.

Email me when you can, I have more help for you, but this freaking forum is not letting me make long post