Duplicate entry for key 1

tekstylez

vBulletin wanabie

#1 08-24-2006, 08:03 AM

tekstylez will become famous soon enough

Join Date: Aug 2006

Posts: 6

Duplicate entry for key 1

Multiple database errors.... (21 to be exact)

Code:

Database error in vBulletin 3.6.0:

Invalid SQL:
INSERT INTO userfield
       (userid)
VALUES
       (640);

MySQL Error  : Duplicate entry '640' for key 1

vb support will not support me because I have hacks installed..... What should I do?

Quote |

Brandon

vBSetup Team
vBulletin Owner
vBSetup Owner

#2 08-24-2006, 10:32 AM

Join Date: Jul 2006

Posts: 9,808

Location: Topeka, KS

Re: Duplicate entry for key 1

tekstylez, Welcome to vbulletinsetup

when do u see these errors ?
and can you post more of the error ?
what are the recent hacks that you added ?

--------------------

Brandon Sheley / vBulletin Setup Staff
Check out our Newsletter for the latest vB and SEO news.
Are you looking for vBulletin work to be done on your forums ?
Would you like to Help Support vBulletin Setup.

Post your URL and a link to your vb.com username here to get full access.

Please do not PM me for support, that's what the forums are for.

Have you heard about Crowdgather?
Find it on Forums

Stay up to date by installing our Tool Bar

Quote |

tekstylez

vBulletin wanabie

#3 08-24-2006, 10:47 AM

Join Date: Aug 2006

Posts: 6

Re: Duplicate entry for key 1

Here are the products I have installed

Code:

Advance Sticky Options
Advanced BBCode Permissions 	
Advanced Threads 	1.0 	
Atakan Marquee Text 	
Custom Links 	
Cyb - Advanced Forumhome Statistics 	3.2 	
Cyb - Advanced Permissions Based on User's Post Co 	
Cyb - Check If Already Posted 	
Cyb - Sub-Forums Arranger 	1.7 	
Extended reputation display 	2.12 	
Global Announcement 	1.2 	
Hide Links From Guests 	1.22 	
Member Profile Reputation Display 	
Members who have read a thread. 	
Members who have visited the forum 	4.32 	
Menu Control 	1.3 	
Post Thank You Hack 	5.0  
Separate Sticky and Normal Threads 	1.0.5 	
Top Posters 	3.22 	
Display the Forums Top Posters 	
vBShout 	2.0 	
Welcome Headers

And this is the error

Code:

Database error in vBulletin 3.6.0:

Invalid SQL:
INSERT INTO userfield
       (userid)
VALUES
       (661);

MySQL Error  : Duplicate entry '661' for key 1
Error Number : 1062
Date         : Thursday, August 24th 2006 @ 10:42:17 AM
Script       : http://www.forum.tekstylez.com/register.php?do=addmember
Referrer     : http://www.forum.tekstylez.com/register.php?do=addmember
IP Address   : 85.212.39.13
Username     : akim
Classname    : vb_database

Everytime a new user registers, I get this message
Thanks for helpin man

Quote |

Brandon

vBSetup Team
vBulletin Owner
vBSetup Owner

#4 08-24-2006, 11:14 AM

Join Date: Jul 2006

Posts: 9,808

Location: Topeka, KS

Re: Duplicate entry for key 1

okay, I'll have to wait till after lunch to check it out.

--------------------

Post your URL and a link to your vb.com username here to get full access.

Please do not PM me for support, that's what the forums are for.

Have you heard about Crowdgather?
Find it on Forums

Stay up to date by installing our Tool Bar

Quote |

Brandon

vBSetup Team
vBulletin Owner
vBSetup Owner

#5 08-24-2006, 12:11 PM

Join Date: Jul 2006

Posts: 9,808

Location: Topeka, KS

Re: Duplicate entry for key 1

have you added any of this hacks recently ?
try updating your counters
also, i don't understand why u have your like

teKstyLez - Powered by vBulletin

maybe you have your general settings off, its hard to say without looking at the acp

--------------------

Post your URL and a link to your vb.com username here to get full access.

Please do not PM me for support, that's what the forums are for.

Have you heard about Crowdgather?
Find it on Forums

Stay up to date by installing our Tool Bar

Quote |

tekstylez

vBulletin wanabie

#6 08-24-2006, 12:47 PM

Join Date: Aug 2006

Posts: 6

Re: Duplicate entry for key 1

OK< i believe I fixed the issue by rebuilding my counters... I'll post if I'm wrong...

I dont understand your third commet

Quote:

also, i don't understand why u have your like

teKstyLez - Powered by vBulletin

What are you saying you dont understand? what can i do to fix it>?

Quote |

Brandon

vBSetup Team
vBulletin Owner
vBSetup Owner

#7 08-24-2006, 12:54 PM

Join Date: Jul 2006

Posts: 9,808

Location: Topeka, KS

Re: Duplicate entry for key 1

oh, well the vbseo pulled your title, so it wasn't real obvious but i see your site is like this one, with the forum in a sub folder.. but you have a forum.php file,, like u renamed the index.php to this..
are you planning on adding a cms, maybe that why u did it..

like default would be

forum.sitename.com/index.php
but u have
forum.sitename.com/forum.php

see what I'm saying ?

and glad the update counters works, at least I hope it works

btw, u might want to check this out
Powered by vBulletin in title tag [how to remove]
actually there are many threads in that forum that can help your site

--------------------

Post your URL and a link to your vb.com username here to get full access.

Please do not PM me for support, that's what the forums are for.

Have you heard about Crowdgather?
Find it on Forums

Stay up to date by installing our Tool Bar

Quote |

tekstylez

vBulletin wanabie

#8 08-24-2006, 01:23 PM

Join Date: Aug 2006

Posts: 6

Re: Duplicate entry for key 1

Updating the counters did not work

Still getting the same error... thanks for the other info though..

Quote |

Brandon

vBSetup Team
vBulletin Owner
vBSetup Owner

#9 08-24-2006, 01:54 PM

Join Date: Jul 2006

Posts: 9,808

Location: Topeka, KS

Re: Duplicate entry for key 1

hmm,, it's hard to say.
it's acting like your user # is off one number
do u know what the last mods/hacks where that you installed, and if this error was happening b4 them.

--------------------

Post your URL and a link to your vb.com username here to get full access.

Please do not PM me for support, that's what the forums are for.

Have you heard about Crowdgather?
Find it on Forums

Stay up to date by installing our Tool Bar

Quote |

tekstylez

vBulletin wanabie

#10 08-24-2006, 03:28 PM

Join Date: Aug 2006

Posts: 6

Re: Duplicate entry for key 1

I posted my plugin list above. Its hard to tell which one it could be. This is a new forum, so Ive been installing hacks everyday since we launched a week ago. I looked into my email log, and it seems I started recieving this error about 3 days ago...

Quote |