Trying to setup a new server; Having problems.

[nutbuckle]

I figure that a good way to get help from you guys is to paste start to finish then go over errors.

So where we go...

eqemu@cree eqemu $ cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/eqemu login
Logging in to :pserver:anonymous@cvs.sourceforge.net:2401/cvsroot/eqemu
CVS password:
eqemu@cree eqemu $


eqemu@cree eqemu $ cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/eqemu -z3 co eqemu
cvs server: Updating eqemu
cvs server: Updating eqemu/EQEMu Release
U eqemu/EQEMu Release/.MySCMServerInfo
U eqemu/EQEMu Release/Boot5zones.bat
U eqemu/EQEMu Release/DoorUpdate.sql
U eqemu/EQEMu Release/EQUI_GUIDE.xml
...
U eqemu/NewSource/zone/zonedbasync.h
U eqemu/NewSource/zone/zonedump.h
eqemu@cree eqemu $
eqemu@cree eqemu $ cd eqemu/NewSource/
eqemu@cree NewSource $ cd EMuShareMem/
eqemu@cree EMuShareMem $ make
eqemu@cree EMuShareMem $ cp libEMuShareMem.so /usr/local/lib/
eqemu@cree EMuShareMem $ cd ../world/
eqemu@cree world $ make
eqemu@cree world $ mkdir ~/bin
eqemu@cree world $ cp world ~/bin/
eqemu@cree world $ cd ../zone/
eqemu@cree world $ make
eqemu@cree world $ cp zone ~/bin/
eqemu@cree world $ cd ..
eqemu@cree eqemu $ cd EQEMu\ Release/
eqemu@cree eqemu $ mysql -u root -p
eqemu@cree eqemu $ mysql> create database eq;
eqemu@cree eqemu $ mysql> use eq;
eqemu@cree eqemu $ mysql> source db.sql;
eqemu@cree eqemu $ mysql> source pets.sql;
eqemu@cree eqemu $ mysql> source boats.sql;
eqemu@cree eqemu $ mysql> quit;
eqemu@cree EQEMu Release $ cp *.ini ~/bin/
eqemu@cree EQEMu Release $ cp *.bat ~/bin/

Ok, so That about sums it up...

Now I'll paste the INIs
*snip*
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=nutbuckles_test_server
worldaddress=cree.nutbuckle.net
locked=false
*snip*

*snip*
[Database]
host=localhost
user=root
password=xxxxx
database=eq
compression=off
*snip*


so, now I load world and get this:
Failed to open log file: logs/eqemu_world.log
[Status] Using database 'eq' at localhost
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] libEMuShareMem.so loaded
[Status] Loading items from database: count=0, max id=0
Failed to open log file: logs/eqemu_error_world.log
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown107, unknown108,id,weight,norent,nodrop,size,itemclass, idfile,lore,slots,cost,name,icon,unknown105,bookty pe,filename,bagtype,bagslots,bagsize,bagwr,augslot 1type,augslot2type,augslot3type,augslot4type,augsl ot5type,unknown018,unknown019,unknown020,casttime2 ,unknown061,unknown067,unknown069,unknown070,unkno wn076,unknown077,augtype,unknown097,unknown098,unk nown099,astr,asta,aagi,adex,awis,aint,acha,pr,mr,d r,fr,cr,skillmodvalue,skillmodtype,banedmgamt,bane dmgbody,banedmgrace,magic,hasteproclvl,light,delay ,effecttype,range,damage,material,maxcharges,recle vel,recskill,charmfile,factionmod1,factionmod2,fac tionmod3,factionmod4,factionamt1,factionamt2,facti onamt3,factionamt4,reqlevel,hp,mana,ac,color,class es,races,spellid,casttime,focusid,itemtype,accurac y,avoidance,bardtype,bardvalue,combateffects,deity ,elemdmgamt,elemdmgtype,sellrate,shielding,spellsh ield,strikethrough,stunresist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2' in 'field 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..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Abort/retry/cancel?
TCP listening on: cree.nutbuckle.net:9000
World server listening on: cree.nutbuckle.net:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997


The first error is ok because I don't have a logs dir but from what I've seen and can grasp of this.
the database is missing casttime2, which is being called from stuff in common/. I've seen nothing in any of the .sqls to update the table.

Could anyone give me any ideas?


many many thanks.