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

#1
Hi all,

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

The error log says:
Code:
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!
 

Mike

XenForo developer
Staff member
#2
What's the rest of the error? There should be a full back trace (with files and line numbers).
 
#3
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...
 

Jake Bunce

XenForo moderator
Staff member
#4
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...
It was probably a leftover record in one of these tables:

http://xenforo.com/community/threads/script-to-create-a-new-user.21286/#post-270084

But increasing the autoincrement is a good fix.