Announcement

Collapse
No announcement yet.

FORUM DOWN MySQL Error

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

  • FORUM DOWN MySQL Error

    My forum has stopped working and I am getting the

    mysql error: Can't open file: 'user.MYI'. (errno: 145)


    As I understand to fix this, I must run this query:


    REPAIR TABLE user;

    Because this error is stopping me from logging into my Admin CP I need to login to my phpMyAdmin and run the query from there. I have logged in but don't know how to run the query.

    HELP ME PLEASE! I only launched to the public today (after 2 weeks of testing) and this happened within 15 mins.

  • #2
    Go to your phpMyAdmin and choose the database for your forum.
    Then klick the SQL-tab and enter the query and press "Go".
    That should start the repair process.

    Comment


    • #3
      Originally posted by daFish
      Then klick the SQL-tab and enter the query and press "Go".
      That should start the repair process.
      That's what I tried first. But all I got was an error message saying that the table didn't exist. Please see attahced screen shot.
      Attached Files

      Comment


      • #4
        Originally posted by Ceroc
        That's what I tried first. But all I got was an error message saying that the table didn't exist. Please see attahced screen shot.
        What was the syntax you entered in phpMyAdmin to repair the table?

        Comment


        • #5
          REPAIR TABLE user;

          Comment


          • #6
            Ceroc

            Do your tables have a prefix?

            example: X_user

            If so I believe the query should have been: REPAIR TABLE X_user;

            Replace X with your prefix if any.

            Comment

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