Recent Topics

how to delete all comments?

Started by on Jan 19, 2010 – Contents updated: Feb 02, 2013

Jan 19, 2010 21:30    

My b2evolution Version: Not Entered

I'd just like to know how to quickly and simply delete all the comments awaiting moderation. I've been deleting/reporting spam comments all morning and I am sick to death of it. Any help would be appreciated.

Jan 20, 2010 05:40

Add this in conf/hacks.php, if the file is not there - create it.

PHP

global $DB;
 
$DB->query('DELETE FROM T_comments WHERE comment_status = "draft"');

Then open any blog page to run the script.
Don't forget to delete the file once comments are deleted.

It's always a good idea to backup the database before running my free-typed scripts :)

Jan 26, 2010 18:26

mryan wrote:

My b2evolution Version: Not Entered

I'd just like to know how to quickly and simply delete all the comments awaiting moderation. I've been deleting/reporting spam comments all morning and I am sick to death of it. Any help would be appreciated.

Boy, I know this feeling. For the past hour, that's all I've been doing.

Thanks Sam -- but how am I to know that is legit?

Apr 16, 2012 15:18

well, another way is you copy the content of that page, paste it and create a fresh page and publish it. now that you have a duplicate page with the same content, you can delete the old one and all the comments get deleted too! :)

Apr 16, 2012 17:07

There's a tool to delete all spam comments and/or hits. Check the Tools > Antispam > Tools tab


Form is loading...

powered by b2evolution free blog software – This forum is powered by b2evolution CMS, a complete engine for your website.