Posted 4 years ago #
I'm running the latest version of WP. I have a blog that has 39,263 comments waiting for moderation. Deleting them via the wp-admin interface sounds years of work.
Could somebody give me the SQL query to delete the awaiting for moderation comments?
And I do use Akismet. I installed it after I discovered the huge amount of spam. In 2.3 clicking to recheck the queue resulted in blank page. In 2.6 it says the queue is empty.
Posted 4 years ago #
Same story here... have a site that runs on bleeding edge (now 2.7-beta3-9771) and has about 6300 comments in moderation. When hitting "check for spam", the resulting page /wp-admin/admin.php?action=akismet_recheck_queue shows nothing but blank.
Guess that this is still in the works? Any news?
Posted 4 years ago #
I just went to the DB and deleted all comments needing moderation with a SQL query. If you're running bleeding edge I guess the bug has not been adressed yet :(
I just went to the DB and deleted all comments needing moderation with a SQL query.
That's exactly the thing that everybody is asking for: the query.
Could you post it?
Posted 4 years ago #
To delete all the comments that have _not_ been approved yet can be deleted via:
delete from wp_comments where comment_approved=0;
Your table name can be different so wp_comments can be your defined prefix_comments.
*) If you have non-spam comments that need approval they will also be deleted so watch out.
Posted 4 years ago #
I'm having the same problem and would love not to delete ALL comments, since there are actually some good ones in there. I haven't found any solution to the blank page problem with akismet. I'm also worried that it's not catching new spam...
Did anyone find a fix for this?
Posted 4 years ago #
hello everyone
same issue here, 34K comments waiting, but 99% in a single post.
I would like to use something more specific than:
delete from wp_comments where comment_approved=0;
I would like to restrict the conditions to a specific post (how are they identified? ordinal number?), and containing a specific keyword (matching a few spam keywords should get rid of most spam posts, and hopefully leave some good comments)
I am in the MySql php admin panel, but it's my first time here so I'd like a little help...
thanks!
Posted 4 years ago #
Same problem - blank result on /wp-admin/admin.php?action=akismet_recheck_queue - don't want to delete all unmoderated comments since there must be a couple valid ones in the 28,000+ Pending comments.
This topic has been closed to new replies.
