Anselon
01-20-2008, 12:52 AM
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 .
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 .