I will give 5$ to anyone who can help me fix this problem.

[drewh313]

Surely 5$ is worth a minute of your time!

You can respond with paypal info at andrewhagan1@gmail.com if you'd like. Or I will mail you 5$ if you don't have an account.

I have searched the forums extensively, but have so far been unable to find a solution.

I'm not versant with the technology behind running a server. Forgive me if I don't provide enough information:

My objective is to set up a little server that I can play on my own with bots. I used this tutorial: http://www.eqemulator.net/wiki/wikka.php?wakka=Windows

These are the files and programs I've used:

Windows Xp
EQ Titanium
ActivePerl-5.10.1.1007-MSWin32-x86-291969.msi
mysql-essential-5.0.85-win32.msi
MiniLogin6.2.zip
EQEmu-Rev1316-Bots.rar
peqdatabase-Rev1549.zip
peqquests-Rev1535.zip
new_maps.zip
Maps.tar.gz

I have twice attempted to set up a server with the aforementioned tutorial, and have been successful in logging in and creating a character, but there are NO ITEMS in the game. All other features seem to work from what I've seen.

This is the error that I get in the command window:

[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_0288.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

As I said, I have searched for a solution, but most of what I found is from old posts with dead links to files I supposedly need. There was also talk of a file called "items.sql" which does not seem to be in the PEQ database download. (should it?)

I'm sure the answer is something simple. The first person's advice I use that works gets the reward. My terms are only that I am able to log into my server, with items, and that your fix did not mess up any other features.

Thanks!

-Andrew