Server Stalls Out

Thenemi · #1 01-07-2009, 11:23 PM

Hello, Eqemulator forum, I am throwing myself on your mercy.

I've been trying to figure this out on my own and have just hit a brick wall. I'm trying to set up a server and I get stuck. Now, I have it set up right for playing on other servers but when I try to run one myself I get a boat load of errors and then it seems to do what it is suppose to do and then it hangs.

The mass of errors I assume is an SQL problem and I'm thinking I'll need to rebuild my databases but I have no idea what to do about the hanging login. Here is the actually log, pardon the length. I beseech you for advice! Thanks guys (and any girls).

-Thenemi

----

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' (1)
[Debug] [RULES__CHANGE] Set rule GM:MinStatusToZoneAnywhere to value 250
[Debug] [RULES__CHANGE] Set rule Character:MaxLevel to value 65
[Debug] [RULES__CHANGE] Set rule Character:LeaveCorpses to value true
[Debug] [RULES__CHANGE] Set rule Character:LeaveNakedCorpses to value true
[Debug] [RULES__CHANGE] Set rule Character:ExpMultiplier to value 0.750000000000
0
[Debug] [RULES__CHANGE] Set rule Character

eathExpLossLevel to value 10
[Debug] [RULES__CHANGE] Set rule Character:CorpseDecayTimeMS to value 86400000
[Debug] [RULES__CHANGE] Set rule Character:AutosaveIntervalS to value 300
[Debug] [RULES__CHANGE] Set rule Character:HPRegenMultiplier to value 100
[Debug] [RULES__CHANGE] Set rule Character:ManaRegenMultiplier to value 100
[Debug] [RULES__CHANGE] Set rule Character:EnduranceRegenMultiplier to value 100

[Debug] [RULES__CHANGE] Set rule Guild:MaxMembers to value 2048
[Debug] [RULES__CHANGE] Set rule Skills:MaxTrainTradeskills to value 21
[Debug] [RULES__CHANGE] Set rule Pets:AttackCommandRange to value 150.0000000000
000
[Debug] [RULES__CHANGE] Set rule World:ZoneAutobootTimeoutMS to value 120000
[Debug] [RULES__CHANGE] Set rule World:ClientKeepaliveTimeoutMS to value 95000
[Debug] [RULES__CHANGE] Set rule World:UseBannedIPsTable to value true
[Debug] [RULES__CHANGE] Set rule World:MaxClientsPerIP to value -1
[Debug] [RULES__CHANGE] Set rule World:ExemptMaxClientsStatus to value -1
[Debug] [RULES__CHANGE] Set rule Aggro:PetSpellAggroMod to value 10
[Debug] [RULES__CHANGE] Set rule Aggro:SongAggroMod to value 33
[Debug] [RULES__CHANGE] Set rule Aggro:SpellAggroMod to value 100
[Debug] [RULES__CHANGE] Set rule Combat:BaseCritChance to value 0.0000000000000
[Debug] [RULES__CHANGE] Set rule Combat:WarBerBaseCritChance to value 0.03000000
00000
[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 Character:ConsumptionMultiplier to value 100
[Debug] [RULES__CHANGE] Set rule Spells:AutoResistDiff to value 15
[Debug] [RULES__CHANGE] Set rule Spells:ResistChance to value 2.0000000000000
[Debug] [RULES__CHANGE] Set rule Spells:ResistMod to value 0.4000000000000
[Debug] [RULES__CHANGE] Set rule Spells:PartialHitChance to value 0.700000000000
0
[Debug] [RULES__CHANGE] Set rule Combat:ClientBaseCritChance to value 0.00000000
00000
[Debug] [RULES__CHANGE] Set rule Zone:NPCGlobalPositionUpdateInterval to value 6
0000
[Debug] [RULES__CHANGE] Set rule NPC:MinorNPCCorpseDecayTimeMS to value 600000
[Debug] [RULES__CHANGE] Set rule NPC:MajorNPCCorpseDecayTimeMS to value 1200000
[Debug] [RULES__CHANGE] Set rule Zone:GraveyardTimeMS to value 1200000
[Debug] [RULES__CHANGE] Set rule Zone:EnableShadowrest to value true
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZWhenLoading to value true
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZAtWaypoints to value true
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZWhenMoving to value true
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZOnSendTo to value false
[Debug] [RULES__CHANGE] Set rule Zone:ClientLinkdeadMS to value 180000
[Debug] [RULES__CHANGE] Set rule NPC:UseItemBonusesForNonPets to value true
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaSendTo to value 12.00000
00000000
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaLoading to value 12.0000
000000000
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaMoving to value 12.00000
00000000
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaWaypoint to value 12.000
0000000000
[Debug] [RULES__CHANGE] Set rule Character:HealOnLevel to value false
[Debug] [RULES__CHANGE] Set rule Character:FeignKillsPet to value false
[Debug] [RULES__CHANGE] Set rule Character:ItemManaRegenCap to value 15
[Debug] [RULES__CHANGE] Set rule Character:ItemHealthRegenCap to value 15
[Debug] [RULES__CHANGE] Set rule Combat:UseIntervalAC to value true
[Debug] [RULES__CHANGE] Set rule Combat:PetAttackMagicLevel to value 30
[Debug] [RULES__CHANGE] Set rule NPC:SayPauseTimeInSec to value 10
[Debug] [RULES__CHANGE] Set rule NPC:OOCRegen to value 0
[Debug] [RULES__CHANGE] Set rule Aggro:SmartAggroList to value true
[Debug] [RULES__CHANGE] Set rule Aggro:SittingAggroMod to value 35
[Debug] [RULES__CHANGE] Set rule Aggro:MeleeRangeAggroMod to value 20
[Debug] [RULES__CHANGE] Set rule Aggro:CurrentTargetAggroMod to value 0
[Debug] [RULES__CHANGE] Set rule Aggro:CriticallyWoundedAggroMod to value 100
[Debug] [RULES__CHANGE] Set rule Aggro:SlowAggroMod to value 450
[Debug] [RULES__CHANGE] Set rule Aggro:IncapacitateAggroMod to value 500
[Debug] [RULES__CHANGE] Set rule Aggro:MovementImpairAggroMod to value 175
[Debug] [RULES__CHANGE] Set rule NPC:BuffFriends to value true
[Debug] [RULES__CHANGE] Set rule Character

eathItemLossLevel to value 10
[Debug] [RULES__CHANGE] Set rule Watermap:CheckWaypointsInWaterWhenLoading to va
lue true
[Debug] [RULES__CHANGE] Set rule Watermap:CheckForWaterAtWaypoints to value true

[Debug] [RULES__CHANGE] Set rule Watermap:CheckForWaterWhenMoving to value true
[Debug] [RULES__CHANGE] Set rule Watermap:CheckForWaterOnSendTo to value false
[Debug] [RULES__CHANGE] Set rule Watermap:CheckForWaterWhenFishing to value true

[Debug] [RULES__CHANGE] Set rule Watermap:FishingRodLength to value 30.000000000
0000
[Debug] [RULES__CHANGE] Set rule Watermap:FishingLineLength to value 40.00000000
00000

[Debug] [RULES__CHANGE] Set rule Character:ItemDamageShieldCap to value 30
[Debug] [RULES__CHANGE] Set rule Character:ItemAccuracyCap to value 150
[Debug] [RULES__CHANGE] Set rule Character:ItemAvoidanceCap to value 100
[Debug] [RULES__CHANGE] Set rule Character:ItemCombatEffectsCap to value 100
[Debug] [RULES__CHANGE] Set rule Character:ItemShieldingCap to value 35
[Debug] [RULES__CHANGE] Set rule Character:ItemSpellShieldingCap to value 35
[Debug] [RULES__CHANGE] Set rule Character:ItemDoTShieldingCap to value 35
[Debug] [RULES__CHANGE] Set rule Character:ItemStunResistCap to value 35
[Debug] [RULES__CHANGE] Set rule Character:ItemStrikethroughCap to value 35
[Debug] [RULES__CHANGE] Set rule Spells:PartialHitChanceFear to value 0.25000000
00000
[Debug] [RULES__CHANGE] Set rule Zone:MQWarpExemptStatus to value -1
[Debug] [RULES__CHANGE] Set rule Zone:MQZoneExemptStatus to value -1
[Debug] [RULES__CHANGE] Set rule Zone:MQGateExemptStatus to value -1
[Debug] [RULES__CHANGE] Set rule Zone:MQGhostExemptStatus to value -1
[Debug] [RULES__CHANGE] Set rule Zone:EnableMQWarpDetector to value true
[Debug] [RULES__CHANGE] Set rule Zone:EnableMQZoneDetector to value true
[Debug] [RULES__CHANGE] Set rule Zone:EnableMQGateDetector to value true
[Debug] [RULES__CHANGE] Set rule Zone:EnableMQGhostDetector to value true
[Debug] [RULES__CHANGE] Set rule Zone:MQWarpDetectorDistance to value 4900.00000
00000000
[Debug] [RULES__CHANGE] Set rule Zone:MQWarpLagThreshold to value 140.0000000000
000
[Debug] [RULES__CHANGE] Set rule Zone:MQWarpThresholdTimer to value 90000.000000
0000000
[Debug] [RULES__CHANGE] Set rule Combat:EnableFearPathing to value true
[Debug] [RULES__CHANGE] Set rule Combat:FleeHPRatio to value 22
[Debug] [RULES__CHANGE] Set rule Combat:FleeIfNotAlone to value false
[Debug] [RULES__CHANGE] Set rule NPC:EnableNPCQuestJournal to value true
[Debug] [RULES__CHANGE] Set rule Character:SkillUpModifier to value 100
[Debug] [RULES__CHANGE] Set rule NPC:CorpseUnlockTimer to value 150000
[Debug] [RULES__CHANGE] Set rule NPC:EmptyNPCCorpseDecayTimeMS to value 0
[Debug] [RULES__ERROR] Unable to find rule 'World:ClearTempMerchantlist'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:ClearTempMercha
ntlist
[Debug] [RULES__ERROR] Unable to find rule 'World:AddMaxClientsPerIP'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:AddMaxClientsPe
rIP
[Debug] [RULES__ERROR] Unable to find rule 'World:AddMaxClientsStatus'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:AddMaxClientsSt
atus
[Debug] [RULES__ERROR] Unable to find rule 'TaskSystem:EnableTaskSystem'
[Debug] [RULES__ERROR] Unable to interpret rule record for TaskSystem:EnableTask
System
[Debug] [RULES__ERROR] Unable to find rule 'TaskSystem:PeriodicCheckTimer'
[Debug] [RULES__ERROR] Unable to interpret rule record for TaskSystem:PeriodicCh
eckTimer
[Debug] [RULES__ERROR] Unable to find rule 'TaskSystem:RecordCompletedTasks'
[Debug] [RULES__ERROR] Unable to interpret rule record for TaskSystem:RecordComp
letedTasks
[Debug] [RULES__ERROR] Unable to find rule 'TaskSystem:RecordCompletedOptionalAc
tivities'
[Debug] [RULES__ERROR] Unable to interpret rule record for TaskSystem:RecordComp
letedOptionalActivities
[Debug] [RULES__ERROR] Unable to find rule 'TaskSystem:KeepOneRecordPerCompleted
Task'
[Debug] [RULES__ERROR] Unable to interpret rule record for TaskSystem:KeepOneRec
ordPerCompletedTask
[Debug] [RULES__ERROR] Unable to find rule 'TaskSystem:EnableTaskProximity'
[Debug] [RULES__ERROR] Unable to interpret rule record for TaskSystem:EnableTask
Proximity
[Debug] [RULES__ERROR] Unable to find rule 'World:EnableTutorialButton'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:EnableTutorialB
utton
[Debug] [RULES__ERROR] Unable to find rule 'World:EnableReturnHomeButton'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:EnableReturnHom
eButton
[Debug] [RULES__ERROR] Unable to find rule 'World:MaxLevelForTutorial'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:MaxLevelForTuto
rial
[Debug] [RULES__ERROR] Unable to find rule 'World:MinOfflineTimeToReturnHome'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:MinOfflineTimeT
oReturnHome
[Debug] [RULES__ERROR] Unable to find rule 'Zone:AutoShutdownDelay'
[Debug] [RULES__ERROR] Unable to interpret rule record for Zone:AutoShutdownDela
y
[Debug] [RULES__ERROR] Unable to find rule 'Character:MaxExpLevel'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character:MaxExpLevel

[Debug] [RULES__ERROR] Unable to find rule 'Combat:AdjustProcPerMinute'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:AdjustProcPerM
inute
[Debug] [RULES__ERROR] Unable to find rule 'Combat:AvgProcsPerMinute'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:AvgProcsPerMin
ute
[Debug] [RULES__ERROR] Unable to find rule 'Combat:ProcPerMinDexContrib'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:ProcPerMinDexC
ontrib
[Debug] [RULES__ERROR] Unable to find rule 'Combat:BaseProcChance'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:BaseProcChance

[Debug] [RULES__ERROR] Unable to find rule 'Combat:ProcDexDivideBy'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:ProcDexDivideB
y
[Debug] [RULES__ERROR] Unable to find rule 'Chat:ServerWideOOC'
[Debug] [RULES__ERROR] Unable to interpret rule record for Chat:ServerWideOOC
[Debug] [RULES__ERROR] Unable to find rule 'Chat:ServerWideAuction'
[Debug] [RULES__ERROR] Unable to interpret rule record for Chat:ServerWideAuctio
n
[Debug] [RULES__ERROR] Unable to find rule 'Spells:BaseCritChance'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:BaseCritChance

[Debug] [RULES__ERROR] Unable to find rule 'Spells:BaseCritRatio'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:BaseCritRatio
[Debug] [RULES__ERROR] Unable to find rule 'Spells:WizCritLevel'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:WizCritLevel
[Debug] [RULES__ERROR] Unable to find rule 'Spells:WizCritChance'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:WizCritChance
[Debug] [RULES__ERROR] Unable to find rule 'Spells:WizCritRatio'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:WizCritRatio
[Debug] [RULES__ERROR] Unable to find rule 'Character:SharedBankPlat'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character:SharedBankP
lat
[Debug] [RULES__ERROR] Unable to find rule 'Spells:ResistPerLevelDiff'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:ResistPerLevel
Diff
[Debug] [RULES__ERROR] Unable to find rule 'Combat:BaseHitChance'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:BaseHitChance
[Debug] [RULES__ERROR] Unable to find rule 'Combat:HitPerLevelDiff'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:HitPerLevelDif
f
[Debug] [RULES__ERROR] Unable to find rule 'Combat:AgiHitFactor'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:AgiHitFactor
[Debug] [RULES__ERROR] Unable to find rule 'Character:UseDeathExpLossMult'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character:UseDeathExp
LossMult
[Debug] [RULES__ERROR] Unable to find rule 'Character

eathExpLossMultiplier'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character

eathExpLos
sMultiplier
[Debug] [RULES__ERROR] Unable to find rule 'Character:BindAnywhere'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character:BindAnywher
e
[Debug] [RULES__ERROR] Unable to find rule 'Bazaar:AuditTrail'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bazaar:AuditTrail
[Debug] [RULES__ERROR] Unable to find rule 'Bazaar:MaxSearchResults'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bazaar:MaxSearchResul
ts
[Debug] [RULES__ERROR] Unable to find rule 'World:TutorialZoneID'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:TutorialZoneID
[Debug] [RULES__ERROR] Unable to find rule 'Bazaar:EnableWarpToTrader'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bazaar:EnableWarpToTr
ader
[Debug] [RULES__ERROR] Unable to find rule 'Bazaar:MaxBarterSearchResults'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bazaar:MaxBarterSearc
hResults
[Debug] [RULES__ERROR] Unable to find rule 'World:AccountSessionLimit'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:AccountSessionL
imit
[Debug] [RULES__ERROR] Unable to find rule 'World:ExemptAccountLimitStatus'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:ExemptAccountLi
mitStatus
[Debug] [RULES__ERROR] Unable to find rule 'Mail:EnableMailSystem'
[Debug] [RULES__ERROR] Unable to interpret rule record for Mail:EnableMailSystem

[Debug] [RULES__ERROR] Unable to find rule 'Mail:ExpireTrash'
[Debug] [RULES__ERROR] Unable to interpret rule record for Mail:ExpireTrash
[Debug] [RULES__ERROR] Unable to find rule 'Mail:ExpireRead'
[Debug] [RULES__ERROR] Unable to interpret rule record for Mail:ExpireRead
[Debug] [RULES__ERROR] Unable to find rule 'Mail:ExpireUnread'
[Debug] [RULES__ERROR] Unable to interpret rule record for Mail:ExpireUnread
[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 Anniversary
[Debug] [NET__IDENTIFY] Registered patch Live
[Debug] [WORLD__LS] Connecting to login server...
[Debug] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998

**AndMetal** · #2 01-10-2009, 05:02 PM

Quote:

Originally Posted by Thenemi

Code:

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,UNK012,UNK013,benefitflag,tradeski
lls,cr,dr,pr,mr,fr,astr,asta,aagi,adex,acha,aint,awis,hp,mana,ac,deity,skillmodv
alue,UNK033,skillmodtype,banedmgrace,banedmgamt,banedmgbody,magic,casttime_,reql
evel,bardtype,bardvalue,light,delay,reclevel,recskill,elemdmgtype,elemdmgamt,ran
ge,damage,color,classes,races,UNK054,maxcharges,itemtype,material,sellrate,UNK05
9,casttime,UNK061,procrate,combateffects,shielding,stunresist,strikethrough,extr
admgskill,extradmgamt,spellshield,avoidance,accuracy,charmfileid,factionmod1,fac
tionmod2,factionmod3,factionmod4,factionamt1,factionamt2,factionamt3,factionamt4
,charmfile,augtype,augslot1type,augslot1unk,augslot2type,augslot2unk,augslot3typ
e,augslot3unk,augslot4type,augslot4unk,augslot5type,augslot5unk,ldontheme,ldonpr
ice,ldonsold,bagtype,bagslots,bagsize,bagwr,book,booktype,filename,banedmgraceam
t,augrestrict,loregroup,pendingloreflag,artifactflag,summonedflag,favor,fvnodrop
,endur,dotshielding,attack,regen,manaregen,enduranceregen,haste,damageshield,rec
astdelay,recasttype,guildfavor,augdistiller,UNK123,UNK124,attuneable,nopet,UNK12
7,pointtype,potionbelt,potionbeltslots,stacksize,notransfer,stackable,UNK134,cli
ckeffect,clicktype,clicklevel,clicklevel2,proceffect,proctype,proclevel,procleve
l2,worneffect,worntype,wornlevel,wornlevel2,focuseffect,focustype,focuslevel,foc
uslevel2,scrolleffect,scrolltype,scrolllevel,scrolllevel2,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

Range is a protected word in MySQL 5.1, but was not in MySQL 5.0. If you downgrade to MySQL 5.0, it should fix that issue.

It also looks like you might be running an old version of the server because of all the [Debug] [RULES__ERROR] messages.

Hope this helps.

**trevius** · #3 01-11-2009, 05:34 AM

As AndMetal suggested, it looks like you are running a newer database, but that your server code is very old. You should definitely look at the SVN and download the version of server code that matches the version of the database you are running.

Here is the link to the SVN:

http://code.google.com/p/projecteqemu/