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.
You may want to try the next plugin: http://wordpress.org/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!).