View Single Post
  #8  
Old 04-04-2008, 01:08 PM
suprphrk
Fire Beetle
 
Join Date: Apr 2008
Posts: 16
Default DBLoadItems query error

Theeper-

Thanks for the point in the right direction. I saw it say that it loaded items from db 62256, but I didn't pay attention to what was right after it:

Code:
[Status] Loading items from database: count=62256
[Error] Starting Log: logs/eqemu_error_world_5128.log
[Error] DBLoadItems query 'select source,itemclass,name,lore,idfile,id,weight,no
rent,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,bardtyp
e,bardvalue,light,delay,reclevel,recskill,elemdmgtype,elemdmgamt,range,damage,co
lor,classes,races,UNK054,maxcharges,itemtype,material,sellrate,UNK059,casttime,U
NK061,procrate,combateffects,shielding,stunresist,strikethrough,extradmgskill,ex
tradmgamt,spellshield,avoidance,accuracy,charmfileid,factionmod1,factionmod2,fac
tionmod3,factionmod4,factionamt1,factionamt2,factionamt3,factionamt4,charmfile,a
ugtype,augslot1type,augslot1unk,augslot2type,augslot2unk,augslot3type,augslot3un
k,augslot4type,augslot4unk,augslot5type,augslot5unk,ldontheme,ldonprice,ldonsold
,bagtype,bagslots,bagsize,bagwr,book,booktype,filename,banedmgraceamt,augrestric
t,loregroup,pendingloreflag,artifactflag,summonedflag,favor,fvnodrop,endur,dotsh
ielding,attack,regen,manaregen,enduranceregen,haste,damageshield,recastdelay,rec
asttype,guildfavor,augdistiller,UNK123,UNK124,attuneable,nopet,UNK127,pointtype,
potionbelt,potionbeltslots,stacksize,notransfer,stackable,UNK134,clickeffect,cli
cktype,clicklevel,clicklevel2,proceffect,proctype,proclevel,proclevel2,worneffec
t,worntype,wornlevel,wornlevel2,focuseffect,focustype,focuslevel,focuslevel2,scr
olleffect,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
[Error] If you got boat loads of errors, make sure you sourced: utils/items-0.6.
0-DR2-0.6.1-DR1-convert.sql
I don't have utils/items-06.0-DR2-0.6.1-DR1-convert.sql. I haven't searched the net for it yet, but further searching for the problem that it mentions in the error shows that "range" is a reserved word in SQL 5.1+. Will running this .sql script fix my problem if I find it? Or am I barking up the wrong tree with it?
Reply With Quote