My Wordpress admin interface shows there are 4 pending comments, but I've already approved three and deleted one of them via Disqus comment moderation page, but the page they were posted on was later deleted. I then posted two comments myself on a test page, deleted the page, and they are still shown as pending on Wordpress admin. How do I remove them from pending comments list?

Page the comments have been posted to is removed, so they do not have anything in "in response to" column, these comments also do not have a checkbox next to them, so I can't select them. There are also no options appearing when hovering above the comment on pending comments moderation page.

I just recently installed WordPress to my site and it doesn't have anything custom but Disqus.

I am absolutely new to WordPress, so please explain each step of possible solution in detail.

My Wordpress admin interface shows there are 4 pending comments, but I've already approved three and deleted one of them via Disqus comment moderation page, but the page they were posted on was later deleted. I then posted two comments myself on a test page, deleted the page, and they are still shown as pending on Wordpress admin. How do I remove them from pending comments list?

Page the comments have been posted to is removed, so they do not have anything in "in response to" column, these comments also do not have a checkbox next to them, so I can't select them. There are also no options appearing when hovering above the comment on pending comments moderation page.

I just recently installed WordPress to my site and it doesn't have anything custom but Disqus.

I am absolutely new to WordPress, so please explain each step of possible solution in detail.

• comments

• In a brief test, if I delete a page, its associated comments are deleted as well. Maybe troubleshooting and debugging. Also, check if this Question is related. – brasofilo Commented Jan 20, 2013 at 17:01
• This happens every time I remove a page with comments, and I only have Disqus installed from custom plugins, so I'm wondering if this is a unique situation. Surely someone else must have had this problem before. – user1306322 Commented Jan 20, 2013 at 19:15
• Do you active use of caching, like APC or Memcached and also active in Backend, liek via Dropin inside the wp-content folder or as plugin? – bueltge Commented Jan 23, 2013 at 11:48
• I don't understand anything of that. I'm just a simple user who encountered a problem and described it in a way that may suggest I'm an experienced user, but I'm not. – user1306322 Commented Jan 23, 2013 at 13:01
• But very often have also simple users a caching plugin or a server, there use caching. – bueltge Commented Jan 24, 2013 at 15:52

2 Answers 2

You may want to try the next plugin: http://wordpress/extend/plugins/delete-all-pending-comments/

Note: I haven't tested this plugin reproducing your issue exactly, but the plugin I created to delete all pending comments.

Please let me know :)

I was able to reset it by editing a row in the wp_options table, option_name = _transient_wc_count_comments

In my case, all of the comments were WooCommerce reviews, so your option_name may be different (search the option_value column for your total comment count).

Be careful editing serialized data (look it up if it isn't clear!).