PDA

View Full Version : DataBase Problem ..Pls Help


03-30-2004, 08:38 PM
dunno if this has been asked before or what not ... for most part i think i got the server up and running ... and mysql up and runng ...but i am getting this error:


[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR3
[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,ldonpointtheme,ldonpointcost,unknown099,a str,asta,aagi,adex,awis,aint,a
cha,pr,mr,dr,fr,cr,skillmodvalue,skillmodtype,bane dmgamt,banedmgbody,banedmgrace
,magic,hasteproclvl,light,delay,effecttype,range,d amage,material,maxcharges,recl
evel,recskill,charmfile,factionmod1,factionmod2,fa ctionmod3,factionmod4,factiona
mt1,factionamt2,factionamt3,factionamt4,reqlevel,h p,mana,ac,color,classes,races,
spellid,casttime,focusid,itemtype,accuracy,avoidan ce,bardtype,bardvalue,combatef
fects,deity,elemdmgamt,elemdmgtype,sellrate,shield ing,spellshield,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..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
HELP I WORK IN THE EQEMU SWEATSHOP, YOU'RE MY ONLY HOPE!
TCP listening on: <cencored ip>
World server listening on: <cencored ip>
Connected to LoginServer: <cencored ip>
10 New TCP connection: <cencored ip>


any help on this is greatly appriciated ...and thank you for any help given in advanced.

ndnet
03-30-2004, 09:04 PM
Your item table is out of date, or something like that~

Recommend you download this archive (http://www.eqemulator.net/dumpeditems.sql.gz) which includes the latest collected items and source it into your database.

03-30-2004, 09:50 PM
That worked nd thank you... now if i can just figure out why am not seeing server at server selecet hehe