Jump to content
PWaddict

Once again General error: 1194 Table marked as crashed

Recommended Posts

On October 2020 the table pages was crashed and now I just noticed on the logs that at least 1 month ago also a field table crashed. I have never see that notice on frontend otherwise I would have instantly switched to a previous db backup. Now that I noticed this issue by randomly going to logs I don't have any proper db backup as all of them are with that field crashed 😞

SQLSTATE[HY000]: General error: 1194 Table 'field_faq_answer' is marked as crashed and should be repaired (in C:\laragon\www\mysite\wire\core\WireDatabasePDOStatement.php line 166)

 

Share this post


Link to post
Share on other sites

As its stated, you have to do a "repair". Make another backup, then start the repair procedure (quite simple on MyISAM tables).

To find the cause, you should check logs about hard-drive failure or a server crash, or ask the support if they encountered issue on their side.

Share this post


Link to post
Share on other sites

@PWaddict Which log file did you spot that in?

Also, you can try the ProcessDiagnostics module as it has a DB helper that can run table repairs. You should always back up the DB first though before any operations like that.

Share this post


Link to post
Share on other sites

Thanks both for the help but last time I tried to repair the crashed table "pages" things got worse. I just deleted the field and re-create it with all it's content. This happened on my Windows PC.

I randomly find out about that problem by going to Setup > Logs > Exceptions.
Log exceptions don't appear on frontend?

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...