1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.1 Table is marked as crashed and should be repaired

Discussion in 'Troubleshooting and Problems' started by Robert F Schmitz, Mar 27, 2012.

  1. Robert F Schmitz

    Robert F Schmitz Well-Known Member

    I clicked on my What's New this morning and get the following message. See screen shot. I would be greatly appreciative is someone can direct me as to what I need to do to repair the table noted. Thank you.

    search-error.PNG
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Run the repair utility in cPanel via the MySQL Databases icon/link.

    Then you may want to consider rebuilding the search index.
     
    Rob Fritz likes this.
  3. Robert F Schmitz

    Robert F Schmitz Well-Known Member

    What causes this sort of thing?
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Lots of different factors can cause that.
    If you do a Google search for e.g. "what causes mysql table crash", you'll see lots of different reasons.
     
    Rob Fritz and borbole like this.
  5. borbole

    borbole Well-Known Member

    A table can be crashed for various reasons, such as unstable operating system on which Mysql is installed or hardware problems or it could even be a simple power failure.
     
    Rob Fritz likes this.
  6. Robert F Schmitz

    Robert F Schmitz Well-Known Member

    OK I do not have a cpanel option. What I do have is phpMyAdmin installed.
    From a search, the syntax for repair is

    It seems that the extended option is what I want to use. Sorry but this is beyond my experience. What does the repair command look like format wise to repair this correctly? Is this correct or do you recommend another approach?
     
  7. Robert F Schmitz

    Robert F Schmitz Well-Known Member

    OK after some more searching I read this article and that seems to have fixed the issue.

     
  8. borbole

    borbole Well-Known Member

    Glad to see that you fixed the issue. But if your tables crash often then you must contact your host and let them know about it so they can check out things on their end.
     
    Rob Fritz likes this.
  9. Robert F Schmitz

    Robert F Schmitz Well-Known Member

    I have a feeling it was related to an issue that they had about a week ago. I received a notice that they were having some problems and would need to do maintenance. The more that I read about the cause of the crash the more it seemed to tie back to the host's issues.
     
    borbole likes this.

Share This Page