Thread: Database Items?
View Single Post
  #1  
Old 11-18-2008, 09:53 PM
Lord_Spaztic
Fire Beetle
 
Join Date: Nov 2007
Posts: 5
Default Database Items?

Okay, I've been setting up my server for a while and I keep getting this error.
Code:
[11.18. - 19:19:24] Starting Log: logs/eqemu_error_world_0976.log
[11.18. - 19:19:24] DBLoadItems query 'select source,itemclass,name,lore,idfile,id,weight,norent,nodrop,size,slots,price,icon,UNK012,UNK013,benefitflag,tradeskills,cr,dr,pr,mr,fr,astr,asta,aagi,adex,acha,aint,awis,hp,mana,ac,deity,skillmodvalue,UNK033,skillmodtype,banedmgrace,banedmgamt,banedmgbody,magic,casttime_,reqlevel,bardtype,bardvalue,light,delay,reclevel,recskill,elemdmgtype,elemdmgamt,range,damage,color,classes,races,UNK054,maxcharges,itemtype,material,sellrate,UNK059,casttime,UNK061,procrate,combateffects,shielding,stunresist,strikethrough,extradmgskill,extradmgamt,spellshield,avoidance,accuracy,charmfileid,factionmod1,factionmod2,factionmod3,factionmod4,factionamt1,factionamt2,factionamt3,factionamt4,charmfile,augtype,augslot1type,augslot1unk,augslot2type,augslot2unk,augslot3type,augslot3unk,augslot4type,augslot4unk,augslot5type,augslot5unk,ldontheme,ldonprice,ldonsold,bagtype,bagslots,bagsize,bagwr,book,booktype,filename,banedmgraceamt,augrestrict,loregroup,pendingloreflag,artifactflag,summonedflag,favor,fvnodrop,endur,dotshielding,attack,regen,manaregen,enduranceregen,haste,damageshield,recastdelay,recasttype,guildfavor,augdistiller,UNK123,UNK124,attuneable,nopet,UNK127,pointtype,potionbelt,potionbeltslots,stacksize,notransfer,stackable,UNK134,clickeffect,clicktype,clicklevel,clicklevel2,proceffect,proctype,proclevel,proclevel2,worneffect,worntype,wornlevel,wornlevel2,focuseffect,focustype,focuslevel,focuslevel2,scrolleffect,scrolltype,scrolllevel,scrolllevel2,updated from items order by id', #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range,damage,color,classes,races,UNK054,maxcharges,itemtype,material,sellrate,UN' at line 1
[11.18. - 19:19:25] If you got boat loads of errors, make sure you sourced: utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql
[11.18. - 19:19:25] Could not load EQTime file eqtime.cfg

And I also keep getting, "Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems"
I have used,Revsion 141,166,189,201 of the Core. And the lastest PEQ Database, Which I pulled from the PEQ CVS just last night. =/
I have no clue where to get "items-0.6.0-DR2-0.6.1-DR1-convert.sql"
I have searched this forum,GC's forum and found nothing, I must be missing it,
Anyone else having this problem and know how to fix?
Reply With Quote