Error when trying to rebuild the database - ALERT: Rebuild database error:

[nunos]

Hi everyone,

I am stuck when trying to rebuild the database. an error shows up and the error log is displaying this message:

[2024-05-18 00:10:16] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'anna-0' for key 'user.UNIQ_USER_NAME_DELETE_ID'

The system is working normally but when i try to rebuild the database this error is displayed.

How can i solve this problem?

Thanks,

Nuno

[shalmaxb]

as the error states, you have a duplicate entry in users table of MySQL. Go there and delete the duplicate entry. Be sure to make a backup before.

[nunos]

Thanks shalmaxb, deleted the duplicate entry, all working!

[nunos]

Thanks shalmaxb!!!

Going to look into it

Nuno