EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)
-   -   SQL #1054 error (https://www.eqemulator.org/forums/showthread.php?t=14410)

ryetsu 06-17-2004 05:45 PM

SQL #1054 error
 
Code:

[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,itemclass,name,lore,idfile,id,weight,n
orent,nodrop,size,slots,cost,icon,unknown018,unknown019,unknown020,tradeskills,c
r,dr,pr,mr,fr,astr,asta,aagi,adex,acha,aint,awis,hp,mana,ac,deity,skillmodvalue,
skillmodtype,banedmgrace,banedmgamt,banedmgbody,magic,casttime2,hasteproclvl,req
level,bardtype,bardvalue,light,delay,reclevel,recskill,elemdmgtype,elemdmgamt,ef
fecttype,range,damage,color,classes,races,unknown061,spellid,maxcharges,itemtype
,material,sellrate,unknown067,casttime,unknown069,proc_rate_mod,focusid,combatef
fects,shielding,stunresist,strikethrough,combatskill,combatskilldmg,spellshield,
avoidance,accuracy,unknown081,factionmod1,factionmod2,factionmod3,factionmod4,fa
ctionamt1,factionamt2,factionamt3,factionamt4,charmfile,augtype,augslot1type,aug
slot2type,augslot3type,augslot4type,augslot5type,ldonpointtheme,ldonpointcost,ld
onsold,bagtype,bagslots,bagsize,bagwr,booktype,unknown105,filename,banedmgamt2,a
ugmentrestriction,loreflag,pendingloreflag,artifactflag,summonedflag,tribute,gmf
lag,endur,dotshielding,attackbonus,hpregen,manaregen,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!


All times are GMT -4. The time now is 12:12 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.