[fixed] Rune of spellshattering stops characters from being saved

[Alexstrasza]

steps to reproduce:

any DeathKnight character must engrave their 2H-weapon with rune of spellshattering:

skill: http://www.wowhead.com/spell=53342

resulting aura: http://www.wowhead.com/spell=53362

after engraving character will not be saved into db due to duplicate keys in table

SQL ERROR: Duplicate entry '110-53362' for key 1

SQL: INSERT INTO character_aura (guid, caster_guid, spell, stackcount, remaincharges, basepoints0, basepoints1, basepoints2, maxduration0, maxduration1, maxduration2, remaintime0, remaintime1, remaintime2, effIndexMask) VALUES

('110', '110', '53362', '1', '0', '-4', '0', '0', '-1', '0', '0', '-1', '0', '0', '1')

SQL ERROR: Duplicate entry '110-53362' for key 1

software revisions:

MaNGOS/0.17.0 (2010-07-08 02:56:36 Revision 10158 - 220a1136249293af05b93366fafc20542288a832) for Linux_x64 (little-endian)

Using script library: ScriptDev2 (for MaNGOS 10153+) Revision [1737] 2010-07-05 10:11:09 (Unix)

Using World DB: YTDB_0.13.7_R555_MaNGOS_R10150_SD2_R1736_ACID_R304_RuDB_R37.8

[zergtmn]

Probably fixed in 10160.

[Alexstrasza]

It is not

[10176]

SQL: INSERT INTO character_aura (guid, caster_guid, spell, stackcount, remaincharges, basepoints0, basepoints1, basepoints2, maxduration0, maxduration1, maxduration2, remaintime0, remaintime1, remaintime2, effIndexMask) VALUES

('53', '53', '53362', '1', '0', '-4', '0', '0', '-1', '0', '0', '-1', '0', '0', '1')

SQL ERROR: Duplicate entry '53-53362' for key 1

software:

MaNGOS/0.17.0 (2010-07-10 18:52:22 Revision 10176 - 9953b123a7589656c0aa7035ed9a488de7a9c34b) for Linux_x32 (little-endian)

Using script library: ScriptDev2 (for MaNGOS 10153+) Revision [1740] 2010-07-09 21:16:10 (Unix)

Using World DB: YTDB_0.13.7_R555_MaNGOS_R10150_SD2_R1736_ACID_R304_RuDB_R37.8

Using creature EventAI: ACID 3.0.4 - Final Release for Mangos (3.3.2 Client)

ps: all sql updates for 10176 applied

[Athor]

bug confirmed on 10309 scriptdev2 1755 no patch

had 2 dk player complaining about char not saved after leaving game - same dberror.log report than above & changing rune solving issue.

2010-08-08 03:03:19 SQL: INSERT INTO character_aura (guid, caster_guid, spell, stackcount, remaincharges, basepoints0, basepoints1, basepoints2, maxduration0, maxduration1, maxduration2, remaintime0, remaintime1, remaintime2, effIndexMask) 
VALUES
('64670', '64670', '53362', '1', '0', '-4', '0', '0', '-1', '0', '0', '-1', '0', '0', '1')
2010-08-08 03:03:19 SQL ERROR: Duplicate entry '64670-53362' for key 1

[ckegg]

The enchanting spell "Black Magic" got the same problem too

http://www.wowhead.com/spell=59630

After the SQL ERROR: Duplicate entry log , the next one is SQL ROLLBACK, and everything before that is reverted,

[VladimirMangos]

Some auras applied independently for both weapon, but we not save item connected to aura at aurra save.

in result at loading aura lost connection with cast item and considered in checks as "another weapon" aura, in result we have some "cheating" double buff result for 2h weapon.

but it also in result this character can't save.

Must be fixed into [10332-10333]