bbPress

Info

• 2 posts
• 1 voice
• Started 2 years ago by hpguru
• Latest reply from hpguru

Tags

• database
• Delete
• deleted posts
• spam

• Posts in this topic

How-to: Delete all spam and deleted posts or topics from database

1. • 
   • hpguru
   • Member

   • Posted 2 years ago #

   You need phpMyAdmin. In PHPMYADMIN´s bbPress database choose SQL. Go here. Please backup first!

   DELETE FROM *bb_posts* WHERE *bb_posts*.*post_status* =2 ;
   
   DELETE FROM *bb_posts* WHERE *bb_posts*.*post_status* =1 ;

   PLEASE CHANGE ALL * TO BACKTICKS `

   OK. Spam and deleted posts now deleted from db.

   2 = spam

   1 = deleted posts
2. • 
   • hpguru
   • Member

   • Posted 2 years ago #

   Now we deleted spam topics and deleted topics

   DELETE FROM *bb_topics* WHERE *bb_topics*.*topic_status* =2 ;
   
   DELETE FROM *bb_topics* WHERE *bb_topics*.*topic_status* =1 ;

   PLEASE CHANGE ALL * TO BACKTICKS `

   2 = spam

   1 = deleted topics

3. You must log in to post.