Server problems

[mplostcause]

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

[Angelox]

Originally Posted by mplostcause

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

[mplostcause]

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.

[06.19. - 22:16:11] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x00ff
[06.19. - 22:16:11] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.19. - 22:16:11] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x00fc
[06.19. - 22:16:11] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x010a
[06.19. - 22:16:11] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x010b
[06.19. - 22:16:11] [WORLD__CLIENT] mini: Attempting autobootup of gfaydark (54)
[06.19. - 22:16:13] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.19. - 22:16:14] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.19. - 22:16:15] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.19. - 22:16:15] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.19. - 22:16:19] [WORLD__CLIENT_ERR] mini: Zone bootup timer expired, bootup failed or too slow.
[06.19. - 22:16:19] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x00c7
[06.19. - 22:16:22] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.19. - 22:16:27] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.19. - 22:16:27] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x00fc
[06.19. - 22:16:27] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x010a
[06.19. - 22:16:27] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x010b

I am going through the changelogs right now to make sure I didn't miss stuff, thanks a lot for your support.

[mplostcause]

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.

[Angelox]

Originally Posted by mplostcause

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?

[mplostcause]

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 =)

[Angelox]

Originally Posted by mplostcause

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?