No announcement yet.

mysql error number: 1062

  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql error number: 1062

    I keep getting this error message and Im not sure what the problem is.

    Database error in vBulletin 2.2.9:

    Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsign ature,ipaddress,iconid,visible) VALUES (NULL,'15166','','bugz','1522','1054923075','0','smh','1','1','','0','1')
    mysql error: Duplicate entry '155540' for key 1

    mysql error number: 1062

    Date: Friday 06th of June 2003 02:11:15 PM

    Anybody have any Idea???

  • #2
    Reupload the original newreply.php file from the vB zip file. Make sure you upload in ASCII and overwrite the one on the server.

    If you still have this problem, upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

    [Of course change the exact URL as appropriate for your forums.]

    If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok (except the session table which you can ignore.) See if this fixes the problem.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    • #3
      Thank you, I'll try that and let you know.


      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.