Mercury Forever Posted February 3, 2023 Share Posted February 3, 2023 Hi Community..!! mysqltuner recommends that I execute the statement to recover space in this table, however, in its execution it requests a duplication. mysql> ALTER TABLE `database`.`ibf_core_achievements_log` FORCE; ERROR 1062 (23000): Duplicate entry '215209.2023-02-03-core_SessionStartDaily' for key 'lookup' Can the content of this table be deleted? Or, is there an option in the ACP that allows me to keep it?? Regards, Link to comment Share on other sites More sharing options...
Jim M Posted February 4, 2023 Share Posted February 4, 2023 The table holds the log of Achievements and various data, there should not be duplicate keys. I've moved this to a ticket so that we can further investigate. Please check for your email for next steps. Link to comment Share on other sites More sharing options...
Mercury Forever Posted February 5, 2023 Author Share Posted February 5, 2023 Hi Jim, I'm telling you that I found this option "ACP-> Member-> ACHIEVEMENTS-> Rebuild Members' Achievements" and when I run it the message has disappeared. I am leaving this path as a temporary solution if it is presented to another user. Regards, Link to comment Share on other sites More sharing options...
Marc Stridgen Posted February 6, 2023 Share Posted February 6, 2023 It may be worth mentioning that in your ticket in case it still needs looking at further Link to comment Share on other sites More sharing options...
Recommended Posts