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,itemcl ass,idfile,lore,slots,cost,nam
e,icon,unknown105,booktype,filename,bagtype,bagslo ts,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5typ e,unknown018,unknown019,unknow
n020,casttime2,unknown061,unknown067,unknown069,un known070,unknown076,unknown077
,augtype,unknown097,unknown098,unknown099,astr,ast a,aagi,adex,awis,aint,acha,pr,
mr,dr,fr,cr,skillmodvalue,skillmodtype,banedmgamt, banedmgbody,banedmgrace,magic,
hasteproclvl,light,delay,effecttype,range,damage,m aterial,maxcharges,reclevel,re
cskill,charmfile,factionmod1,factionmod2,factionmo d3,factionmod4,factionamt1,fac
tionamt2,factionamt3,factionamt4,reqlevel,hp,mana, ac,color,classes,races,spellid
,casttime,focusid,itemtype,accuracy,avoidance,bard type,bardvalue,combateffects,d
eity,elemdmgamt,elemdmgtype,sellrate,shielding,spe llshield,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 (http://prdownloads.sourceforge.net/eqemu/dumpeditems.sql.gz?download) 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