using peqdb_rev1549.sql with EQEmuLoginServer

[eski2]

Is the EQEmuLoginServer and EQEmu-Rev1535.zip you download from http://code.google.com/p/projecteqemu/downloads/list compatible with peqdb_rev1549.sql (which from memory i got by following the wiki) or should i dump that database and use another one (but i can't see another to use?)

I am starting again with a clean system, when i sourced the db it didn't give me any errors and i'm getting up to the point of creating a new character with my Sof client. I'm just worried about the log below; it looks like the items are wrong for some reason.


[Debug] Starting Log: logs/eqemu_debug_world_2204.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[Debug] [WORLD__INIT] Added loginserver 127.0.0.1:5998
[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_2204.log
[Status] Using database 'peq' at 127.0.0.1:3306
[Debug] [WORLD__INIT] HTTP world service disabled.
[Debug] [WORLD__INIT] Loading variables..
[Debug] [WORLD__INIT] Loading zones..
[Debug] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing raids..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=83375
[Error] Starting Log: logs/eqemu_error_world_2204.log
[Error] DBLoadItems query 'select source,`itemclass`,`name`,`lore`,`idfile`,`id`
,`weight`,`norent`,`nodrop`,`size`,`slots`,`price` ,`icon`,`UNK012`,`UNK013`,`ben
efitflag`,`tradeskills`,`cr`,`dr`,`pr`,`mr`,`fr`,` astr`,`asta`,`aagi`,`adex`,`ac
ha`,`aint`,`awis`,`hp`,`mana`,`ac`,`deity`,`skillm odvalue`,`UNK033`,`skillmodtyp
e`,`banedmgrace`,`banedmgamt`,`banedmgbody`,`magic `,`casttime_`,`reqlevel`,`bard
type`,`bardvalue`,`light`,`delay`,`reclevel`,`recs kill`,`elemdmgtype`,`elemdmgam
t`,`range`,`damage`,`color`,`classes`,`races`,`UNK 054`,`maxcharges`,`itemtype`,`
material`,`sellrate`,`UNK059`,`casttime`,`UNK061`, `procrate`,`combateffects`,`sh
ielding`,`stunresist`,`strikethrough`,`extradmgski ll`,`extradmgamt`,`spellshield
`,`avoidance`,`accuracy`,`charmfileid`,`factionmod 1`,`factionmod2`,`factionmod3`
,`factionmod4`,`factionamt1`,`factionamt2`,`factio namt3`,`factionamt4`,`charmfil
e`,`augtype`,`augslot1type`,`augslot1visible`,`aug slot2type`,`augslot2visible`,`
augslot3type`,`augslot3visible`,`augslot4type`,`au gslot4visible`,`augslot5type`,
`augslot5visible`,`ldontheme`,`ldonprice`,`ldonsol d`,`bagtype`,`bagslots`,`bagsi
ze`,`bagwr`,`book`,`booktype`,`filename`,`banedmgr aceamt`,`augrestrict`,`loregro
up`,`pendingloreflag`,`artifactflag`,`summonedflag `,`favor`,`fvnodrop`,`endur`,`
dotshielding`,`attack`,`regen`,`manaregen`,`endura nceregen`,`haste`,`damageshiel
d`,`recastdelay`,`recasttype`,`guildfavor`,`augdis tiller`,`UNK123`,`UNK124`,`att
uneable`,`nopet`,`UNK127`,`pointtype`,`potionbelt` ,`potionbeltslots`,`stacksize`
,`notransfer`,`stackable`,`UNK134`,`clickeffect`,` clicktype`,`clicklevel`,`click
level2`,`proceffect`,`proctype`,`proclevel`,`procl evel2`,`worneffect`,`worntype`
,`wornlevel`,`wornlevel2`,`focuseffect`,`focustype `,`focuslevel`,`focuslevel2`,`
scrolleffect`,`scrolltype`,`scrolllevel`,`scrollle vel2`,`svcorruption`,`purity`,
`backstabdmg`,`dsmitigation`,`heroic_str`,`heroic_ int`,`heroic_wis`,`heroic_agi`
,`heroic_dex`,`heroic_sta`,`heroic_cha`,`heroic_mr `,`heroic_fr`,`heroic_cr`,`her
oic_dr`,`heroic_pr`,`heroic_svcorrup`,`healamt`,`s pelldmg`,updated from items or
der by id', #1054: Unknown column 'UNK061' in 'field list'
[Error] If you got boat loads of errors, make sure you sourced all sql updates!

Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Debug] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring
[Debug] [WORLD__INIT] Loading guilds..
[Debug] [WORLD__INIT] Loaded default rule set 'default'
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[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] Loading adventures...
[Debug] [WORLD__INIT] Purging expired instances
[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 SoF
[Debug] [NET__IDENTIFY] Registered patch SoD
[Debug] [NET__IDENTIFY] Registered patch Live
[Debug] [WORLD__LS] Connecting to login server: 127.0.0.1:5998
[Debug] [WORLD__LS] Connected to Loginserver: 127.0.0.1:5998
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1132
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1132
[Debug] [WORLD__LAUNCH] Adding pending launcher 1
[Debug] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone list.

[Debug] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.

[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_02 reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_03 reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_04 reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_05 reported state STARTED (1 starts)