Log in

View Full Version : Database Error when I try to add new thread?


ChEckM@tE
11-18-2009, 05:12 AM
Hi


I face this error message when I try to add new thread


Database error in vBulletin 3.7.6:

Invalid SQL:
INSERT INTO post
(showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, dateline, ipaddress, attach, threadid)
VALUES
(1, 1, 'XXXXX', 1, 'XXXXX', 'XXXXX', 0, 1, 1258503483, '87.84.140.68', 0, 64838);

MySQL Error : Duplicate entry '765099' for key 1
Error Number : 1062
Request Date : Wednesday, November 18th 2009 @ 03:18:03 AM
Error Date : Wednesday, November 18th 2009 @ 03:18:04 AM
Script : http://www.XXXXXX/vb/newthread.php?do=postthread&f=20
Referrer : http://www.XXXXXX/vb/newthread.php?do=newthread&f=20
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.81-community






How can I solve it?
Is it servers problem ?



thanks

Lynne
11-18-2009, 02:04 PM
Have you tried running repair/optimize on the post table? Also, try a search because I've seen this come up before, I just don't recall the exact fix.

Marco van Herwaarden
11-23-2009, 06:47 AM
Try running rebuild uniwue indexes from Maintenance in the AdminCP.