Announcement

Collapse
No announcement yet.

Database error (times 200)

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

  • Database error (times 200)

    Hello,
    Sorry if I'm reposting a problem that was already asnwered, but I wanted to make sure what other people were getting is the same one as me.

    Here's the e-mail that I've gotten over 200 copies of over the weekend

    --------------------------------------

    Database error in vBulletin 3.5.4:
    Invalid SQL:
    SELECT
    post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
    user.*, userfield.*, usertextfield.*,

    avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,


    editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
    editlog.reason AS edit_reason,
    post_parsed.pagetext_html, post_parsed.hasimages,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid


    FROM vb_post AS post
    LEFT JOIN vb_user AS user ON(user.userid = post.userid)
    LEFT JOIN vb_userfield AS userfield ON(userfield.userid = user.userid)
    LEFT JOIN vb_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

    LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)

    LEFT JOIN vb_editlog AS editlog ON(editlog.postid = post.postid)
    LEFT JOIN vb_post_parsed AS post_parsed ON(post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)

    WHERE post.postid IN (0,93952,93953,93954,93956,93957,93958,93970,93982,93987,94018)
    ORDER BY post.dateline;
    MySQL Error : Table './freebordforum/vb_post_parsed' is marked as crashed and last (automatic?) repair failed Error Number : 144
    Date : Monday, September 25th 2006 @ 10:50:45 AM
    Script : http://www.freebord.com/forum/showthread.php?t=6228
    Referrer : http://www.freebord.com/forum/forumdisplay.php?f=14
    IP Address : 71.135.141.199
    Username : Unregistered
    Classname : vb_database

    ---------------------------------------

    should I talk to my host about this?

    You cant look at any thread on our forum right now and every time someone tries to (there are 18 users on as I'm writing this) it sends me this warning.

    Thanks for any help you guys could provide me with
    Last edited by Freeborder; Mon 25th Sep '06, 11:27am.

  • #2
    MySQL error: 144 = Table is crashed and last repair failed

    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 -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue
    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.


    Comment


    • #3
      Fixed

      Awesome. Thanks a grip Steve- you rock it

      vBulletin's customer service is the best I've gotten from any software company.

      All the kids at freebord.com/forum thank you as well. They were bummin without their forum fix.

      Comment


      • #4
        Glad to help.
        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.


        Comment


        • #5
          We have same right now

          Tried above advice (twice) but it it hangs..

          And wont let us even manually repair simple tables..

          What to do now?

          Thanks

          I get this at the Admin CP

          Database error in vBulletin 3.6.4:

          Invalid SQL:
          SELECT COUNT(*) AS count FROM post WHERE dateline >= 1165986000;

          MySQL Error : Table './FORUMNAME_board/post' is marked as crashed and last (automatic?) repair failed
          Error Number : 144
          Date : Wednesday, December 13th 2006 @ 09:42:00 AM
          Script : http://www.FORUMNAME/board/admincp/index.php?do=home
          Referrer : http://www.FORUMNAME/board/admincp/
          IP Address :
          Username : (mine)
          Classname : vb_database
          Last edited by Make Money?-old; Wed 13th Dec '06, 5:55am.

          Comment


          • #6
            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 can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

            If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables.

            Please let it run until finished as some repairs might take some time.
            Want to take your board beyond the standard vBulletin features?
            Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

            Comment

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