Rev 666

**trevius** · #1 06-16-2009, 04:32 PM

If you got duplicate messages when running that SQL, then the fields should already be there. You should check your items table to make sure you see the new fields for heroic resists such as heroic_pr, heroic_dr etc for all resist types. If those are in your table, then have you tried starting your server to see what happens or what error messages you get?

Dodie · #2 06-16-2009, 05:15 PM

Quote:

Originally Posted by trevius

If you got duplicate messages when running that SQL, then the fields should already be there. You should check your items table to make sure you see the new fields for heroic resists such as heroic_pr, heroic_dr etc for all resist types. If those are in your table, then have you tried starting your server to see what happens or what error messages you get?

Yes i see them all there.

these are my errors

[06.16. - 23:04:27] Starting Log: logs/eqemu_error_world_2248.log
[06.16. - 23:04:27] 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 'augslot1visible' in 'field list'
[06.16. - 23:04:27] If you got boat loads of errors, make sure you sourced: utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql
06.16. - 23:04:27] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring

[06.16. - 23:04:27] [RULES__ERROR] Unable to find rule 'Aggro:SlowAggroMod'
[06.16. - 23:04:27] [RULES__ERROR] Unable to interpret rule record for Aggro:SlowAggroMod
[06.16. - 23:04:27] [RULES__ERROR] Unable to find rule 'Aggro:IncapacitateAggroMod'
[06.16. - 23:04:27] [RULES__ERROR] Unable to interpret rule record for Aggro:IncapacitateAggroMod
[06.16. - 23:04:27] [RULES__ERROR] Unable to find rule 'Aggro:MovementImpairAggroMod'
[06.16. - 23:04:27] [RULES__ERROR] Unable to interpret rule record for Aggro:MovementIm

[06.16. - 23:04:27] [RULES__ERROR] Unable to find rule 'Combat:HitPerLevelDiff'
[06.16. - 23:04:27] [RULES__ERROR] Unable to interpret rule record for Combat:HitPerLevelDiff

06.16. - 23:04:27] [RULES__ERROR] Unable to find rule 'Combat:MeleeHitChanceMod'
[06.16. - 23:04:27] [RULES__ERROR] Unable to interpret rule record for Combat:MeleeHitChanceMod
[06.16. - 23:04:27] [RULES__ERROR] Unable to find rule 'Combat:PriestHitChanceMod'
[06.16. - 23:04:27] [RULES__ERROR] Unable to interpret rule record for Combat:PriestHitChanceMod
[06.16. - 23:04:27] [RULES__ERROR] Unable to find rule 'Combat:CasterHitChanceMod'
[06.16. - 23:04:27] [RULES__ERROR] Unable to interpret rule record for Combat:CasterHitChanceMod
[06.16. - 23:04:27] [RULES__ERROR] Unable to find rule 'Combat:HeavyAvoidChanceMod'
[06.16. - 23:04:27] [RULES__ERROR] Unable to interpret rule record for Combat:HeavyAvoidChanceMod
[06.16. - 23:04:27] [RULES__ERROR] Unable to find rule 'Combat:ModerateAvoidChanceMod'
[06.16. - 23:04:27] [RULES__ERROR] Unable to interpret rule record for Combat:ModerateAvoidChanceMod
[06.16. - 23:04:27] [RULES__ERROR] Unable to find rule 'Combat:LightAvoidChanceMod'
[06.16. - 23:04:27] [RULES__ERROR] Unable to interpret rule record for Combat:LightAvoidChanceMod
[06.16. - 23:04:27] [RULES__ERROR] Unable to find rule 'Combat:UnarmoredAvoidChanceMod'
[06.16. - 23:04:27] [RULES__ERROR] Unable to interpret rule record for Combat:UnarmoredAvoidChanceMod

**trevius** · #3 06-16-2009, 05:22 PM

Many rules have been removed, so you can remove them from your rule_values table if you wish. But, those rule errors don't matter. What does matter is this error:

Code:

#1054: Unknown column 'augslot1visible' in 'field list'

It looks like you missed an SQL update from way back when the aug unknown was changed to the new augslot1visible field name.

See if this SQL helps:
/utils/sql/svn/292_augslots.sql

Dodie · #4 06-16-2009, 06:01 PM

I tried that one and it sais ERROR Check that column/key exists

and unknown column ' bla bla ' in items

**trevius** · #5 06-16-2009, 06:26 PM

If you sourced in items-0.6.0-DR2-0.6.1-DR1-convert.sql while trying to fix your other issues, that is probably the cause of your current problems. You need to revert back to before you sourced that in if possible.

Dodie · #6 06-16-2009, 06:32 PM

Ah, I probably did that. Hmm, I don't really have anything done on the DB, could I just reinstall in some quick way?

Thanks for assisting.

**trevius** · #7 06-16-2009, 06:56 PM

You should just need to download the latest PEQ DB update from their SVN and source it all in again to overwrite everything else you have in there now. Then, you will probably still need to run any SQL updates that came since the last PEQ DB version if it doesn't currently include the Heroic Resists and maybe some other stuff.