Zones not booting take a look

[izagod]

i got a call today from a friend saying that my server was broke, he gets to the charicter screen and it says zone not avilable, my first guess was that some how boot5zones got closed, but no they where running, the server had been running fine all night long, i left for work and came back the next day and they where still running, but the had this error
oh and i am running 5.1 and have tcsmyworlds' latest DB:


[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.1
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[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] Loading commands
[Status] 148 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 12.231.142.185:9000
[Status] Weather should change in 3528 seconds
Init: Loading zone listsError2 in PopulateZoneLists query 'SELECT DISTINCT(spawn
groupID), spawngroup.name FROM spawn2,spawngroup WHERE spawn2.spawngroupID=spawn
group.ID and zone='potranquility'' #1016: Can't open file: 'spawn2.MYI'. (errno:
145)
ERROR: Couldn't load zone lists.
Zone->Init failed

and world exe looks like this:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.1
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=25924, max id=68199
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Screwing up windows compiles...
TCP listening on: 12.231.142.185:9000
World server listening on: 12.231.142.185:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997
3465 New TCP connection: 12.231.142.185:1267
3465 New TCP connection: 12.231.142.185:1268
3465 New TCP connection: 12.231.142.185:1269
New zoneserver: #1 12.231.142.185:1268
New zoneserver: #2 12.231.142.185:1267
New zoneserver: #3 12.231.142.185:1269
3505 New TCP connection: 12.231.142.185:1270
Zoneserver SetConnectInfo: 12.231.142.185:1267: 12.231.142.185:8002
Zoneserver SetConnectInfo: 12.231.142.185:1268: 12.231.142.185:7999
New zoneserver: #4 12.231.142.185:1270
Zoneserver SetConnectInfo: 12.231.142.185:1270: 12.231.142.185:8000
Zoneserver SetConnectInfo: 12.231.142.185:1269: 12.231.142.185:7997
3595 New TCP connection: 12.231.142.185:1271
3595 New TCP connection: 12.231.142.185:1272
3595 New TCP connection: 12.231.142.185:1273
3595 New TCP connection: 12.231.142.185:1274
New zoneserver: #5 12.231.142.185:1274
New zoneserver: #6 12.231.142.185:1273
New zoneserver: #7 12.231.142.185:1272
New zoneserver: #8 12.231.142.185:1271
Zoneserver SetConnectInfo: 12.231.142.185:1271: 12.231.142.185:7996
Zoneserver SetConnectInfo: 12.231.142.185:1272: 12.231.142.185:8001
Zoneserver SetConnectInfo: 12.231.142.185:1273: 12.231.142.185:7998
Zoneserver SetConnectInfo: 12.231.142.185:1274: 12.231.142.185:7995
77652 New client from ip: 12.231.142.185 port: 1278
Logged in: FirstLogin LS#13923: izagod
Received unknown opcode: 0x02d2 size:0 bytes
Attempting autobootup of potranquility (203) for Your
Zoneserver SetZone: 12.231.142.185:8000 (0)
Zoneserver SetZone: 12.231.142.185:8000 (0)
Received unknown opcode: 0x02d2 size:0 bytes
Received unknown opcode: 0x00e7 size:0 bytes
Client disconnected
Removing client from ip:12.231.142.185 port:1278
[Error] Error in UpdateTimeLeftWorld query(1) Update spawn2 set timeleft=(timele
ft-300000) where timeleft>=300000:
[Error] Error in UpdateTimeLeftWorld query(1) Update spawn2 set timeleft=(timele
ft-300000) where timeleft>=300000:

My guess is something to do with a spawn timer or some thing bugged of that sort actualy i dont know i have no clue, there is no error # for me to search for fixings, if any one has fixxed or seen how to fix this let me know. thanks

[dragonseeds]

I had the same problem. What I did was, I set the first one as my Local IP adress and the second one as my dns adress and mine works fine.
REM:--------------Start-----------------------
@echo off

if NOT exist spells_en.txt goto NOSPELL

start zone . godsblink.no-ip.org 7995 192.168.1.30
start zone . godsblink.no-ip.org 7996 192.168.1.30
start zone . godsblink.no-ip.org 7997 192.168.1.30
start zone . godsblink.no-ip.org 7998 192.168.1.30
start zone . godsblink.no-ip.org 7999 192.168.1.30
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------------------------



there ya go! :roll:

[dragonseeds]

I had the same problem. What I did was, I set the first one as my Local IP adress and the second one as my dns adress and mine works fine.
REM:--------------Start-----------------------
@echo off

if NOT exist spells_en.txt goto NOSPELL

start zone . godsblink.no-ip.org 7995 192.168.1.30
start zone . godsblink.no-ip.org 7996 192.168.1.30
start zone . godsblink.no-ip.org 7997 192.168.1.30
start zone . godsblink.no-ip.org 7998 192.168.1.30
start zone . godsblink.no-ip.org 7999 192.168.1.30
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------------------------



there ya go! :roll:

[Muuss]

Can't open file: 'spawn2.MYI'. (errno: 145)


Something's wrong with ur table spawn2.
Error 145 means that the table was marked as crashed and should be repaired.

log into mysql and do : "repair table spawn2;"

this may help. if it doesn't, drop the table and recreate it from your sql dump file.