HELP ME mysql error: Can't open file: 'attachment.MYI'. (errno: 144)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • php coder
    New Member
    • Sep 2005
    • 2
    • 3.0.3

    HELP ME mysql error: Can't open file: 'attachment.MYI'. (errno: 144)

    I have problem:

    Invalid SQL:
    SELECT COUNT(*) AS count
    FROM attachment
    WHERE posthash = 'ddc97c475c32975819bb0124796ade31'
    AND userid = 2

    mysql error: Can't open file: 'attachment.MYI'. (errno: 144)

    mysql error number: 1016

    ----------
    And When I do repair from ADMINCP :

    attachment Check Warning: Table is marked as crashed and last repair failed
    attachment Check Warning: 2 clients are using or haven't closed the table properly
    attachment Check Warning: Size of indexfile is: 75776 Should be: 41984
    attachment Check Error: Not enough memory for blob at 23934048
    attachment Check Error: Corrupt
    attachment


    -----
    And When I do repair from PHPMYADMIN:
    attachment repair error 12 when fixing table
    attachment repair error Not enough memory for blob at 40911420 (need 14220...
    attachment repair status Operation failed


    ----
    HELP Me Plase
  • Paul M
    Former Lead Developer
    vB.Com & vB.Org
    • Sep 2004
    • 9886

    #2
    It's broke - restore the table from your last backup.
    Baby, I was born this way

    Comment

    • php coder
      New Member
      • Sep 2005
      • 2
      • 3.0.3

      #3
      Originally posted by Paul M
      It's broke - restore the table from your last backup.


      always smile when U have problem whith vbulltin
      I think there is another way

      i'll wait because i don't have any backup


      <<<< last night

      <<<< today

      <<< now

      <<< after close his website

      <<< after that

      <<< he is thinking of his website

      -----
      HELP ME

      Comment

      • Zachery
        Former vBulletin Support
        • Jul 2002
        • 59097

        #4
        First message is your table is crashed and needs repairing.

        The second message means mysql can't get enough memory to do the repair, contact your host.

        Comment

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