Announcement

Collapse
No announcement yet.

Can't open file: 'post_parsed.MYI

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

  • Can't open file: 'post_parsed.MYI

    I woke up today and realized that my board was down. After checking couple things i get it fixed but one thing i am wondering why this error occured.

    Code:
    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.*,
    
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    ,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
    
    
    FROM post AS post
    LEFT JOIN user AS user ON(user.userid = post.userid)
    LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
    LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
    
    LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
    LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
    LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid AND post_parsed.styleid_code = 108 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = 108)
    
    WHERE post.postid = 113608;
    
    MySQL Error  : Can't open file: 'post_parsed.MYI' (errno: 145)
    Error Number : 1016
    Date         : Saturday, July 29th 2006 @ 04:32:39 AM
    Script       : http://www.ayyas.com/showpost.php?p=113608&postcount=3
    Referrer     : 
    IP Address   : ****
    Username     : Kayıtlı Değil
    Classname    : vb_database
    After repair and optimizing tables (2 times) the error is gone now. What can cause this ?

  • #2
    MySQL error 145 means that file has crashed. You will need to run optimize and repair from the shell of your account. If you don't have shell access contact your hosting provider to look into this.

    Comment


    • #3
      Originally posted by Floris View Post
      MySQL error 145 means that file has crashed. You will need to run optimize and repair from the shell of your account. If you don't have shell access contact your hosting provider to look into this.
      I have shell access is there a code i can find to do this ?

      Comment


      • #4
        Here's more information.

        http://www.vbulletin.com/docs/html/t...t_mysql_errors

        Comment

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