Could use some items db help
Hello!
i just wanted to know if someone kows what i should do about this Error. [Status] EMuShareMem loaded [Status] Loading items from database: count=62255 [Error] Starting Log: logs/eqemu_error_world_1092.log [Error] DBLoadItems query 'select source,itemclass,name,lore,idfile,id,weight,no rent,nodrop,size,slots,price,icon,UNK012,UNK013,be nefitflag,tradeskills,cr,dr,pr ,mr,fr,astr,asta,aagi,adex,acha,aint,awis,hp,mana, ac,deity,skillmodvalue,UNK033, skillmodtype,banedmgrace,banedmgamt,banedmgbody,ma gic,casttime_,reqlevel,bardtyp e,bardvalue,light,delay,reclevel,recskill,elemdmgt ype,elemdmgamt,range,damage,co lor,classes,races,UNK054,maxcharges,itemtype,mater ial,sellrate,UNK059,casttime,U NK061,procrate,combateffects,shielding,stunresist, strikethrough,extradmgskill,ex tradmgamt,spellshield,avoidance,accuracy,charmfile id,factionmod1,factionmod2,fac tionmod3,factionmod4,factionamt1,factionamt2,facti onamt3,factionamt4,charmfile,a ugtype,augslot1type,augslot1unk,augslot2type,augsl ot2unk,augslot3type,augslot3un k,augslot4type,augslot4unk,augslot5type,augslot5un k,ldontheme,ldonprice,ldonsold ,bagtype,bagslots,bagsize,bagwr,book,booktype,file name,banedmgraceamt,augrestric t,loregroup,pendingloreflag,artifactflag,summonedf lag,favor,fvnodrop,endur,dotsh ielding,attack,regen,manaregen,enduranceregen,hast e,damageshield,recastdelay,rec asttype,guildfavor,augdistiller,UNK123,UNK124,attu neable,nopet,UNK127,pointtype, potionbelt,potionbeltslots,stacksize,notransfer,st ackable,UNK134,clickeffect,cli cktype,clicklevel,clicklevel2,proceffect,proctype, proclevel,proclevel2,worneffec t,worntype,wornlevel,wornlevel2,focuseffect,focust ype,focuslevel,focuslevel2,scr olleffect,scrolltype,scrolllevel,scrolllevel2,upda ted 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,itemtypselect source,itemclass,name,lore,idfile, id,weight,norent,nodrop,size,slots,price,icon,UNK0 12,UNK013,benefitflag,tradeski lls,cr,dr,pr,mr,fr,astr,asta,aagi,adex,acha,aint,a wis,hp,mana,ac,deity,skillmodv alue,UNK033,skillmodtype,banedmgrace,banedmgamt,ba nedmgbody,magic,casttime_,reql evel,bardtype,bardvalue,light,delay,reclevel,recsk ill,elemdmgtype,elemdmgamt,ran ge,damage,color,classes,races,UNK054,maxcharges,it emtype,material,sellrate,UNK05 9,casttime,UNK061,procrate,combateffects,shielding ,stunresist,strikethrough,extr admgskill,extradmgamt,spellshield,avoidance,accura cy,charmfileid,factionmod1,fac tionmod2,factionmod3,factionmod4,factionamt1,facti onamt2,factionamt3,factionamt4 ,charmfile,augtype,augslot1type,augslot1unk,augslo t2type,augslot2unk,augslot3typ e,augslot3unk,augslot4type,augslot4unk,augslot5typ e,augslot5unk,ldontheme,ldonpr ice,ldonsold,bagtype,bagslots,bagsize,bagwr,book,b ooktype,filename,banedmgraceam t,augrestrict,loregroup,pendingloreflag,artifactfl ag,summonedflag,favor,fvnodrop ,endur,dotshielding,attack,regen,manaregen,enduran ceregen,haste,damageshield,rec astdelay,recasttype,guildfavor,augdistiller,UNK123 ,UNK124,attuneable,nopet,UNK12 7,pointtype,potionbelt,potionbeltslots,stacksize,n otransfer,stackable,UNK134,cli ckeffect,clicktype,clicklevel,clicklevel2,proceffe ct,proctype,proclevel,procleve l2,worneffect,worntype,wornlevel,wornlevel2,focuse ffect,focustype,focuslevel,foc uslevel2,scrolleffect,scrolltype,scrolllevel,scrol llevel2,updated from items ord er by id [Error] If you got boat loads of errors, make sure you sourced: utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems [Debug] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring have no clue what to do, when i try to source 0.6.0-DR2-0.6.1-DR1-convert.sql i get spammed with column missing , invalid column etc . |
You have the same problem described in this thread:
http://www.eqemulator.net/forums/sho...625#post141625 If you are using MySQL 5.1, downgrade to 5.0. |
Thanks
thanks alot 1 less problem to fix :)
|
All times are GMT -4. The time now is 12:02 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.