No announcement yet.

10,000 vB database error messages

  • Filter
  • Time
  • Show
Clear All
new posts

  • 10,000 vB database error messages

    This morning we woke to over 10,000 vBulletin database error messages like these:

    Database error in vBulletin 3.8.4:
    Invalid SQL:
    IF(votenum >= 1, votenum, 0) AS votenum,
    IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
    post.pagetext AS preview,
    thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open,
    postusername, postuserid, thread.iconid AS threadiconid,
    thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach,
    thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount,
    IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
    thread.prefixid, thread.taglist, hiddencount, deletedcount

    FROM vb_thread AS thread

    LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid)

    WHERE thread.threadid IN
    (0,14947,116546,139360,14901,138141,104331,130312,135082,14963,130815,129718,129632,128528 ,18878,128272,128005,113170,102149,41294,120257)
    ORDER BY sticky DESC, lastpost DESC;
    MySQL Error : Table './dbname/vb_post' is marked as crashed and last
    (automatic?) repair failed
    Error Number : 144
    Request Date : Wednesday, December 28th 2011 @ 08:20:23 AM
    Error Date : Wednesday, December 28th 2011 @ 08:20:23 AM
    Script :
    Referrer :
    IP Address :
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :

    This is an odd one involving cron
    Invalid SQL:

    DELETE FROM vb_posthash
    WHERE dateline < 1325035427;

    MySQL Error : Incorrect key file for table './dbname/vb_posthash.MYI'; try to repair it
    Error Number : 126
    Request Date : Wednesday, December 28th 2011 @ 01:28:47 AM
    Error Date : Wednesday, December 28th 2011 @ 01:28:48 AM
    Script :
    Referrer :
    IP Address :
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :
    Our db that is almost 1Gb is now 300Mb. Yes, we have backups, but no point restoring and opening the forum if we don't know what happened. Any help will be appreciated.Bob

  • #2
    You need to repair your tables as the error messages state..

    Run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

    Admin Control Panel -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

    If you cannot access the Admin CP, then you can 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.

    Appears your server may have cycled its power while files were opened and locked causing these issues.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API


    • #3
      Thanks for the quick reply Wayne, greatly appreciated. Repair of vb_post by any means does not work, it just hangs and then falls over. I think a restore from a backup is the best way forward. Interesting comment about the server power cycle, I will pass that to the host.



      • #4
        If you know what you are doing, you can try manually dropping the vb_post indexes, and then [manually] re-creating them.
        Baby, I was born this way


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