Items won't load

[Mortimus]

My Items will not load. Everytime i run world.exe i get

[Debug] Starting Log: logs/eqemu_debug_world_3492.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_3492.log
[Status] Using database 'peq' at localhost:3306
[Debug] [WORLD__INIT] Starting HTTP world service...
[Debug] [WORLD__HTTP] Loaded mime types from mime.types
[Debug] [WORLD__INIT] Loading variables..
[Debug] [WORLD__INIT] Loading zones..
[Debug] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=54307
[Error] Starting Log: logs/eqemu_error_world_3492.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
[Debug] [WORLD__INIT] Loading guilds..
[Debug] [RULES__CHANGE] Loading rule set 'default' (0)
[Debug] [RULES__CHANGE] Set rule Character:AutosaveIntervalS to value 300
[Debug] [RULES__CHANGE] Set rule Character:CorpseDecayTimeMS to value 10800000
[Debug] [RULES__CHANGE] Set rule CharactereathExpLossLevel to value 6
[Debug] [RULES__CHANGE] Set rule Character:EnduranceRegenMultiplier to value 100

[Debug] [RULES__CHANGE] Set rule Character:ExpMultiplier to value 1.000000000000
0
[Debug] [RULES__CHANGE] Set rule Character:HPRegenMultiplier to value 100
[Debug] [RULES__CHANGE] Set rule Character:LeaveCorpses to value false
[Debug] [RULES__CHANGE] Set rule Character:LeaveNakedCorpses to value false
[Debug] [RULES__CHANGE] Set rule Character:ManaRegenMultiplier to value 100
[Debug] [RULES__CHANGE] Set rule Character:MaxLevel to value 65
[Debug] [RULES__CHANGE] Set rule Combat:BaseCritChance to value 0.0000000000000
[Debug] [RULES__CHANGE] Set rule Combat:BerserkBaseCritChance to value 0.0600000
000000
[Debug] [RULES__CHANGE] Set rule Combat:NPCBashKickLevel to value 6
[Debug] [RULES__CHANGE] Set rule Combat:WarBerBaseCritChance to value 0.03000000
00000
[Debug] [RULES__CHANGE] Set rule GM:MinStatusToZoneAnywhere to value 250
[Debug] [RULES__CHANGE] Set rule Guild:MaxMembers to value 2048
[Debug] [RULES__CHANGE] Set rule Pets:AttackCommandRange to value 150.0000000000
000
[Debug] [RULES__CHANGE] Set rule Skills:MaxTrainTradeskills to value 21
[Debug] [RULES__CHANGE] Set rule Spells:BardSpellAggroMod to value 3
[Debug] [RULES__CHANGE] Set rule Spells:PetSpellAggroMod to value 10
[Debug] [RULES__CHANGE] Set rule Spells:SpellAggroModifier to value 100
[Debug] [RULES__CHANGE] Set rule World:ClientKeepaliveTimeoutMS to value 65000
[Debug] [RULES__CHANGE] Set rule World:ZoneAutobootTimeoutMS to value 60000
[Debug] [WORLD__INIT] Loaded default rule set 'default'
[Debug] [WORLD__INIT] Loading EQ time of day..
[Error] Could not load EQTime file eqtime.cfg
[Debug] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[Debug] [WORLD__INIT] Loading launcher list..
[Debug] [WORLD__INIT] Reboot zone modes ON
[Debug] [WORLD__INIT] Deleted 0 stale player corpses from database
[Debug] [WORLD__INIT] Deleted 0 stale player backups from database
[Debug] [WORLD__INIT] Zone (TCP) listener started.
[Debug] [WORLD__INIT] Client (UDP) listener started.
[Debug] [NET__IDENTIFY] Registered patch 6.2
[Debug] [NET__IDENTIFY] Registered patch Titanium
[Debug] [NET__IDENTIFY] Registered patch Live
[Debug] [WORLD__LS] Connecting to login server...
[Debug] [WORLD__LS] Setting World to MiniLogin Server type
[Debug] [WORLD__LS] Connected to Loginserver: 192.168.1.117:5999
[Debug] [WORLD__LS] Connecting to login server...
[Debug] [WORLD__LS] Connecting to login server...
[Debug] [WORLD__LS] Setting World to MiniLogin Server type
[Debug] [WORLD__LS_ERR] InitLoginServer() while already attempting connect
[Debug] [WORLD__LS_ERR] Could not connect to login server: TCPConnection::Connec
t(): connect() failed. Error: 10061

Im using Mysql 5.2
Im using the newest peq
and newest EQEMU
any ideas on how to fix my db?

[kouhei]

your items in the DB are off. if you used the installer 3.52. in there was some batch files that run the update from 6.6 - to 7.0 run those updates and it will fixed the items.

[AudioGarden21]

His problem appears to be that he's using MySQL 5.2. I was using 5.1 for my server and no items would appear at all, none, zip, zero, nada.

Here is the exact quote from the guide.

NOTE: In mysql 5.1.* they introduced a new reserved keyword 'range' into the sql language,
unfortunately the items table in the peq database already has a field named "range".
To avoid this conflict we're using a 5.0.* version.

I swapped my version to the one on the guide and viola! I was a happy camper.

Here is the direct link to the download http://dev.mysql.com/downloads/mysql/5.0.html#win32

I hope this helps!