Skip to:
Content
Pages
Categories
Search
Top
Bottom

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

  • 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

Viewing 1 replies (of 1 total)
  • 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

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.