EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   that zone is unavailable (https://www.eqemulator.org/forums/showthread.php?t=23924)

xilbus 11-24-2007 05:36 PM

that zone is unavailable
 
Hi everyone,

I keep getting the error message "that zone is unavailable when clicking on enter world. here is what I get in the world dos window. If anyone can help that would be awsome :-)

[Debug] [WORLD__CLIENT] beeoch316: Character creation request from LS#0 (127.0.
0.1:1079) :
[Debug] [WORLD__CLIENT] beeoch316: Name: Styletto
[Debug] [WORLD__CLIENT] beeoch316: Race: 330 Class: 9 Gender: 1 Deity: 206 S
tart zone: 14
[Debug] [WORLD__CLIENT] beeoch316: STR STA AGI DEX WIS INT CHA Total
[Debug] [WORLD__CLIENT] beeoch316: 70 80 124 126 75 75 50 600
[Debug] [WORLD__CLIENT] beeoch316: Face: 1 Eye colors: 9 9
[Debug] [WORLD__CLIENT] beeoch316: Hairstyle: 255 Haircolor: 255
[Debug] [WORLD__CLIENT] beeoch316: Beard: 255 Beardcolor: 255
[Debug] [WORLD__CLIENT] Validating char creation info...
[Debug] [WORLD__CLIENT] Found 0 errors in character creation request
[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE p
layer_choice=14 AND player_class=9 AND player_deity=206 AND player_race=330

[Status] Found starting location in start_zones
[Debug] [WORLD__CLIENT] beeoch316: Current location: swampofnohope -1539.30, -1
213.70, 42.40
[Debug] [WORLD__CLIENT] beeoch316: Bind location: swampofnohope -1830.00, -1259
.90, 27.10
[Debug] [WORLD__CLIENT] beeoch316: Character creation successful: Styletto
[Debug] [WORLD__CLIENT] beeoch316: Attempting autobootup of swampofnohope (83)


In the sleep dos window i get

[Error] Starting Log: logs/eqemu_error_zone_3500.log
[Error] Loading player corpses failed.
Zone->Init failed
[Status] Booting akanon
Map header: 36325 faces, 162 nodes, 46087 facelists
Loaded map: 108975 vertices, 36325 faces
Map BB: (-1049.59 -> 209.91, -83.97 -> 2255.09, -601.75 -> 77.97)
Map ./Maps/akanon.map loaded.
Path File ./Maps/akanon.path not found.
[Debug] The next weather check for zone: akanon will be in 7616 seconds.
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
Error in SpawngroupID: 55208
Error in SpawngroupID: 55209
[Status] Loading spawn2 points...
[Status] Loading player corpses...

xilbus 11-25-2007 02:34 AM

So I got a few errors here, maybe someone will recognize them.

[Debug] [ZONE__INIT] Starting EQ Network server on port 7000
[Status] Booting akanon
Map header: 36325 faces, 162 nodes, 46087 facelists
Loaded map: 108975 vertices, 36325 faces
Map BB: (-1049.59 -> 209.91, -83.97 -> 2255.09, -601.75 -> 77.97)
Map ./Maps/akanon.map loaded.
Path File ./Maps/akanon.path not found.
[Debug] The next weather check for zone: akanon will be in 11100 seconds.
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
Error in SpawngroupID: 55208
Error in SpawngroupID: 55209
[Status] Loading spawn2 points...
[Status] Loading player corpses...
Error in LoadPlayerCorpses query 'SELECT id, charid, charname, x, y, z, heading,
data, timeofdeath, rezzed, WasAtGraveyard FROM player_corpses WHERE zoneid='55'
' #1054: Unknown column 'WasAtGraveyard' in 'field list'
Note that if your missing the 'rezzed' field you can add it with:
ALTER TABLE `player_corpses` ADD `rezzed` TINYINT UNSIGNED DEFAULT "0";
[Error] Starting Log: logs/eqemu_error_zone_3512.log
[Error] Loading player corpses failed.
Zone->Init failed

xilbus 11-25-2007 02:56 AM

Found the problem
 
WasAtGraveyard field was not in the database.
Opened up navicat
whent to player corpse in the database and clicked on open table
clicked on file and open query at the end
clicked on new button
and added this
alter table player_corpses add column WasAtGraveyard TINYINT(3) NOT NULL default 0;

closed everything and now I can log in and play WOOT WOOT

Angelox 11-25-2007 04:10 AM

Hi
Usually these types of errors come from incompatible source/executables and database. make sure you have the newest database and the newest source, If you can't get the newest source, then back down a version or two.

EDIT:
Or, you can try and update your database with the suggested sql lines posted with the source updates

xilbus 11-25-2007 04:31 AM

everything is working great now :-)

Now I just need to figure out how to summon items to my caracters and im all set :-)

Sakrateri 11-25-2007 05:01 AM

#finditem (itemname)

#summonitem (or #si) (itemnumber that was shown in #finditem)

ohnoez1 08-20-2008 01:00 AM

Quote:

Originally Posted by xilbus (Post 140605)
WasAtGraveyard field was not in the database.
Opened up navicat
whent to player corpse in the database and clicked on open table
clicked on file and open query at the end
clicked on new button
and added this
alter table player_corpses add column WasAtGraveyard TINYINT(3) NOT NULL default 0;

closed everything and now I can log in and play WOOT WOOT

Thank you!! I spent hours trying to figure out what was wrong... finally looked at my zone logfile, found the error, searched, and came up with your post and the fix! Thank you!!


All times are GMT -4. The time now is 07:08 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.