MySQL Error: Incorrect key file for table 'blog_usercss'

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • CPOWA
    Member
    • Oct 2007
    • 75
    • 4.1.x

    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 22 Nov '09, 7:29am.
    Pelican Exterior Cleaning, Inc.
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24325
    • 5.7.X

    #2
    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...
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

    • CPOWA
      Member
      • Oct 2007
      • 75
      • 4.1.x

      #3
      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 23 Nov '09, 6:32am.
      Pelican Exterior Cleaning, Inc.

      Comment

      • Trevor Hannant
        vBulletin Support
        • Aug 2002
        • 24325
        • 5.7.X

        #4
        I'd give your host a shout and ask them to look at it for you
        Vote for:

        - Admin Settable Paid Subscription Reminder Timeframe (vB6)
        - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

        Comment

        • CPOWA
          Member
          • Oct 2007
          • 75
          • 4.1.x

          #5
          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)
          Pelican Exterior Cleaning, Inc.

          Comment

          • CPOWA
            Member
            • Oct 2007
            • 75
            • 4.1.x

            #6
            Could someone move this thread to theBlog Questions, Problems and Troubleshooting forum. Thanks.
            Pelican Exterior Cleaning, Inc.

            Comment

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