Announcement

Collapse
No announcement yet.

MySQL Error: Incorrect key file for table 'blog_usercss'

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

  • CPOWA
    replied
    Could someone move this thread to theBlog Questions, Problems and Troubleshooting forum. Thanks.

    Leave a comment:


  • CPOWA
    replied
    Host just tried. Not good:

    mysql> repair table blog_usercss;
    +---------------------------+--------+----------+---------------------------------------------------------------+
    | Table | Op | Msg_type | Msg_text |
    +---------------------------+--------+----------+---------------------------------------------------------------+
    | cpowa_forums.blog_usercss | repair | Error | Incorrect key file for table 'blog_usercss'; try to repair it |
    | cpowa_forums.blog_usercss | repair | error | Corrupt |
    +---------------------------+--------+----------+---------------------------------------------------------------+
    2 rows in set (0.00 sec)

    Leave a comment:


  • Trevor Hannant
    replied
    I'd give your host a shout and ask them to look at it for you

    Leave a comment:


  • CPOWA
    replied
    Thanks for the advice Trevster. I tried the repair in phpmyadmin. No joy.

    SQL result

    Host: localhost
    Database: xxxxx_forums
    Generation Time: Nov 23, 2009 at 09:05 AM
    Generated by: phpMyAdmin 2.11.9.5 / MySQL 5.1.37
    SQL query: REPAIR TABLE `blog_usercss`;
    Rows: 2
    Table Op Msg_type Msg_text xxxxx_forums.blog_usercss repair Error Incorrect key file for table 'blog_usercss'; try to repair it
    xxxxx_forums.blog_usercss repair error Corrupt

    Also, phpmyadmin is reporting the table blog_usercss table status as "in use".
    Last edited by CPOWA; Mon 23rd Nov '09, 7:32am.

    Leave a comment:


  • Trevor Hannant
    replied
    Run this query in phpMyAdmin rather than through AdminCP:

    REPAIR TABLE blog_usercss;

    If the table's empty, you could drop it and recreate it? Make sure you backup before trying that though...

    Leave a comment:


  • CPOWA
    started a topic MySQL Error: Incorrect key file for table 'blog_usercss'

    MySQL Error: Incorrect key file for table 'blog_usercss'

    Tried backing up my database this morning and I'm getting the error below. Never had any trouble backing up before. Only changes made to the system since the last backup: Upgraded php (from 5.2.4 to 5.2.11) and mysql (from 4.1.22 to 5.1.37). Restoring the DB is not an option. IE: New users, Style, etc.

    Repair table tool didn't fix it. Also, there are no records on the blog_usercss table.

    What to do?

    Database error in vBulletin 3.8.3:

    Invalid SQL:
    SHOW CREATE TABLE blog_usercss;

    MySQL Error : Incorrect key file for table 'blog_usercss'; try to repair it
    Error Number : 1034
    Request Date : Sunday, November 22nd 2009 @ 10:04:54 AM
    Error Date : Sunday, November 22nd 2009 @ 10:04:57 AM
    Script : http://www.uspatriotsnation.com/foru...php?do=sqlfile
    Referrer : http://www.uspatriotsnation.com/foru....php?do=choose
    IP Address : XXXXXXX
    Username : XXXXXXX
    Classname : vB_Database
    MySQL Version : 5.1.37
    Last edited by CPOWA; Sun 22nd Nov '09, 8:29am.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X