Announcement

Collapse
No announcement yet.

database error:144

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

  • database error:144

    Code:
    Database error in vBulletin 3.6.6:
    Invalid SQL:
        INSERT IGNORE INTO postindex
        (wordid, postid, score, intitle)
        SELECT DISTINCT wordid, 553111, CASE title WHEN 'fdgfgggggggggggggggg' THEN 1 ELSE 1 END, CASE title WHEN '' THEN 1 WHEN 'fdgfgggggggggggggggg' THEN 0 ELSE 0 END
        FROM word
        WHERE title IN ('fdgfgggggggggggggggg');
    MySQL Error  : Can't open file: 'postindex.MYI' (errno: 144)
    Error Number : 1016
    Date         : Tuesday, May 29th 2007 @ 12:55:33 PM
    Script       : [URL]http://www.uydukurdu.com/forum/newreply.php?do=postreply&t=86886[/URL]
    Referrer     : [URL]http://www.uydukurdu.com/forum/newreply.php?do=newreply&noquote=1&p=553105[/URL]

    I tried lots of time optimize tables but postindex table makes error.
    It says :

    postindexCheckWarning: Table is marked as crashed and last repair failed
    postindexCheckError: Found key at page 178686976 that points to record outside datafile
    postindexCheckError: Corrupt
    postindex

    We can not open a new thread and while we are sending qıick reply it makes errors.

    How can I solve this problem?

  • #2
    Ask your host to repair the table using myisamchk
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      I will ask,
      If I can solve the problem I will write here.

      thank you.

      Comment


      • #4
        Thank you,

        We have solved the problem with myisamchk.

        But it has taken lots of time

        Comment

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