vbulletin Duplicate entry '###' for key 'PRIMARY' in ..../includes/class_core.php on

[RichieBoy67]

The issue is that an error is happening during registration..

Duplicate entry '###' for key 'PRIMARY' in ..../includes/class_core.php on line 1391

This has been going on awhile and the number goes up every time..

Database error in vBulletin 4.2.5 Beta 1:

Invalid SQL:
INSERT INTO usertextfield
(userid)
VALUES
(277);

MySQL Error : Duplicate entry '277' for key 'PRIMARY'

Thanks

[Lynne]

Have you run repair/optimize on the usertextfield table?

[RichieBoy67]

I did so earlier but haven't tested yet.

Thanks

[Paul M]

Have you tried repairing the usertextfield table (in fact, all the user tables) ?

If that doesnt work then I would say something is out of sync in your database, or maybe you have some addon creating duplicate records.

[RichieBoy67]

The repair didn't work. I'll check the plug ins later. I think the issue is a little deeper than that though..

Thanks much

[Lynne]

Check what the largest userid is in your user table. Then check what the largest userid is in your usertextfield table is.

[RichieBoy67]

I'll check, great idea.

Thanks

--------------- Added 08 Feb 2017 at 19:59 ---------------

Yeah, there is something messed up for sure.

User Table id only goes up to 278 while the usertext field goes up to 367...

--------------- Added 08 Feb 2017 at 20:27 ---------------

So I just have to delete all those usertext entries above 278?

I did do an import on this site a bunch of years ago. I am not sure if some of those users were duplicate or something like that possibly. We are going back to around 2010 I believe..

Thanks

--------------- Added [DATE]1486603944[/DATE] at [TIME]1486603944[/TIME] ---------------

One more mystery.. under users on the site I only see 137. This is a very niche client site and it does not have a ton of members but I am really confused as to what is going on..

[Lynne]

Very odd. But yeah, delete all those entries from the usertextfield (also check the table userfield). The user, userfield, and usertextfield tables should all have the same number of rows.

Your largest userid can be 278, but check how many rows are actually in that table. It could have just 137 rows.

[RichieBoy67]

Thanks Lynne,

I think the issue occurred initially years ago when I brought this site over from another forum. I cannot even remember the forum script but it had many issues and the import was a bear.

The owner also deleted many in active users so now the first user id starts somewhere in the hundreds and the last one as of yesterday was 278.. I could go through and delete the old rows but I think it should work fine just by deleting the usertext field rows.