vBulletin 4.2.1 Database Error (Help)

[To0]

I am receiving an error when trying post a NEW THREAD on my forum. This error also occurs when trying to make a post. The forum will show the thread after the error occurs and will update the forum to show the number of threads, but will not update the number of posts.


Error:

Database error in vBulletin 4.2.1:


Invalid SQL:


INSERT INTO postlog
(postid, useragent, ip, dateline)
VALUES
(12, '******);


MySQL Error : Duplicate entry '12' for key 'PRIMARY'
Error Number : 1062
Request Date : Sunday, October 13th 2013 @ 09:25:53 PM
Error Date : Sunday, October 13th 2013 @ 09:25:54 PM
Script : ******
Referrer : ******
IP Address : *****
Username : *****
Classname : vB_Database
MySQL Version : 5.5.32-cll

Here's what I have done to try and resolve the issue so far..
1.) Repaired / Optimized Tables - Didn't fix the error.
2.) Turned off all plugins / hooks - Didn't stop the error.
3.) Ran Queries to create proper indexes for all the tables - Didn't fix the error


I am unsure as to what is causing the issue as usually this is caused by a plugin/hook, but like I said I disabled the plugin/hook system and it still has the error.


If anyone can help me I'd appreciate it.


Thanks in advance!

 

[blinkracer]

primary key must be unique, and the value 12 exist in your database.
make "post id" in auto increment
(sorry for my bad English)

 

[perfectRDP]

I believe indexes and auto-increments were removed from post and thread

 

[Tango]

You don't need the data in that table, try to truncate it, if that doesn't fix it re-create the table

CREATE TABLE IF NOT EXISTS `vb_postlog` (   `postid` int(10) unsigned NOT NULL DEFAULT '0',   `useragent` char(100) NOT NULL DEFAULT '',   `ip` int(10) unsigned NOT NULL DEFAULT '0',   `dateline` int(10) unsigned NOT NULL DEFAULT '0',   PRIMARY KEY (`postid`),   KEY `dateline` (`dateline`),   KEY `ip` (`ip`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

[-sky-]

go to phpmyadmin and emty the postlog