1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Error : 1062 - Please Help

Discussion in 'vBulletin' started by kiddie, Oct 6, 2010.

0
  1. #1
    I transferred my forum to a new host. Now when I post a New thread or New Reply I get the following error:

    Database error in vBulletin 3.8.1:

Invalid SQL:

				INSERT INTO postlog
				(postid, useragent, ip, dateline)
				VALUES
				(280730, 'Opera/9.80 (Windows NT 5.1; U; en) Presto/2.6.30 Version/10.62', 1976013126, 1286406175);

MySQL Error   : Duplicate entry '280730' for key 1
Error Number  : 1062
Request Date  : Wednesday, October 6th 2010 @ 06:02:55 PM
Error Date    : Wednesday, October 6th 2010 @ 06:02:56 PM
Script        : http://myforum.com/forum/newthread.php?do=postthread&f=27
Referrer      : http://myforum.com/forum/newthread.php?do=newthread&f=27
IP Address    : XXX-XXX-XXX-XXX
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.91-community
    Code (markup):
    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. Any thoughts on how to fix this?
     
    kiddie, Oct 6, 2010 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,333
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    Everything from postlog is deleted after 7 days by default anyway... the (easiest) thing to do might be to just delete all the records from the postlog table (it's basically logging user agents of people who posted).

    It's used for detecting spammers.
     
    digitalpoint, Oct 7, 2010 IP
  3. kiddie

    kiddie Peon

    Messages:
    76
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanks for your advice Shawn, my forum is working now.
     
    kiddie, Oct 7, 2010 IP