That Zone Is Currently Unavailable.

[Eumin]

Why? Why is it almost every zone, on almost every server say that? I create a char, then go to play it .. no go.

I was playing just fine like 3 hours ago.. /sigh


Sorry if this is the wrong forum.

[Eumin]

Also .. either I just can't go in the zone .. or it starts to load into the zone .. then BAM, server select.

[Maniac]

Did you check your world.exe and zone windows? I had a similar prob and it was a error in loading from the db

[n1vek86]

i also have this prob. it starts all fine but after i make a character it says not available or loads but crashes to the servers

[Lurker_005]

Are you running your own server, or what server?
What OS?
What database?
Post your config files
Post a copy and paste from your world and zone windows


Get the idea?

It is much easier and quicker to figure out problems if you provide some more information.

[n1vek86]

i dunno, im connected to the EQemu server, not my server, I just want to play, win XP, dsl, and stuff

[Nuad]

Sounds like busy Zoneservers... e.g. if the Server have 5 Zoneservers up and there are at least one Player in 5 different Zones there is no free Zoneserver for you and so no Zone aviable.

[Velosity]

5 Posted: 05-07-2002 02:51 PM Post subject:

--------------------------------------------------------------------------------

Are you running your own server, or what server?
What OS?
What database?
Post your config files
Post a copy and paste from your world and zone windows


Get the idea?

It is much easier and quicker to figure out problems if you provide some more information.


WHAT MY PROBLEM IS:
As you will obviously see, I am running my own server. I get my server booting just fine, i see my server on the server select screen. Go to play on my server, get to the charachter select screen just fine, go to select my charachter, go in to enter the world and bam, i get a messagebox saying That zone is unavailable. i made a new charachter, was able to log into my server, but i zoned and crashed.

I went back to my computer thats hosting the server,

System statistics
Intel Pentium 4 1.8GHZ processor
768mb sdram
nvidia geforce 3 ti 200
cable modem behind 2 routers (had to set DMZ to server for zone.exe to initially boot up properly) Ive had my server working for a while now and this started to happen =-(

HELP ME PLEASE!!!


++++====++++My Configuration files++++====++++


====++++====Loginserver.ini====++++====

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS.

### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=eqlogin1.eqemu.net
loginserver2=eqlogin2.eqemu.net
loginport=5999
loginport2=5999
worldname=[New] Beretta Assassin's
worldaddress=Global IP
locked=false
account=
password=

[WorldServer]
Defaultstatus=20
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=


====++++====DB.ini====++++====

# READ README.TXT!

[Database]
host=localhost
user=sa
password=thx1138
database=eq
compression=off


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.

====++++====Addon.ini====++++====

#Addon release file

[CommandLevels]
$MAXCLIENTS=-1
@NPCSPELLS=8
!setaaxp=100
!setaapts=100
!level=100
!damage=100
!heal=100
!npcspecialattk=100
!kill=100
!timeofday=100
!date=100
!haste=100
!weather=100
!shutdown=200
!setxp=100
!summonitem=0
!itemsearch=0
!finditem=0
!search=0
!spawn=101
!delacct=200
!size=100
!worldshutdown=200
!chat=200
!appearance=100
!zoneshutdown=200
!zonebootup=200
!emote=100
!summon=100
!kick=100
!mana=100
!npcloot=100
!findspell=100
!spfind=100
!castspell=100
!cast=100
!invul=100
!invulnerable=100
!setskill=100
!setskillall=100
!setallskill=100
!save=100
!depop=100
!depopcorpses=100
!depopzone=100
!repop=100
!spawnstatus=100
!listnpcs=100
!listnpccorpses=100
!listplayercorpses=100
!deletenpccorpses=100
!deleteplayercorpses=100
!showbuffs=100
!nukebuffs=100
!hideme=100
!deletecorpse=100
!sendzonespawns=100
!flymode=100
!race=100
!texture=100
!gender=100
!zheader=100
!zsky=100
!zcolor=100
!zcolour=100
!zuwcoords=100
!zsafecoords=100
!zclip=100
!zsave=200
!npccast=100
!dbspawn2=100
!npctypespawn=100
!attack=100
!zstats=100
!lock=200
!unlock=200
!motd=100
!makepet=100
!crashtest=200
!showpetspell=200
!freeze=100
!unfreeze=100
!pvp=100
!permaclass=100
!permarace=100
!permagender=100
!gm=100
!gmspeed=100
!movechar=100
!title=100
!copychar=200
!serverinfo=200
!npcstats=100
!memspell=100
!zone=20


====++++====Boot20Zones.bat====++++====

REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "Global IP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_en.txt goto NOSPELL

start zone . Global IP 7995 Global IP
start zone . Global IP 7996 Global IP
start zone . Global IP 7997 Global IP
start zone . Global IP 7998 Global IP
start zone . Global IP 7999 Global IP
start zone . Global IP 8000 Global IP
start zone . Global IP 8001 Global IP
start zone . Global IP 8002 Global IP
start zone . Global IP 8003 Global IP
start zone . Global IP 8004 Global IP
start zone . Global IP 8005 Global IP
start zone . Global IP 8006 Global IP
start zone . Global IP 8007 Global IP
start zone . Global IP 8008 Global IP
start zone . Global IP 8009 Global IP
start zone . Global IP 8010 Global IP
start zone . Global IP 8011 Global IP
start zone . Global IP 8012 Global IP
start zone . Global IP 8013 Global IP
start zone . Global IP 8014 Global IP
exit
cls

:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

[a_Guest03]

:) Your "Global IPs" hopefully represent a number. You're supposed to replace them with your IP address. Did you do that?

[Velosity]

Sorry it took so long to reply, i was at a backgammon tournament in Beverly Hills with the best in the country. Was gonna play in the novice since it was my first tournament . . . bam i get put in advanced =-( sadly to say i got eaten alive by the math gurus and the backgammon freaks

BUT . . . .

a_Guest03 Posted: 06-05-2003 05:34 AM Post subject:

--------------------------------------------------------------------------------

Your "Global IPs" hopefully represent a number. You're supposed to replace them with your IP address. Did you do that?


yeah i got my ip from whatismyip.com and put it in there, i edited my IP out using notepad's replace function and replaced it with GlobalIP . . but if there was something else wrong you would have put

did you do that

and . . . .

this was wrong

that was wrong

this with that is wrong
but you didnt . . which leads me to believe that i have it set up correctly (ive had my server running PERFECTLY (cept for the bugs that everyone gets IN game . . .) but now zone.exe's keep crashing and all my world.exe says is disconnecting yadda yadda and the ip it says it gets rid of is 0.0.0.0

[Velosity]

HELLO?!?!?!
LURKER?!?!? ANYONE?!?!?!?! TRUMPCARD?!?!?!?!?

I am still getting this error =-( Is this problem unsolved and admins are afraid to admit it? (not likely) Please, i would like to know how to fix this, or what is being done to fix this. This is a serious problem, I cant find the problem anywhere!

I notice a little added line of code at the bottom of my zone.exe's

[That little line of code]
66.***.***.***:9000: TCPConnection:RecvData<>: Error: 10054


The error code is the same as an error code i had on my world.
Using database 'eq' at localhost
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.4
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.4
Loading Variables, zone names & items...
EMuShareMem.dll loaded.
Loading items from database...
DB Query Error #1054: Unknown column 'minstatus' in 'field list'
Error in LoadItemStatus query: 'Select id, minstatus from items where minstatus > 0'
...done.
LoginServer.ini read.
Loading guild ranks...done.
Loading EQ time of day...done.
Deleted 0 stale player corpses from database.
DB Query Error #1054: Unknown column 'ts' in 'where clause'
Deleted -1 stale player backups from database.
Assassinating people that whine about horses...done
TCP listening on: 66.***.***.***:9000
World server listening on: 66.***.***.***:9000
Connected to LoginServer: eqlogin2.eqemu.net:5999
32844 New TCP connection: 192.168.1.1:2633
New zoneserver: #1 192.168.1.1:2633
Zoneserver SetConnectInfo: 192.168.1.1:2633: 66.***.***.***:8003
33688 New TCP connection: 192.168.1.1:2634
33688 New TCP connection: 192.168.1.1:2635
33688 New TCP connection: 192.168.1.1:2636
33688 New TCP connection: 192.168.1.1:2637
33688 New TCP connection: 192.168.1.1:2638
New zoneserver: #2 192.168.1.1:2638
New zoneserver: #3 192.168.1.1:2636
New zoneserver: #4 192.168.1.1:2635
New zoneserver: #5 192.168.1.1:2634
Zoneserver SetConnectInfo: 192.168.1.1:2634: 66.***.***.***:8019
Zoneserver SetConnectInfo: 192.168.1.1:2635: 66.***.***.***:8014
33781 New TCP connection: 192.168.1.1:2640
33781 New TCP connection: 192.168.1.1:2641
33781 New TCP connection: 192.168.1.1:2639
33781 New TCP connection: 192.168.1.1:2642
33781 New TCP connection: 192.168.1.1:2643
33781 New TCP connection: 192.168.1.1:2644
33781 New TCP connection: 192.168.1.1:2646
33781 New TCP connection: 192.168.1.1:2647
33781 New TCP connection: 192.168.1.1:2648
33781 New TCP connection: 192.168.1.1:2649
New zoneserver: #6 192.168.1.1:2649
New zoneserver: #7 192.168.1.1:2648
New zoneserver: #8 192.168.1.1:2647
New zoneserver: #9 192.168.1.1:2646
New zoneserver: #10 192.168.1.1:2644
New zoneserver: #11 192.168.1.1:2643
New zoneserver: #12 192.168.1.1:2642
New zoneserver: #13 192.168.1.1:2639
New zoneserver: #14 192.168.1.1:2641
New zoneserver: #15 192.168.1.1:2640
New zoneserver: #16 192.168.1.1:2637
Zoneserver SetConnectInfo: 192.168.1.1:2639: 66.***.***.***:8006
Zoneserver SetConnectInfo: 192.168.1.1:2636: 66.***.***.***:8010
Zoneserver SetConnectInfo: 192.168.1.1:2638: 66.***.***.***:8018
33844 New TCP connection: 192.168.1.1:2650
33844 New TCP connection: 192.168.1.1:2651
33844 New TCP connection: 192.168.1.1:2652
New zoneserver: #17 192.168.1.1:2652
New zoneserver: #18 192.168.1.1:2651
New zoneserver: #19 192.168.1.1:2650
Zoneserver SetConnectInfo: 192.168.1.1:2640: 66.***.***.***:8001
Zoneserver SetConnectInfo: 192.168.1.1:2641: 66.***.***.***:8009
Zoneserver SetConnectInfo: 192.168.1.1:2642: 66.***.***.***:8007
Zoneserver SetConnectInfo: 192.168.1.1:2643: 66.***.***.***:8017
Zoneserver SetConnectInfo: 192.168.1.1:2644: 66.***.***.***:8005
Zoneserver SetConnectInfo: 192.168.1.1:2647: 66.***.***.***:8004
Zoneserver SetConnectInfo: 192.168.1.1:2648: 66.***.***.***:8020
Zoneserver SetConnectInfo: 192.168.1.1:2649: 66.***.***.***:8011
Zoneserver SetConnectInfo: 192.168.1.1:2650: 66.***.***.***:8002
Zoneserver SetConnectInfo: 192.168.1.1:2651: 66.***.***.***:8013
Zoneserver SetConnectInfo: 192.168.1.1:2652: 66.***.***.***:8012
Zoneserver SetConnectInfo: 192.168.1.1:2637: 66.***.***.***:8016
Zoneserver SetConnectInfo: 192.168.1.1:2646: 66.***.***.***:8015
34219 New TCP connection: 192.168.1.1:2645
New zoneserver: #20 192.168.1.1:2645
Zoneserver SetConnectInfo: 192.168.1.1:2645: 66.***.***.***:8008
157641 New client from ip: 192.168.1.1 port: 2657
Logged in: FirstLogin LS#24837: Velosity
Sending list of guilds
Unknown opcode: 0x3541 size:2056
Unknown opcode: 0x3941 size:2056
DB Query Error #1054: Unknown column 'timeleft' in 'where clause'
Error in UpdateTimeLeftWorldUpdate spawn2 set timeleft=(timeleft-300000) where timeleft>=300000' ╠╠╠╠╠╠╠& #9568;╠╠╠╠╠╠&# 9568;╠╠╠╠╠╠&#9 568;╠╠╠╠╠╠&#95 68;╠╠╠╠╠╠&#956 8;╠╠╠╠╠╠&#9568 ;╠╠╠╠╠╠╠ ╠╠╠╠╠╠╠& #9568;╠╠╠╠╠╠&# 9568;╠╠╠╠╠╠&#9 568;╠╠╠╠╠╠&#95 68;╠╠╠╠╠╠&#956 8;╠╠╠╠╠╠&#9568 ;╠╠╠╠╠╠╠ ╠╠╠╠╠╠╠& #9568;╠╠╠╠╠╠&# 9568;╠╠╠╠╠╠&#9 568;╠╠╠╠╠╠&#95 68;╠╠╠╠╠╠&#956 8;╠╠╠╠╠╠&#9568 ;╠╠╠╠╠╠╠ ╠╠╠╠╠╠╠& #9568;╠╠╠╠╠╠&# 9568;╠╠╠╠╠╠&#9 568;╠╠╠╠╠╠&#95 68;╠╠╠╠╠╠&#956 8;╠╠╠╠╠╠&#9568 ;╠╠╠╠╠╠╠ ░╪P

Error: InflatePacket: inflate() returned -3 'unknown compression method'
Packet contents:Beretta
Attempting autobootup of neriakc (42) for Beretta
Zoneserver SetZone: 66.***.***.***:8016 (0)
Zoneserver SetZone: 66.***.***.***:8016 (0)
Error: InflatePacket: inflate() returned -3 'unknown compression method'
Packet contents:Beretta
Attempting autobootup of neriakc (42) for Beretta
Zoneserver SetZone: 66.***.***.***:8006 (0)
Zoneserver SetZone: 66.***.***.***:8006 (0)
Error: InflatePacket: inflate() returned -3 'unknown compression method'
Packet contents:Lkhlhlhh
Attempting autobootup of arena (77) for Lkhlhlhh
Zoneserver SetZone: 66.***.***.***:8010 (0)
Zoneserver SetZone: 66.***.***.***:8010 (0)
Error: InflatePacket: inflate() returned -3 'unknown compression method'
Packet contents:Spike
Attempting autobootup of freportw (9) for Spike
Zoneserver SetZone: 66.***.***.***:8016 (0)
Zoneserver SetZone: 66.***.***.***:8016 (0)
Error: InflatePacket: inflate() returned -3 'unknown compression method'
Packet contents:The_Great_Lord,_Beretta
Attempting autobootup of nexus (152) for The_Great_Lord,_Beretta
Zoneserver SetZone: 66.***.***.***:8006 (0)
Zoneserver SetZone: 66.***.***.***:8006 (0)
Error: InflatePacket: inflate() returned -3 'unknown compression method'
Packet contents:The_Ultimate_God,_Tetsuo
Attempting autobootup of vexthal (158) for The_Ultimate_God,_Tetsuo
Zoneserver SetZone: 66***.***.***:8005 (0)
Zoneserver SetZone: 66.***.***.***:8005 (0)
Removing client from ip:192.168.1.1 port:2657
520891 New client from ip: 192.168.1.1 port: 2661
Logged in: FirstLogin LS#24837: Velosity
DB Query Error #1054: Unknown column 'timeleft' in 'where clause'
Error in UpdateTimeLeftWorldUpdate spawn2 set timeleft=(timeleft-300000) where timeleft>=300000' ╠╠╠╠╠╠╠& #9568;╠╠╠╠╠╠&# 9568;╠╠╠╠╠╠&#9 568;╠╠╠╠╠╠&#95 68;╠╠╠╠╠╠&#956 8;╠╠╠╠╠╠&#9568 ;╠╠╠╠╠╠╠ ╠╠╠╠╠╠╠& #9568;╠╠╠╠╠╠&# 9568;╠╠╠╠╠╠&#9 568;╠╠╠╠╠╠&#95 68;╠╠╠╠╠╠&#956 8;╠╠╠╠╠╠&#9568 ;╠╠╠╠╠╠╠ ╠╠╠╠╠╠╠& #9568;╠╠╠╠╠╠&# 9568;╠╠╠╠╠╠&#9 568;╠╠╠╠╠╠&#95 68;╠╠╠╠╠╠&#956 8;╠╠╠╠╠╠&#9568 ;╠╠╠╠╠╠╠ ╠╠╠╠╠╠╠& #9568;╠╠╠╠╠╠&# 9568;╠╠╠╠╠╠&#9 568;╠╠╠╠╠╠&#95 68;╠╠╠╠╠╠&#956 8;╠╠╠╠╠╠&#9568 ;╠╠╠╠╠╠╠ ░╪P

Sending list of guilds
Unknown opcode: 0x3541 size:2056
Unknown opcode: 0x3941 size:2056
DB Query Error #1054: Unknown column 'timeleft' in 'where clause'
Error in UpdateTimeLeftWorldUpdate spawn2 set timeleft=(timeleft-300000) where timeleft>=300000' ╠╠╠╠╠╠╠& #9568;╠╠╠╠╠╠&# 9568;╠╠╠╠╠╠&#9 568;╠╠╠╠╠╠&#95 68;╠╠╠╠╠╠&#956 8;╠╠╠╠╠╠&#9568 ;╠╠╠╠╠╠╠ ╠╠╠╠╠╠╠& #9568;╠╠╠╠╠╠&# 9568;╠╠╠╠╠╠&#9 568;╠╠╠╠╠╠&#95 68;╠╠╠╠╠╠&#956 8;╠╠╠╠╠╠&#9568 ;╠╠╠╠╠╠╠ ╠╠╠╠╠╠╠& #9568;╠╠╠╠╠╠&# 9568;╠╠╠╠╠╠&#9 568;╠╠╠╠╠╠&#95 68;╠╠╠╠╠╠&#956 8;╠╠╠╠╠╠&#9568 ;╠╠╠╠╠╠╠ ╠╠╠╠╠╠╠& #9568;╠╠╠╠╠╠&# 9568;╠╠╠╠╠╠&#9 568;╠╠╠╠╠╠&#95 68;╠╠╠╠╠╠&#956 8;╠╠╠╠╠╠&#9568 ;╠╠╠╠╠╠╠ ░╪P

Client disconnected
Removing client from ip:192.168.1.1 port:2661

It aknist seens as if people decided that this post was solved . . . .

[Velosity]

This was in my zone exe the second time i loaded my world.exe and zone.exe, not changing anything anywhere

[8005: sleeping, 1292]
First off, ever since i compiled my own world and zone's the final number (1292, different for each of my zone.exe's, i think its load time) started to pop up

Using database 'eq' at localhost
[Status] CURRENT_ZONE_VERSION: EQEMu 0.4.4
[Error] CURRENT_ZONE_VERSION: EQEMu 0.4.4
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
EMuShareMem.dll loaded.
DB Query Error #1054: Unknown column 'minstatus' in 'field list'
Error in LoadItemStatus query: 'Select id, minstatus from items where minstatus
> 0'
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Entering sleep mode
Connected to worldserver: 66.215.197.7:9000
Init: Loading zone lists, zone state or spawn listDB Query Error #1054: Unknown
column 'timeleft' in 'field list'
Error in PopulateZoneLists query 'SELECT id, spawngroupID, x, y, z, heading, res
pawntime, variance, pathgrid, timeleft FROM spawn2 WHERE zone='vexthal'' #1054:
Unknown column 'timeleft' in 'field list'
ERROR: Couldn't populate zone spawn list.
Zone->Init failed

[/8005: sleeping, 1292]

[leviathan7]

I am having the some problem and can't think of what would be causing it, any help\insight would be greatly appreciated.

[Bigpull]

Unknown column 'timeleft' in 'field list'
ERROR: Couldn't populate zone spawn list.
Zone->Init failed

Yeah I can't imagine why your zones won't let anyone in.

o O

You aren't using the right database for the exe's you are using.

[tcsmyworld]

I was having the same problem using the new 044 release , it had to do with the spawns.
I was re-doing my moving npc DB and after adding one of the path grids it started doing it.
I deleted that grid and was able to enter the zone again.

This fixes the problem with zones closing, next 2 posts fix your DB errors Velosity.

[tcsmyworld]

the timeleft error is caused from a field missing in the spawn2 table.
Open mysql and add this to your DB.

ALTER TABLE spawn2 ADD COLUMN timeleft int(5) NOT NULL default '0';

that fixed the error for me.

[tcsmyworld]

The minstaus error is in the items table, to fix it open mysql and add this-

ALTER TABLE items ADD COLUMN minstatus tinyint(3) unsigned default '0' after raw_data;

[booa]

the timeleft error is caused from a field missing in the spawn2 table.
Open mysql and add this to your DB.

ALTER TABLE spawn2 ADD COLUMN timeleft int(5) NOT NULL default '0';

that fixed the error for me.

I was having a population error in zone.exe .
This did the trick .

Thank you tcsmyworld !

[Velosity]

thanks alot tcs, im gonna try that after i am done posting,

[leviathan7]

The thing is I haven't done any editing to the db though. It is all the original data.

[Trumpcard]

Yes, but the binaries he posted require changes to the database to work.

[leviathan7]

Instead of launching zone.exe with the typical boot5zones.bat file:

start zone . 192.168.0.1 7995 192.168.0.1 etc etc

I created a new batch file that had it load a specific zone instead of the autozone thatit normally does.

start zone qeynos 192.168.0.1 7995 192.168.0.1

When I then launched bootazone.bat lol the zone file came up briefly and had an error but closed so i ran it again and took a screen shot when i looked atthe error it talked about something with object.

I then:
ran mysql.exe
use eq
delete from object; which deletes all entries within this table

after doing that bootazone.bat worked fine and i ran boot5zones.bat and was able to log in and play and everything.
so my question is two-fold i believe object is simply like ovens and what not is this right? and second has anyone else had any problems with this?

[mollymillions]

Thanks once again TCS, you are fast becoming my hero (who was that masked man - or girrr!!)