Announcement

Collapse
No announcement yet.

Databse Errors

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

  • Databse Errors

    Anybody know how to fix this?!?!

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

    Database error in vBulletin: 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,6199,6208,6209,6210)
    ORDER BY dateline

    mysql error: Can't open file: 'attachment.MYD'. (errno: 144)
    mysql error number: 1016
    Date: Sunday 24th of June 2001 01:20:27 PM
    Script: /kickback/showthread.php3?threadid=814
    Referer: http://www.heartskickback.co.uk/kick...php3?forumid=4

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

  • #2
    It's corruption. You can upload repair.php from the 'extras' directory of your vB2 zip file and go to it in a browser like this:
    mysite.com/forums/repair.php?check=1&html=1
    and look for any red boxes on the resulting page. If you see any, look for "repaired" to see if it was successfully repaired.

    Comment

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