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

Xaron

Member
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!
 
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...
 
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.
 
Top Bottom