Post table is caput

  • Time
  • Show
Clear All
new posts
  • thedvs
    • May 2002
    • 55
    • 3.6.x

    Post table is caput

    I was running a repair on the post table in phpmyadmin

    It's now showing that the post table is "in use"

    If I try a repair via the admincp i get these results

    post Check Warning: Table is marked as crashed and last repair failed post Check Warning: Size of indexfile is: 273911808 Should be: 11716608 post Check Warning: Size of datafile is: 392236048 Should be: 392198232 post Check Error: Found 224593 keys of 45835 post Check Error: Corrupt

    Also dbase error:
    MySQL Error : Can't open file: 'post.MYI' (errno: 144)
    Error Number : 1016

    When using
    mysqlcheck -r -u mysqlusername -p databasename

    I get this error for the post table...

    error : 12 when fixing table
    error : Can't copy datafile-header to tempfile, error 9
    status : Operation failed
    Last edited by thedvs; Sat 9 Aug '08, 5:45am.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    OS error code 12: Cannot allocate memory

    OS error code 9: Bad file descriptor

    Unfortunately this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

    You may have to ask your host to try and repair this for you.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    • thedvs
      • May 2002
      • 55
      • 3.6.x

      Thanks steve, managed to repair it in root su, using

      mysqlcheck -r -q -u <username> -p <boardname>


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