PDA

View Full Version : Database error - New Reply and New Thread


thetechgenius
08-20-2014, 12:11 AM
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
08-20-2014, 12:18 AM
That may be from a mod, so lets try this.

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

define('DISABLE_HOOKS', true);

So it looks like this:
<?php
define('DISABLE_HOOKS', true);
/*================================================= =====================*\
|| ################################################## ################## ||
|| # vBulletin 4.2.2

Then see if the error still happens.

thetechgenius
08-20-2014, 12:37 AM
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
08-20-2014, 12:38 AM
Yeah that was my next step, after trying to verify if it was from a mod.