Announcement

Collapse
No announcement yet.

Post table is caput

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

  • 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 9th Aug '08, 4:45am.

  • #2
    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:

    http://www.vbulletin.com/forum/showt...threadid=44909

    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.


    Comment


    • #3
      Thanks steve, managed to repair it in root su, using

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

      Comment

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