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

[spideyak]

The problem resides here:

EQEmu-Rev1316-Bots.rar
peqdatabase-Rev1549.zip
peqquests-Rev1535.zip

Your database is Rev1549. The EQEmu is at Rev1316. Quests are at Rev1535.

Try to get all of them very, very close to the same revision ('Rev'). I find that I get my EQEmu as the highest revision and have the DB and quests at the same or lower, I usually do not have problems.

Hope that helps clarify more.

[kringex]

I am having this same problem with the exact same setup. Is there anywhere to download the archived peqdatabases? like peqdb_rev1265wbots?

The last line of my error after all the variables are listed is.. #1054: Unknown column 'UNK061' in 'field list'

[Secrets]

Originally Posted by kringex

I am having this same problem with the exact same setup. Is there anywhere to download the archived peqdatabases? like peqdb_rev1265wbots?

The last line of my error after all the variables are listed is.. #1054: Unknown column 'UNK061' in 'field list'

http://projecteqdb.googlecode.com/sv...rev1265.sql.gz

[kringex]

Thank you Secrets! Worked like a charm and now have items! I spent so much time trouble shooting that. Thanks for saving me.

[jackal1950]

Originally Posted by Secrets

http://projecteqdb.googlecode.com/sv...rev1265.sql.gz

will the newer quests work or do we need an older one of it also?...

[kringex]

my quests seemed to load fine using the new ones...it was just the items that would fail.

[jackal1950]

Originally Posted by kringex

my quests seemed to load fine using the new ones...it was just the items that would fail.

thanks will see what I can get done, if I could just remember what I did with my cup of coffee.....jk

[AudioGarden21]

---------------------------------------------
[06.27. - 06:00:54] Starting Log: logs/eqemu_error_world_2532.log
[06.27. - 06:00:54] DBLoadItems query 'select source,`itemclass`,`name`,`lore`,`idfile`,`id`,`we ight`,`norent`,`nodrop`,`size`,`slots`,`price`,`ic on`,`UNK012`,`UNK013`,`benefitflag`,`tradeskills`, `cr`,`dr`,`pr`,`mr`,`fr`,`astr`,`asta`,`aagi`,`ade x`,`acha`,`aint`,`awis`,`hp`,`mana`,`ac`,`deity`,` skillmodvalue`,`UNK033`,`skillmodtype`,`banedmgrac e`,`banedmgamt`,`banedmgbody`,`magic`,`casttime_`, `reqlevel`,`bardtype`,`bardvalue`,`light`,`delay`, `reclevel`,`recskill`,`elemdmgtype`,`elemdmgamt`,` range`,`damage`,`color`,`classes`,`races`,`UNK054` ,`maxcharges`,`itemtype`,`material`,`sellrate`,`UN K059`,`casttime`,`UNK061`,`procrate`,`combateffect s`,`shielding`,`stunresist`,`strikethrough`,`extra dmgskill`,`extradmgamt`,`spellshield`,`avoidance`, `accuracy`,`charmfileid`,`factionmod1`,`factionmod 2`,`factionmod3`,`factionmod4`,`factionamt1`,`fact ionamt2`,`factionamt3`,`factionamt4`,`charmfile`,` augtype`,`augslot1type`,`augslot1visible`,`augslot 2type`,`augslot2visible`,`augslot3type`,`augslot3v isible`,`augslot4type`,`augslot4visible`,`augslot5 type`,`augslot5visible`,`ldontheme`,`ldonprice`,`l donsold`,`bagtype`,`bagslots`,`bagsize`,`bagwr`,`b ook`,`booktype`,`filename`,`banedmgraceamt`,`augre strict`,`loregroup`,`pendingloreflag`,`artifactfla g`,`summonedflag`,`favor`,`fvnodrop`,`endur`,`dots hielding`,`attack`,`regen`,`manaregen`,`endurancer egen`,`haste`,`damageshield`,`recastdelay`,`recast type`,`guildfavor`,`augdistiller`,`UNK123`,`UNK124 `,`attuneable`,`nopet`,`UNK127`,`pointtype`,`potio nbelt`,`potionbeltslots`,`stacksize`,`notransfer`, `stackable`,`UNK134`,`clickeffect`,`clicktype`,`cl icklevel`,`clicklevel2`,`proceffect`,`proctype`,`p roclevel`,`proclevel2`,`worneffect`,`worntype`,`wo rnlevel`,`wornlevel2`,`focuseffect`,`focustype`,`f ocuslevel`,`focuslevel2`,`scrolleffect`,`scrolltyp e`,`scrolllevel`,`scrolllevel2`,`svcorruption`,`pu rity`,`backstabdmg`,`dsmitigation`,`heroic_str`,`h eroic_int`,`heroic_wis`,`heroic_agi`,`heroic_dex`, `heroic_sta`,`heroic_cha`,`heroic_mr`,`heroic_fr`, `heroic_cr`,`heroic_dr`,`heroic_pr`,`heroic_svcorr up`,`healamt`,`spelldmg`,updated from items order by id', #1054: Unknown column 'UNK061' in 'field list'
[06.27. - 06:00:54] If you got boat loads of errors, make sure you sourced all sql updates!

[06.27. - 06:00:54] Could not load EQTime file eqtime.cfg

As you can see they're pretty much identical.

I recognize that there are unknown fields in the database but I can't seem to remove them or get them updated.

I've done a fresh database with the latest SVN build (Rev1549) and it just doesn't seem to make any difference. I've been at it for hours.

My current server build is Rev1535 as well. I had a server about a year ago or so that was running just fine but I decided to get rid of it because there were a few issues with damage dealing and intake (it wasn't very accurate to live servers).

I've been scouring the forums looking for an answer and the one posted by GeorgeS up above seems like the most logical step. However the only issue is I can't seem to get the SQL (1542_items_table_cleanup to be exact, which contains those lines he posted) to source for the life of me. I'm also unsure of what he means by "post these changes to make it work".

Anyone able to clarify how to do this?