Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 08 Feb 2017, 16:02
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
vbulletin Duplicate entry '###' for key 'PRIMARY' in ..../includes/class_core.php on

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
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #2  
Old 08 Feb 2017, 17:51
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Have you run repair/optimize on the usertextfield table?
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 08 Feb 2017, 17:53
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
I did so earlier but haven't tested yet.

Thanks
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #4  
Old 08 Feb 2017, 17:54
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: 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.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #5  
Old 08 Feb 2017, 18:20
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
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
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #6  
Old 08 Feb 2017, 22:09
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Check what the largest userid is in your user table. Then check what the largest userid is in your usertextfield table is.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #7  
Old 08 Feb 2017, 23:55
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
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 09 Feb 2017 at 00:32 ---------------

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

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.


Last edited by RichieBoy67; 09 Feb 2017 at 00:28.
Reply With Quote
  #8  
Old 09 Feb 2017, 16:59
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: 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.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #9  
Old 09 Feb 2017, 19:16
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
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.
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.


Last edited by RichieBoy67; 10 Feb 2017 at 15:12.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 06:56.

Layout Options | Width: Wide Color: