Announcement

Collapse
No announcement yet.

Problem after upgrading MySQL - error 1062

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem after upgrading MySQL - error 1062

    I opened a ticket yesterday afternoon and haven't heard back - does anyone look at the tickets on the weekend or did I screw it up by adding more and more info?

    Maybe someone can help with this here?

    Among other things that happened after updating MYSQL when trying to post you get this error message but when you refresh the page with the error it says that it's a duplicate post and the post or thread appears. If you are posting in an existing thread the thread isn't bumped up unless you go back into it and click edit.

    Database error in vBulletin 4.2.2:

    Invalid SQL:

    INSERT INTO postlog
    (postid, useragent, ip, dateline)
    VALUES
    (2094140, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2582.0 Safari/537.36', 1165359511, 1449345009);

    MySQL Error : Duplicate entry '2094140' for key 'PRIMARY'
    Error Number : 1062
    Request Date : Saturday, December 5th 2015 @ 11:50:09 AM
    Error Date : Saturday, December 5th 2015 @ 11:50:09 AM
    Database error in vBulletin 4.2.2:

    Invalid SQL:

    INSERT INTO postlog
    (postid, useragent, ip, dateline)
    VALUES
    (2094140, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2582.0 Safari/537.36', 1165359511, 1449345009);

    MySQL Error : Duplicate entry '2094140' for key 'PRIMARY'
    Error Number : 1062
    Request Date : Saturday, December 5th 2015 @ 11:50:09 AM
    Error Date : Saturday, December 5th 2015 @ 11:50:09 AM
    Script : http://www.xxxxx
    Referrer : http://www.xxxx
    IP Address : xxxx
    Username : xxxx
    Classname : vB_Database
    MySQL Version : 5.5.46-cll
    Classname : vB_Database
    MySQL Version : 5.5.46-cll

    Thanks!

  • #2
    truncate table postlog

    Comment


    • #3
      or just run a repair on it.
      Baby, I was born this way

      Comment

      Related Topics

      Collapse

      Working...
      X