Database error - New Reply and New Thread

[thetechgenius]

Database error in vBulletin 4.1.4:

Invalid SQL:

				INSERT INTO postlog
				(postid, useragent, ip, dateline)
				VALUES
				(35, 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:31.0) Gecko/20100101 Firefox/31.0', 1651769000, 1408496838);

MySQL Error   : Duplicate entry '35' for key 'PRIMARY'
Error Number  : 1062
Request Date  : Tuesday, August 19th 2014 @ 09:07:18 PM
Error Date    : Tuesday, August 19th 2014 @ 09:07:18 PM
Script        : http://thetechgenius.net/newthread.php?do=postthread&f=5
Referrer      : https://thetechgenius.net/newthread.php?do=newthread&f=5
IP Address    : *********
Username      : *********
Classname     : vB_Database
MySQL Version : 5.6.16

Any reason why I am getting this Database Error when I reply to a thread, or make a new thread? However, even when this error pops up, the thread/post still gets posted.

[ozzy47]

That may be from a mod, so lets try this.

Open your includes/config.php file and below<?php add this line:

PHP Code:

 define('DISABLE_HOOKS', true); 


So it looks like this:

PHP Code:

<?php
define('DISABLE_HOOKS', true);
/*=================================================  =====================*\
|| ##################################################  ################## ||
|| # vBulletin 4.2.2

Then see if the error still happens.

[thetechgenius]

Someone just told me to try and Repair/Optimize the Database Table "postlog" a couple of times. So thats what I did, and the errors stopped!!

Thank you for helping me though, you helped me a few times with my board.

[ozzy47]

Yeah that was my next step, after trying to verify if it was from a mod.