Please help with a MYSQL Error

[apfparadise]

It's weird, nothing new installed for a while now, but starting an hour ago, can't reply to posts, get this error:


Database error in vBulletin 3.0.4:

Invalid SQL:
INSERT INTO post
(threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie,
showsignature, ipaddress, iconid, visible, attach)
VALUES
(4816, 37834, 'Re: New Digital Camera Purchase - Opinions Needed',
'paradise', 1, 1127854332,
'Nice cam, a bit of a problem with noise, but great starter DSLR on a budget.', 1, 1,
'67.52.104.81', 0, 1, 0)

mysql error: Duplicate entry '37835' for key 1

mysql error number: 1062

Date: Tuesday 27th of September 2005 03:52:12 PM
Script: http://aquatic-photography.com/forum/newreply.php
Referer: http://aquatic-photography.com/forum/showthread.php?t=4816

[Marco van Herwaarden]

Did you maybe restore some tables?

Otherwise you have a corrupt MySQL index, and if the mysql utilities can not fix it, you will probably have to restore