bbPress

Info

• 2 posts
• 2 voices
• Started 3 years ago by SteveDrum
• Latest reply from chrishajer
• This topic is not a support question

Tags

• spam
• spam comments

• Posts in this topic

how to delete spam comments from the database

1. • 
   • SteveDrum
   • Member

   • Posted 3 years ago #

   hello. i just want to check something... before i go and do it and mess everything up.
   askimet has caughts loads of spam comments on my forum, which is great, but they are still in the database. i would like to remove them completely.

   i reckon that this is the correct entry, but does anyone know for sure?

   delete from bb_posts where post_status = '2';
2. • 
   • chrishajer
   • Moderator

   • Posted 3 years ago #

   There was this:
   http://bbpress.org/forums/topic/permanently-deleting-topocs-and-posts

   If post_status 2 is a reply marked as spam, then that query would take care of it. But I think it could strand information in other tables that is related to that reply. I'm thinking specifically where the last reply is attributed to a topic or a user. Not sure what happens when you delete the reply that is referred to in another table.

3. You must log in to post.