Log in

View Full Version : SQL #1054 error


ryetsu
06-17-2004, 05:45 PM
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR6
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=28731, max id=69304
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un
known005,unknown006,unknown007,unknown008,itemclas s,name,lore,idfile,id,weight,n
orent,nodrop,size,slots,cost,icon,unknown018,unkno wn019,unknown020,tradeskills,c
r,dr,pr,mr,fr,astr,asta,aagi,adex,acha,aint,awis,h p,mana,ac,deity,skillmodvalue,
skillmodtype,banedmgrace,banedmgamt,banedmgbody,ma gic,casttime2,hasteproclvl,req
level,bardtype,bardvalue,light,delay,reclevel,recs kill,elemdmgtype,elemdmgamt,ef
fecttype,range,damage,color,classes,races,unknown0 61,spellid,maxcharges,itemtype
,material,sellrate,unknown067,casttime,unknown069, proc_rate_mod,focusid,combatef
fects,shielding,stunresist,strikethrough,combatski ll,combatskilldmg,spellshield,
avoidance,accuracy,unknown081,factionmod1,factionm od2,factionmod3,factionmod4,fa
ctionamt1,factionamt2,factionamt3,factionamt4,char mfile,augtype,augslot1type,aug
slot2type,augslot3type,augslot4type,augslot5type,l donpointtheme,ldonpointcost,ld
onsold,bagtype,bagslots,bagsize,bagwr,booktype,unk nown105,filename,banedmgamt2,a
ugmentrestriction,loreflag,pendingloreflag,artifac tflag,summonedflag,tribute,gmf
lag,endur,dotshielding,attackbonus,hpregen,manareg en,hastepercent,damageshield,m
instatus FROM items ORDER BY id', #1054: Unknown column 'unknown008' in 'field l
ist'
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] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
You may already be a winner... of the darwin award.
TCP listening on: 24.94.xxxx:9000
World server listening on: 24.94.xxxx:9000
Connected to LoginServer: eqlogin2.eqemulator.net:5997


I have sourced in the latest item table changes yet I am still getting this error. Anyone know whats wrong?

Jezebell
06-18-2004, 07:41 AM
you need to add this field to your items table:

unknown008
Int 11
default=0
after unknown007

ryetsu
06-18-2004, 08:12 AM
Thanks very much for the reply Jezebell! Worked like a charm. :)

Now to figure out why its not showing up in the server list. ;)

Thanks again!