bluidkiti
05-27-2009, 05:52 PM
I transferred a database from an old domain to a new domain. Now when I post a New thread or New Reply I get the following:
Database error in vBulletin 3.8.2:
Invalid SQL:
INSERT INTO postlog
(postid, useragent, ip, dateline)
VALUES
(107975, 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10', 1191301508, 1243456087);
MySQL Error : Duplicate entry '107975' for key 1
Error Number : 1062
Request Date : Wednesday, May 27th 2009 @ 02:28:07 PM
Error Date : Wednesday, May 27th 2009 @ 02:28:09 PM
Script : http://www.yoursite.com/forums/newthread.php?do=postthread&f=24
Referrer : http://www.yoursite.com/forums/newthread.php?do=newthread&f=24
IP Address : XXXX
Username : XXXX
Classname : vB_Database
MySQL Version : 5.0.75-community-log
This pops up after I hit the submit button for a New Thread or New Reply. It doesn't do this with quick reply. It does post the thread or post. I just have to go back to the forum and refresh to see it Any thoughts on how to fix this?
Images also included below of problem.
12707
12708
Database error in vBulletin 3.8.2:
Invalid SQL:
INSERT INTO postlog
(postid, useragent, ip, dateline)
VALUES
(107975, 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10', 1191301508, 1243456087);
MySQL Error : Duplicate entry '107975' for key 1
Error Number : 1062
Request Date : Wednesday, May 27th 2009 @ 02:28:07 PM
Error Date : Wednesday, May 27th 2009 @ 02:28:09 PM
Script : http://www.yoursite.com/forums/newthread.php?do=postthread&f=24
Referrer : http://www.yoursite.com/forums/newthread.php?do=newthread&f=24
IP Address : XXXX
Username : XXXX
Classname : vB_Database
MySQL Version : 5.0.75-community-log
This pops up after I hit the submit button for a New Thread or New Reply. It doesn't do this with quick reply. It does post the thread or post. I just have to go back to the forum and refresh to see it Any thoughts on how to fix this?
Images also included below of problem.
12707
12708