Jump to content
PWaddict

Table 'pages' is marked as crashed and should be repaired WTF???

Recommended Posts

I'm building a site locally on laragon and suddenly today when I visited my site at mysite.test I got error from ProcessWire: Error:     Exception: SQLSTATE[HY000]: General error: 1194 Table 'pages' is marked as crashed and should be repaired (in C:\laragon\www\mysite\wire\core\WireDatabasePDOStatement.php line 166) 

I repaired the table "pages" on phpMyAdmin and now I can see my site but the problem is that all pages are GONE except Home. The admin section is empty too. WTF????????

Share this post


Link to post
Share on other sites

I tried to browse the pages table in phpMyAdmin and I couldn't. It was saying that the table is still crashed so I repaired it again and now I can't even view my site. I'm getting this: Error: Exception: You do not have permission to execute this module - ProcessPageView (in C:\laragon\www\mysite\wire\core\Modules.php line 1330)

Share this post


Link to post
Share on other sites

I guess I have to start again with a clean PW installation. The good thing is that only the "pages" table corrupted. I've exported the database so I can copy on the new installation some important text I had in some fields.

The only way to prevent this from happening again is DAILY BACKUPS. Cronjob Database Backup module by @kixe seems a good choice when you're developing a site.

Share this post


Link to post
Share on other sites

Something similar happened to me once many years ago. Never got to the bottom of it, it has never happened again. 

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...