A small problem

[Everquester]

Alright, I've been having a slightly aggrevating problem that's I can't seem to figure out, everytime I run boot5zones.bat 5 windows pop up, four dissapear leaving the last one saying

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

I have copied spells_en.txt to the directory boot5zones.bat is in and I continue to recieve this error, I'm running EQEMu version 5.0 in windows XP and MySQL version 3.23. Any help would be appreciated

[Bearik]

Copy spells_us.txt over too, just for kicks.

[Everquester]

I did, just didn't add that in the above post

[Bearik]

Post your boot5zones.bat config.

[Everquester]

boot5zones.bat

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

REM: This file requires your real IP in the place of "YourIP" 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 . 12.206.12.8 7995 12.206.12.8
start zone . 12.206.12.8 7996 12.206.12.8
start zone . 12.206.12.8 7997 12.206.12.8
start zone . 12.206.12.8 7998 12.206.12.8
start zone . 12.206.12.8 7999 12.206.12.8



: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-----------------------

[Bearik]

Everything seems fine dont know what could be wrong. Are you booting up world.exe first? and if so are there any errors when you open world.exe?

[Everquester]

There are a couple, I can load boot5zones.bat now but my server is still locked when I got to try it, not sure what's going on but I included the world.exe info below.

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=0, max id=0
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown
107,unknown108,id,weight,norent,nodrop,size,itemclass,idfile,lore,slots,cost,nam
e,icon,unknown105,booktype,filename,bagtype,bagslots,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5type,unknown018,unknown019,unknow
n020,casttime2,unknown061,unknown067,unknown069,unknown070,unknown076,unknown077
,augtype,unknown097,unknown098,unknown099,astr,asta,aagi,adex,awis,aint,acha,pr,
mr,dr,fr,cr,skillmodvalue,skillmodtype,banedmgamt,banedmgbody,banedmgrace,magic,
hasteproclvl,light,delay,effecttype,range,damage,material,maxcharges,reclevel,re
cskill,charmfile,factionmod1,factionmod2,factionmod3,factionmod4,factionamt1,fac
tionamt2,factionamt3,factionamt4,reqlevel,hp,mana,ac,color,classes,races,spellid
,casttime,focusid,itemtype,accuracy,avoidance,bardtype,bardvalue,combateffects,d
eity,elemdmgamt,elemdmgtype,sellrate,shielding,spellshield,strikethrough,stunres
ist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2' in 'f
ield list'
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data.  But ignoring
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Assassinating people that whine about horses...done
TCP listening on: 12.206.12.8:9000
World server listening on: 12.206.12.8:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997

[Bearik]

You need to source in the latest Dumpeditems.sql into your DB. Should fix that

And to unlock your server open up loginserver.ini and change

locked=true

to

locked=false

[Everquester]

I still get the same errors in world.exe after loading the DB you linked

Also I already changed the locked=false so that's not it, for some reason my zones are not loading

[Bearik]

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0

A newer version of the EQemu server is out, download it from the main page and start over with a fresh DB. This wil probobly fix your problems

[Everquester]

Alright, I'll try that tommorrow, been running around in circles all day trying to figure it on my own lol, thaks for all the help, I really appreciate it.

[Everquester]

tried it and everything works better now, cept I get this error when loading boot5zones.bat

[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 Loot tables from database...
[Status] Loading doors
[Status] Loading Doors from database...
[Status] FileLoadSPDat() Loading spells from spells_us.txt
[Status] FileLoadSPDat() spells loaded: 4352
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 148 commands loaded
WorldServer connect: Connecting to the server failed: TCPConnection::Connect():
connect() failed. Error: 10061
[Error] worldserver.Connect() FAILED!
[Status] Entering sleep mode

Just that one error stopping me now and my problem is that I don't know what error 10061 is

[Bearik]

[LoginServer]
loginserver=eqlogin1.eqemu.net
loginserver2=eqlogin2.eqemu.net
loginport=5999
loginport2=5999

I'm guessing your loginserver.ini looks like this?

Use this for login server eqlogin1.eqemulator.net

Also change port to 5997