1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Error Duplicate Entry :)

Discussion in 'Troubleshooting and Problems' started by J2A, Jun 26, 2011.

  1. J2A

    J2A Member

    Mysqli statement execute error : Duplicate entry '1137286' for key 1
     
  2. Slavik

    Slavik XenForo Moderator Staff Member

    What are you trying to do? But try running

    Code:
    mysqlcheck --auto-repair=true -uroot -p databasename
    
     
  3. J2A

    J2A Member

    Basically, it seems our DB has picked up an error on restore. Whats new reverts to that error.
     
  4. Slavik

    Slavik XenForo Moderator Staff Member

    Just to check, the database was completely empty before you restored?
     
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Do you have a more complete error with a stack trace?

    I have seen issues before where the autoincrement fields are no longer defined in the schema following a botched backup / restore of a database. You should check your schema using a program like phpmyadmin. Or try a different backup if you have one.
     

Share This Page