Announcement

Collapse
No announcement yet.

MySQL Errors: Attachments

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

  • MySQL Errors: Attachments

    I woke up this morning to about 100 mysql errors in my email box. I've repaired and optimized tables but am getting this error in the optimizer:
    attachmentCheckWarning: Table is marked as crashed and last repair failed

    attachmentCheckError: Found 1107 keys of 1106
    attachmentCheckError: Corrupt
    attachment


    My forum is now turned off. If I attempt to make any sort of posting on my forum I get an error like this one:

    Database error in vBulletin 3.0.3:
    Invalid SQL:
    SELECT COUNT(*) AS count
    FROM attachment
    WHERE posthash = '11a8fefdce37e7bf49f463e85fc67237'
    AND userid = 1

    mysql error: Can't open file: 'attachment.MYI'. (errno: 144)
    mysql error number: 1016
    Date: Tuesday 12th of April 2005 09:33:17 AM
    Script: http://www.authentic-campaigner.com/forum/newthread.php
    Referer: http://www.authentic-campaigner.com/...newthread&f=34
    Username: paulcalloway
    IP Address:

  • #2
    Resolved

    Issue resolved. I found my answer in this thread: http://www.vbulletin.com/forum/showthread.php?t=102900


    Was able to repair the database with ssh telnet.

    Comment

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