{"id":754,"date":"2009-02-28T16:52:23","date_gmt":"2009-02-28T21:52:23","guid":{"rendered":"http:\/\/feverishthoughts.com\/webdesign\/?p=754"},"modified":"2011-07-08T01:30:41","modified_gmt":"2011-07-08T05:30:41","slug":"wp_posts-database-crashed-help","status":"publish","type":"post","link":"https:\/\/feverishthoughts.com\/webdesign\/2009\/02\/28\/wp_posts-database-crashed-help\/","title":{"rendered":"WP_Posts database crashed &#8211; HELP!"},"content":{"rendered":"<!--CusAds--><p>If you see this post a few times it&#8217;s because I really need help and I&#8217;m posting it on three of my blogs &#8211; sorry for the repeat, but if you can help, please do!<\/p>\n<div class=\"6bc5ccbe3d2ff567e8bb701db5576878\" data-index=\"2\" style=\"float: right; margin:10px 0 10px 10px;\">\n<script type=\"text\/javascript\"><!--\r\ngoogle_ad_client = \"pub-3375789278566919\";\r\n\/* webstyle_inpost_300x250 *\/\r\ngoogle_ad_slot = \"4670586556\";\r\ngoogle_ad_width = 300;\r\ngoogle_ad_height = 250;\r\n\/\/-->\r\n<\/script>\r\n<script type=\"text\/javascript\"\r\nsrc=\"http:\/\/pagead2.googlesyndication.com\/pagead\/show_ads.js\">\r\n<\/script>\n<\/div>\n\n<p>I need some help fixing my husbands blog &#8211; <a href=\"http:\/\/feverishthoughts.com\/guitar\/\" data-wpel-link=\"external\" rel=\"nofollow external noopener noreferrer\" class=\"ext-link\">Guitar Licks<\/a>.  Today when he visited the site (while I was still sleeping) the blog had error messages stating that the WP_posts database had crashed. <\/p>\n<p>When you visit his site it loads with the WP theme and sidebars, but there&#8217;s error messages at the top and a &#8220;post cannot be found&#8221; message where current posts should be listed on the index page. <\/p>\n<p>Some of the errors state:<\/p>\n<p>ALTER TABLE wp_posts ADD FULLTEXT `yarpp_title` ( `post_title`)<\/p>\n<p>ALTER TABLE wp_posts ADD FULLTEXT `yarpp_content` ( `post_content`)<\/p>\n<p>So I&#8217;m assuming this error has something to do with the <em>Yet another related post plugin<\/em> that I&#8217;m using on most of my blogs.  This blog is using the plugin version 2.16 and is using WP 2.62.<\/p>\n<p>In the Yet another related posts plugin admin area there was a message that said:<\/p><!--CusAds-->\n<blockquote><p>YARPP&#8217;s &#8220;consider titles&#8221; and &#8220;consider bodies&#8221; relatedness criteria require your wp_posts table to use the MyISAM storage engine, but the table seems to be using the  engine. These two options have been disabled.<br \/>\nTo restore these features, please update your wp_posts table by executing the following SQL directive: ALTER TABLE `wp_posts` ENGINE = MyISAM; . No data will be erased by altering the table&#8217;s engine, although there are performance implications.<br \/>\nIf, despite this check, you are sure that wp_posts is using the MyISAM engine, press this magic button:<\/p><\/blockquote>\n<p>I clicked on the &#8220;magic button&#8221; as the plugin seems to be working just fine in all of my other blogs and I ended up with even more errors!<\/p>\n<p>Help!<\/p>\n<p>I&#8217;ve looked at the WP database for this blog and the WP_posts table says &#8220;in use&#8221; and I can&#8217;t browse it.   I also can&#8217;t use the backup plugin in Guitar licks &#8211; it&#8217;s there and functioning but just hung when I tried to do a back up. <\/p>\n<p>I&#8217;ve backed up the whole database using PHPmyAdmin so I have a copy in case something goes terribly wrong.  Now I just need to know how to fix it. <\/p>\n<p>Should I just place a check mark on WP_posts and then click the repair function at the bottom of the structure screen in PHPmyAdmin and see if that repairs the problem?<\/p>\n<!--CusAds--><p>I&#8217;m nervous about attempting to fix this as I&#8217;ve never had to try to repair a database error before. Any help would be appreciated. <\/p>\n<div class=\"6bc5ccbe3d2ff567e8bb701db5576878\" data-index=\"9\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<br\/>\r\n<div align=\"center\">\r\n<script type=\"text\/javascript\"><!--\r\ngoogle_ad_client = \"pub-3375789278566919\";\r\n\/* webstyle_inpost_300x250 *\/\r\ngoogle_ad_slot = \"4670586556\";\r\ngoogle_ad_width = 300;\r\ngoogle_ad_height = 250;\r\n\/\/-->\r\n<\/script>\r\n<script type=\"text\/javascript\"\r\nsrc=\"http:\/\/pagead2.googlesyndication.com\/pagead\/show_ads.js\">\r\n<\/script>\r\n<\/div>\r\n<br\/>\r\n<?php if ( is_search() || is_single() || is_page() || is_paged() || is_category() || is_archive() ) { ?>\r\n<div align=\"center\">\r\n<script type=\"text\/javascript\"><!--\r\nch_client = \"dragonden\";\r\nch_type = \"mpu\";\r\nch_width = 468;\r\nch_height = 120;\r\nch_color_bg = \"FFFFFF\";\r\nch_color_title = \"0094d2\";\r\nch_color_text = \"333333\";\r\nch_non_contextual = 4;\r\nch_vertical =\"premium\";\r\nch_sid = \"webstyle_betweenposts2\";\r\nvar ch_queries = new Array( );\r\nvar ch_selected=Math.floor((Math.random()*ch_queries.length));\r\nif ( ch_selected < ch_queries.length ) {\r\nch_query = ch_queries[ch_selected];\r\n}\r\n\/\/--><\/script>\r\n<script  src=\"http:\/\/scripts.chitika.net\/eminimalls\/amm.js\" type=\"text\/javascript\">\r\n<\/script>\r\n<\/div>\r\n<?php } ?>\r\n<br\/>\n<\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>If you see this post a few times it&#8217;s because I really need help and I&#8217;m posting it on three of my blogs &#8211; sorry for the repeat, but if you can help, please do! I need some help fixing my husbands blog &#8211; Guitar Licks. Today when he visited the site (while I was [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[35,28,22],"tags":[1412,1413,1406,1407,1410,1414,938,939,693,1411,320,1415,1408,1591,1417,1409,1405,1416],"class_list":{"0":"post-754","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-blogging","7":"category-wordpress","8":"category-wordpress-plugins","9":"tag-corrupted","10":"tag-corrupted_database","11":"tag-database","12":"tag-error","13":"tag-errors","14":"tag-fix","15":"tag-help","16":"tag-ideas","17":"tag-mysql","18":"tag-no_posts","19":"tag-plugin","20":"tag-repair","21":"tag-table","22":"tag-wordpress","23":"tag-wp","24":"tag-wp_post","25":"tag-yarpp","26":"tag-yet_another_related_post_plugin","27":"entry"},"_links":{"self":[{"href":"https:\/\/feverishthoughts.com\/webdesign\/wp-json\/wp\/v2\/posts\/754","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/feverishthoughts.com\/webdesign\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/feverishthoughts.com\/webdesign\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/feverishthoughts.com\/webdesign\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/feverishthoughts.com\/webdesign\/wp-json\/wp\/v2\/comments?post=754"}],"version-history":[{"count":0,"href":"https:\/\/feverishthoughts.com\/webdesign\/wp-json\/wp\/v2\/posts\/754\/revisions"}],"wp:attachment":[{"href":"https:\/\/feverishthoughts.com\/webdesign\/wp-json\/wp\/v2\/media?parent=754"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/feverishthoughts.com\/webdesign\/wp-json\/wp\/v2\/categories?post=754"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/feverishthoughts.com\/webdesign\/wp-json\/wp\/v2\/tags?post=754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}