{"id":1454,"date":"2007-04-01T00:07:25","date_gmt":"2007-04-01T06:07:25","guid":{"rendered":"http:\/\/www.conradaskland.com\/blog\/2007\/04\/phpbb-mysql-error-fix\/"},"modified":"2007-04-01T00:07:25","modified_gmt":"2007-04-01T06:07:25","slug":"phpbb-mysql-error-fix","status":"publish","type":"post","link":"https:\/\/conradaskland.com\/blog\/phpbb-mysql-error-fix\/","title":{"rendered":"PHPBB Mysql Error Fix"},"content":{"rendered":"<p>If you get error notices on mysql using phpbb &#8211; view the database structure in PHPMYADMIN and see if all tables are listed. If you only get a partial listing with an error message for a particular table, here&#8217;s how to fix it.<\/p>\n<p>In PHPMYADMIN with your specific database called up click &#8220;SQL&#8221; &#8211; this will open up an SQL query window where you can insert a repair command for the particular table malfunction. If the table error is &#8220;phpbb_search_wordmatch&#8221; then you can enter this in the MYSQL Query window:<br \/>\nREPAIR TABLE <span class=\"gen\">phpbb_search_wordmatch<\/span><\/p>\n<p>Then click &#8220;go&#8221; &#8211; on larger databases the process may take a while. My experience has been that usually only one table will be corrupted in a database at a time &#8211; and usually occurs after a server reboot.<\/p>\n<p>***************<\/p>\n<p>Sample error message for above fix:<\/p>\n<p><span class=\"gen\">Error in deleting post<\/p>\n<p><strong><u>DEBUG MODE<\/u><\/strong><\/p>\n<p>SQL Error : 1034 Incorrect key file for table: &#8216;phpbb_search_wordmatch&#8217;. Try to repair it<\/p>\n<p>DELETE FROM phpbb_search_wordmatch   \t\tWHERE post_id IN (172970)<\/p>\n<p>Line : 419<br \/>\nFile : functions_search.php<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you get error notices on mysql using phpbb &#8211; view the database structure in PHPMYADMIN and see if all tables are listed. If you only get a partial listing with an error message for a particular table, here&#8217;s how to fix it. In PHPMYADMIN with your specific database called up click &#8220;SQL&#8221; &#8211; this [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[6],"tags":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3C0LX-ns","_links":{"self":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/posts\/1454"}],"collection":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/comments?post=1454"}],"version-history":[{"count":0,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/posts\/1454\/revisions"}],"wp:attachment":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/media?parent=1454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/categories?post=1454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/tags?post=1454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}