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

XF 1.1 Mysqli statement execute error : Duplicate entry...

Discussion in 'Troubleshooting and Problems' started by Xaron, Jun 28, 2013.

  1. Xaron

    Xaron Member

    Hi all,

    at the moment new users can't register in my forum.

    The error log says:
    Mysqli statement execute error : Duplicate entry '1221' for key 'PRIMARY'1 minute ago - library/Zend/Db/Statement/Mysqli.php:214
    Must be the user table I guess. Any ideas? THANKS!
  2. Mike

    Mike XenForo Developer Staff Member

    What's the rest of the error? There should be a full back trace (with files and line numbers).
  3. Xaron

    Xaron Member

    Well some more things I did (because I guess it's my fault):

    I had XF 1.1.1 installed and a massive spam problem a while ago. So 1.1.1 had no comfortable way of batch processing that bunch of more than thousand spam users so I deleted them in the database directly.

    For now I solved the issue by just setting the auto-increment value of the primary key to a higher one...
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    It was probably a leftover record in one of these tables:


    But increasing the autoincrement is a good fix.

Share This Page