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)