Title: Help WP_Comments Missing In Database Last modified: July 28, 2017 --- # Help WP_Comments Missing In Database * Resolved [angelofthynight](https://wordpress.org/support/users/angelofthynight/) * (@angelofthynight) * [8 years, 10 months ago](https://wordpress.org/support/topic/help-wp_comments-missing-in-database/) * Hey everyone, I really could use your help I set up wordpress a couple weeks ago to be honest I was a bit skeptical because I know that one little bit of code being off can bring down your whole blog. But I had installed a bad plugin in a few days ago of course I uninstalled it but it caused my site to not load therefore my host reset the permissions and disabled the plugins via database to get it online. Well the problem I have is that I have an entire table missing which is the _comments sql query. Its just gone now I do not have any comments as of yet so although its not a big deal I need to fix the issue so that others can comment in the future. When I go to the repair the table this is the error message I get plus I can go into my database and see the comments table is simply not listed. * The J1cbj0_comments table is not okay. It is reporting the following error: Table‘ AOTN_News.J1cbj0_comments’ doesn’t exist. WordPress will attempt to repair this table… Failed to repair the J1cbj0_comments table. Error: Table ‘AOTN_News.J1cbj0_comments’ doesn’t exist * Can someone help me repair this not sure if you can give me a query command that I can manually program into the database or if I can do it via file manager in one of the php files possibly. * Also below these errors persist whenever I load my wordpress site at the very bottom of the page most of the errors appear to be directed at the fact there is no comments area in the database therefore it generates a series of errors which will never go away unless I fix having a wp_comments table. * WordPress database error Table ‘AOTN_News.J1cbj0_comments’ doesn’t exist for query SELECT J1cbj0_comments.comment_ID FROM J1cbj0_comments JOIN J1cbj0_posts ON J1cbj0_posts.ID = J1cbj0_comments.comment_post_ID WHERE ( comment_approved = ‘1’ ) AND J1cbj0_posts.post_status IN (‘publish’) ORDER BY J1cbj0_comments. comment_date_gmt DESC LIMIT 5 made by require(‘G:\PleskVhosts\paranormalghostsociety. org\http\AngelOfThyNightNews\wp-blog-header.php’), require_once(‘G:\PleskVhosts\ paranormalghostsociety.org\http\AngelOfThyNightNews\wp-includes\template-loader. php’), include(‘G:\PleskVhosts\paranormalghostsociety.org\http\AngelOfThyNightNews\ wp-content\themes\mh-magazine-lite\404.php’), get_sidebar, locate_template, load_template, require_once(‘G:\PleskVhosts\paranormalghostsociety.org\http\AngelOfThyNightNews\ wp-content\themes\mh-magazine-lite\sidebar.php’), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Recent_Comments->widget, get_comments, WP_Comment_Query->query, WP_Comment_Query->get_comments, WP_Comment_Query->get_comment_ids WordPress database error Table ‘AOTN_News.J1cbj0_comments’ doesn’t exist for query SELECT J1cbj0_comments.comment_ID FROM J1cbj0_comments WHERE ( comment_approved = ‘1’ ) ORDER BY J1cbj0_comments.comment_date_gmt DESC LIMIT 3 made by require(‘ G:\PleskVhosts\paranormalghostsociety.org\http\AngelOfThyNightNews\wp-blog-header. php’), require_once(‘G:\PleskVhosts\paranormalghostsociety.org\http\AngelOfThyNightNews\ wp-includes\template-loader.php’), include(‘G:\PleskVhosts\paranormalghostsociety. org\http\AngelOfThyNightNews\wp-content\themes\mh-magazine-lite\404.php’), get_sidebar, locate_template, load_template, require_once(‘G:\PleskVhosts\paranormalghostsociety. org\http\AngelOfThyNightNews\wp-content\themes\mh-magazine-lite\sidebar.php’), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, mh_magazine_lite_tabbed- >widget, WP_Comment_Query->query, WP_Comment_Query->get_comments, WP_Comment_Query- >get_comment_ids * I am not new to creating php database forums but I am new to the whole wordpress platform and I just need some guidance to get it up and going. Also the other factor is speed its very slow even if I disable my plugins id assume that this comment glitch is also slowing down the blog. Viewing 7 replies - 1 through 7 (of 7 total) * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [8 years, 10 months ago](https://wordpress.org/support/topic/help-wp_comments-missing-in-database/#post-9360264) * Via PHPMYADMIN, check whether the table is there. If it is, it may be corrupt, so use phpmyadmin to check and repair it. * If the table is missing, then restore your site’s database from an earlier backup. * Thread Starter [angelofthynight](https://wordpress.org/support/users/angelofthynight/) * (@angelofthynight) * [8 years, 10 months ago](https://wordpress.org/support/topic/help-wp_comments-missing-in-database/#post-9360284) * The data base is not there as per repair test I posted above it says missing. I saved my backup after the error unfortunately. I just need an sql query which will rebuild the comments area of the data base. * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [8 years, 10 months ago](https://wordpress.org/support/topic/help-wp_comments-missing-in-database/#post-9360318) * Please verify that via phpmyadmin. * Thread Starter [angelofthynight](https://wordpress.org/support/users/angelofthynight/) * (@angelofthynight) * [8 years, 10 months ago](https://wordpress.org/support/topic/help-wp_comments-missing-in-database/#post-9360327) * This is all it says from the repair…. it tries to repair then fails because it does not exist. * The J1cbj0_comments table is not okay. It is reporting the following error: Table‘ AOTN_News.J1cbj0_comments’ doesn’t exist. WordPress will attempt to repair this table… Failed to repair the J1cbj0_comments table. Error: Table ‘AOTN_News.J1cbj0_comments’ doesn’t exist * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [8 years, 10 months ago](https://wordpress.org/support/topic/help-wp_comments-missing-in-database/#post-9360350) * Please do this from PHPMYADMIN as I’ve twice suggested. * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [8 years, 10 months ago](https://wordpress.org/support/topic/help-wp_comments-missing-in-database/#post-9360358) * By the way, this SQL creates the table. You should change the prefix from wp_ to match yours: * [https://gist.github.com/sterndata/86675089b2def24ffa5277735ec392a2](https://gist.github.com/sterndata/86675089b2def24ffa5277735ec392a2) * If you do create a new comments table, truncate the commmenmeta table. - This reply was modified 8 years, 10 months ago by [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/). - This reply was modified 8 years, 10 months ago by [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/). * Thread Starter [angelofthynight](https://wordpress.org/support/users/angelofthynight/) * (@angelofthynight) * [8 years, 10 months ago](https://wordpress.org/support/topic/help-wp_comments-missing-in-database/#post-9361306) * I got it thanks for all your help Steve. Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘Help WP_Comments Missing In Database’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [errors](https://wordpress.org/support/topic-tag/errors/) * [missing](https://wordpress.org/support/topic-tag/missing/) * [query](https://wordpress.org/support/topic-tag/query/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 7 replies * 2 participants * Last reply from: [angelofthynight](https://wordpress.org/support/users/angelofthynight/) * Last activity: [8 years, 10 months ago](https://wordpress.org/support/topic/help-wp_comments-missing-in-database/#post-9361306) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics