Rev 666

[cavedude]

You don't want to source that file! It's ancient and that error should be removed from the EQEmu source. More than likely, you just missed the item update in 665. Either source that in, or use the PEQ database which is already up to date.

[WillowyLady]

Using ver 678, no problems now:0

Issue was caused by sourcing in items-0.6.0-DR2-0.6.1-DR1-convert.sql

There was an error message right after this lot

[Error] DBLoadItems query 'select source,`itemclass`,`name`,`lore`,`idfile`,`id`,`we ight`,`norent`,`nodrop`,`size`,`slots`,`price`,`ic on`,`UNK012`,`UN
K013`,`benefitflag`,`tradeskills`,`cr`,`dr`,`pr`,` mr`,`fr`, Blah Blah etc..

which mentioned to source in items-0.6.0-DR2-0.6.1-DR1-convert.sql

Sourcing that bugger in was the cause of my problem.

All appears to be OK now>)

[cavedude]

I changed the error in the latest revision of the code. Hopefully, that will stop confusing people.

[Dodie]

Originally Posted by cavedude

You don't want to source that file! It's ancient and that error should be removed from the EQEmu source. More than likely, you just missed the item update in 665. Either source that in, or use the PEQ database which is already up to date.

Sorry for being stupid, but could u direct me to the item update in 665? been ages and im new to svn, or if anyone else could... thanks

[cavedude]

EQEmuServer/utils/sql/svn/665_heroic_resists.sql is the file you're looking for.

[Dodie]

It said duplicated entry column or something when i sourced it so i got error again....lol something is wrong

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

[Dodie]

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]

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:

#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