No announcement yet.

Post table issue

  • Filter
  • Time
  • Show
Clear All
new posts

  • Post table issue


    We had a sever crash and feedback via VB and our host to my collegue suggested the post table needed a rebuild.

    At first we could not access anything, just had database errors. I put in a fix tables and since then nothing

    Its trying to connect but times out.

    Any suggestions?


  • #2
    I am now getting an error 1062 on new posts being made.

    I have done all the fixes such as repair tables etc. Still nothing. Forum been down for 3 days now.

    Can anyone advise??? Thanks

    Database error in vBulletin 3.8.4:
    Invalid SQL:
    INSERT INTO postlog
    (postid, useragent, ip, dateline)
    (3018559, 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv: Gecko/20091102 Firefox/3.5.5 (.NET CLR 3.5.30729)', 1329768165, 1258166392);
    MySQL Error : Duplicate entry '3018559' for key 1
    Error Number : 1062
    Request Date : Saturday, November 14th 2009 @ 02:39:52 AM
    Error Date : Saturday, November 14th 2009 @ 02:39:57 AM
    Script :
    Referrer :


    • #3
      To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

      Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

      If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

      If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

      You may have to ask your host to try and repair this for you.
      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.


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