MySQL Error : Duplicate entry '87720' for key 1

[iFlames]

Database error in vBulletin 3.8.4:

Invalid SQL:
INSERT INTO post
    (showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, dateline, ipaddress, attach, threadid)
VALUES
    (1, 1, 'InFlames!', 2, 'test', 'test....', 0, 1, 1262794294, '210.211.241.53', 0, 87289);

MySQL Error   : Duplicate entry '87720' for key 1
Error Number  : 1062
Request Date  : Wednesday, January 6th 2010 @ 09:41:34 PM
Error Date    : Wednesday, January 6th 2010 @ 09:41:34 PM
Script        : http://www.warezxtreme.org/newthread.php?do=postthread&f=2
Referrer      : http://www.warezxtreme.org/newthread.php?do=newthread&f=2
IP Address    : xxx.xxx.xxx.xxx
Username      : InFlames!
Classname     : vB_Database
MySQL Version : 5.0.87-community

getting this error wen i try to post in any forum
i tried disabling plugins but didnt work
need help with this asap..

 

[Royal King]

Yea pl0x. I'll give you a candy if you help us

 

[deAthbLisS]

try repairing the table. i also sometimes get this error and repairing the table fixes it.

use this command
repair table post;

 

[clarksta]

read this: http://www.vbulletin.com/docs/html/mysql_duplicatekey

 

[Sandino]

In PHPMyAdmin try repairing the database

Alternatively you can try in VBulletin (also do i believe optimization there is an option)

If that does not work, then try this:
http://www.vbulletin.com/forum/showthread.php?168399-Duplicate-entry-0-for-key-1-issue

 

[Royal King]

Inflames fixed it. Thanks guys.