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,

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.

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,

 

It may be worth mentioning that in your ticket in case it still needs looking at further