Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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

  • #2
    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.

    Comment


    • nunos
      nunos commented
      Editing a comment
      Thanks shalmaxb, deleted the duplicate entry, all working!

  • #3
    Thanks shalmaxb!!!

    Going to look into it

    Nuno

    Comment

    Working...
    X