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

[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?

[GeorgeS]

The sql above will fix the items schema to be in concordance with the latest binary. I realize it may not work for everyone, so the sql needs to be sourced in line by line. You really need to download heidiSQL and perform these changes. If these don't work, I will upload an items table for you.


GeorgeS

Originally Posted by AudioGarden21

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?

[nikkisman]

im having the same exact problem....i tried running those codes but they wouldnt work

[AudioGarden21]

Hey George. Thanks for the reply.

I actually have Heidi already. I'm just not too familiar with it's function as I didn't use it on for my old (working) server.

Could you possibly elaborate on the process? I'm no dummy so lay it on me. I'd prefer to undergo the process of fixing it manually instead of taking an updated loot_table, that way I can do it again in the future if I have issues with something similar elsewhere.

Thanks again George! I really appreciate you having a look into the matter.