WordPress Crash. Cannot Add New Post.

I spent my last hour debugging through wordpress as I could not add any new post , or upload anything from mobile.

It crashed last evening when I was trying to correct a draft from mobile. I have the feeling that the mobile app from WordPress does not close the wp_posts table correctly. Or something 🙂

Initially I didn’t know what’s the issue . In the morning I was trying to write something from the computer and found  that when  trying to Add New Post from the menu, it would open it up without any Main Text.

wordpresss_add_new-post

Like this .

addnewpost_broken

Well done WP mobile app!  I have checked on the internet for solutions of course  and got to the page that tells you to  enable the debug. Which I did and got this output below, that basically shows a duplicate key message from DB for the post id in the table wp_post:

wordpress_duplicate_key_post_id

I have checked in mysql ( you do have  to take a backup of  your wordpress DB before doing that , I am just too good for it – kidding , I had one from yesterday). There I have only 6628 posts, there’s no duplicate on 6629 ,but obviously there is something wrong, because I would get same issue while trying to manually add new line in mysql.

I have checked the autoincrement and it was fine. But the table was not fine when I made a mysql check.  It’s stored as myISAM.

check table wp_posts;

db_wordpress.wp_posts check warning Table is marked as crashed
db_wordpress.wp_posts check warning 22 clients are using or haven't closed the table properly
db_wordpress.wp_posts check error Found key at page 36192256 that points to record outside datafile
db_wordpress.wp_posts check error Corrupt

I have ran the  repair table and everything is back to normal. I think :).

Send to Kindle

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.