Announcement

Collapse
No announcement yet.

Database error (times 200)

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

  • Marco van Herwaarden
    replied
    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.

    Leave a comment:


  • Make Money?-old
    replied
    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 13 Dec '06, 5:55am.

    Leave a comment:


  • Steve Machol
    replied
    Glad to help.

    Leave a comment:


  • Freeborder
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    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

    Leave a comment:


  • Freeborder
    started a topic Database error (times 200)

    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 25 Sep '06, 11:27am.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X