Announcement

Collapse
No announcement yet.

Help, I'm Getting an Error

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

  • Help, I'm Getting an Error

    I am getting this database error whenever I try to click on a thread.



    Database error in vBulletin 2.3.2:
    Invalid SQL:
    SELECT
    post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
    attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
    ,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
    FROM post
    LEFT JOIN icon ON icon.iconid=post.iconid
    LEFT JOIN user ON user.userid=post.userid
    LEFT JOIN userfield ON userfield.userid=user.userid
    LEFT JOIN avatar ON avatar.avatarid=user.avatarid
    LEFT JOIN customavatar ON customavatar.userid=user.userid
    LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
    WHERE post.postid IN (0,3510,3537,3544,3617,3662,3668,3864,3868,3909,4023,4097,4127)
    ORDER BY dateline
    mysql error: Can't open file: 'attachment.MYI'. (errno: 145)
    mysql error number: 1016
    Date: Monday 11th of August 2003 04:21:15 AM
    Script: http://www.thephora.org/showthread.php?threadid=418
    Referer: http://www.thephora.org/forumdisplay.php?forumid=8

  • #2
    I uploaded the repair.php and ran it. Apparently it could not fix the tables that had crashed

    Checking table attachment Table Operation Type Text fade_phora.attachment check warning Table is marked as crashed fade_phora.attachment check warning Not used space is supposed to be: 164380 but is: 62328 fade_phora.attachment check error record delete-link-chain corrupted fade_phora.attachment check error Corrupt
    Repairing table session fade_phora.session repair error The handler for the table doesn't support repair Checking table session Table Operation Type Text fade_phora.session check error The handler for the table doesn't support check Repairing table session fade_phora.session repair error The handler for the table doesn't support repair Checking table session Table Operation Type Text fade_phora.session check error The handler for the table doesn't support check Repairing table session fade_phora.session repair error The handler for the table doesn't support repair Checking table session Table Operation Type Text fade_phora.session check error The handler for the table doesn't support check Repairing table session fade_phora.session repair error The handler for the table doesn't support repai

    Comment


    • #3
      Run this query:

      Code:
      REPAIR TABLE attachment;

      Comment


      • #4
        Danke.

        Comment

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