Everytime I upload my profile, there is a duplicate entry in Enchantment (cloak enchant) that causes a failure in the update.
1062: Duplicate entry '53-Enchantement-Ench. de cape (Résistance aux arcanes supérieu' for key 1
SQL:
INSERT INTO `roster_recipes` SET `member_id` = '53', `recipe_id` = '44596', `item_id` = '', `recipe_name` = 'Ench. de cape (Résistance aux arcanes supérieure)', `recipe_type` = 'Enchanter', `skill_name` = 'Enchantement', `difficulty` = '1', `item_color` = '', `reagents` = 'Poussière d\'infini [x20]
Terre éternelle [x1]', `recipe_texture` = 'trade_engraving', `recipe_tooltip` = 'Enchantement: Ench. de cape (Résistance aux arcanes supérieure)\nComposants : |n|cffff2020Poussière d\'infini (20)|r, |cffff2020Terre éternelle|r\nEnchante de manière permanente une cape. Cette dernière augmente la résistance aux Arcanes de 20. Nécessite un objet de niveau 60 ou supérieur.'
File: lib/dbal/mysql.php
Line: 234
OK, duplicate names aren't WoWroster's problem, that's Blizzard Localization team problem.
But the problem is that the update die on this, instead of continuing (and logging the error, of course), so everything is messed up for a SINGLE duplication... Worst, the "recipe_id" is NOT the same for each enchant, and is unique. Indexing by ID instead of name should have solved this problem without any error.
Can I expect a fix, or at least a more tolerant update ?
Thanks.
