Mercury Forever Posted February 3, 2023 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,
Jim M Posted February 4, 2023 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.
Mercury Forever Posted February 5, 2023 Author 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,
Marc Posted February 6, 2023 Posted February 6, 2023 It may be worth mentioning that in your ticket in case it still needs looking at further
Recommended Posts