{"id":6633,"date":"2016-10-03T01:17:33","date_gmt":"2016-10-02T23:17:33","guid":{"rendered":"http:\/\/catalinx.ro\/wordpress\/?p=6633"},"modified":"2016-10-03T01:22:02","modified_gmt":"2016-10-02T23:22:02","slug":"test124345","status":"publish","type":"post","link":"https:\/\/catalinx.ro\/wordpress\/?p=6633","title":{"rendered":"WordPress Crash. Cannot Add New Post."},"content":{"rendered":"
<\/div>\n

I spent my last hour debugging through wordpress as I could not add any new post , or upload anything from mobile.<\/p>\n

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 \ud83d\ude42<\/p>\n

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

\"wordpresss_add_new-post\"<\/p>\n

Like this .<\/p>\n

\"addnewpost_broken\"<\/p>\n

Well done WP mobile app! \u00a0I have checked on the internet for solutions of course \u00a0and got to the page that tells you to \u00a0enable the debug<\/a>. 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<\/strong>:<\/p>\n

\"wordpress_duplicate_key_post_id\"<\/p>\n

I have checked in mysql ( you do have \u00a0to take a backup of \u00a0your 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\u00a0I would get same issue while trying to manually add new line in mysql.<\/p>\n

I have checked the autoincrement<\/em> and it was fine. But the table was not fine when I made a mysql check. \u00a0It’s stored as myISAM.<\/p>\n

check table wp_posts; <\/code><\/p>\n

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

I have ran the \u00a0repair table and everything is back to normal. I think :).<\/p>\n","protected":false},"excerpt":{"rendered":"

I spent my last hour debugging through wordpress as I could not add any new post , or upload anything from mobile. It crashed last…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[7,1055,229],"tags":[1407,1406,1405],"class_list":["post-6633","post","type-post","status-publish","format-standard","hentry","category-administrare-it","category-english","category-tech","tag-cannot-add-new-post","tag-wordpress-crash","tag-wp_posts-duplicate-id"],"views":2335,"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4Eq23-1IZ","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/6633","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6633"}],"version-history":[{"count":6,"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/6633\/revisions"}],"predecessor-version":[{"id":6639,"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/6633\/revisions\/6639"}],"wp:attachment":[{"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6633"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6633"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}