Jump to content

[10312][fix] Crash on aura save


Recommended Posts

Posted

Way to reproduce:

1. Cast any spell that apply aura on self

2. Ask someone to cast same spell on you. Spell must stack from different casters

3. Use .save

4. See error like:

SQL: INSERT INTO character_aura (guid, caster_guid, spell, stackcount, remaincha
rges, basepoints0, basepoints1, basepoints2, maxduration0, maxduration1, maxdura
tion2, remaintime0, remaintime1, remaintime2, effIndexMask) VALUES
('9', '9', '4
8441', '1', '0', '1662', '0', '0', '18000', '0', '0', '15800', '0', '0', '1')
SQL ERROR: Duplicate entry '9-48441' for key 'PRIMARY'

Fix:

ALTER TABLE `character_aura` DROP PRIMARY KEY;
ALTER TABLE `character_aura` ADD PRIMARY KEY (`guid`,`caster_guid`,`spell`);

ALTER TABLE `pet_aura` DROP PRIMARY KEY;
ALTER TABLE `pet_aura` ADD PRIMARY KEY (`guid`,`caster_guid`,`spell`);

(old primary key was guid + spell)

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use