Forum Thread Posting MySQL Error
 

I just installed a clean 4.0.2, setup all the sections, did permissions, etc.

I posted two threads successfully, but upon trying to post a third, I received this error:

Quote:
Database error in vBulletin 4.0.2:

Invalid SQL:

INSERT INTO postlog
(postid, useragent, ip, dateline)
VALUES
(6, 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1.8) Gecko/20100202 Firefox/3.5.8', 1658896956, 1267957196);

MySQL Error : Duplicate entry '6' for key 'PRIMARY'
Error Number : 1062vb
Request Date : Sunday, March 7th 2010 @ 11:19:56 AM
Error Date : Sunday, March 7th 2010 @ 11:19:56 AM
Script : http://*/upload/newthread.php?do=postthread&f=46
Referrer : http://*/upload/newthread.php?do=newthread&f=46
IP Address : *
Username : Palidino
Classname : vB_Database
MySQL Version : 5.1.41-community

I tried repairing/optimizing the tables in the AdminCP, but that didn't help. That message appears every time I try to post a thread now.

Also, the thread does still post even though an error is displayed, but options such as sticky and close aren't applied.

EDIT:
I used phpmyadmin to clear all the entries in the postlog and it seems to be working fine now.