2

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.

Improve this question
5
  • 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
    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
    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
    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
    Jan 23, 2013 at 13:01
  • But very often have also simple users a caching plugin or a server, there use caching.
    – bueltge
    Jan 24, 2013 at 15:52

2 Answers 2

Reset to default
1
+50

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 :)

Improve this answer
11
  • Well that worked. Now I just need to find out how to prevent this kind of behavior.
    – user1306322
    Jan 27, 2013 at 22:31
  • Glad that have worked for you! :) By "behaviour", what do you mean? Like in the future, when deleting a page, to delete also attached pending comments?
    – user17408
    Jan 27, 2013 at 22:36
  • I'd like them to stay attached to the deleted page at least, so they can be selected and deleted manually. Not sure how this must work, but I think it's logical that you don't ever want to be unable to do something with your content.
    – user1306322
    Jan 27, 2013 at 22:42
  • Yes but a pending comment attached to a deleted page, it means it is deleted too like it's parent page.
    – user17408
    Jan 27, 2013 at 22:45
  • Except in my case it's not. I think it loses some id which is required to do things, and this results in absent checkboxes and action buttons.
    – user1306322
    Jan 27, 2013 at 22:54
1

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!).

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.