Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Import from bbpress 1.x brought all "deleted" posts with it. Any easy way to delete them?

So, I am a brand new user to Vanilla and I am upgrading from bbpress 1.0.3. This is a fairly large board and there were over 29,000 deleted spam posts alone. When I imported into the Vanilla install, it brought every single post, including all of the supposedly deleted posts. Many of these were originally caught by the Akismet plugin, and I didn't realize that there were this many. So, is there any way to get rid of the spam/deleted posts? The new board isn't open yet, so I can re-import if there is some way to delete them from bbpress first then re-import. Thank you so much for any help!!!


  • Probably the thing to do is identify within your bbpress 1.0.3 what the flag is for deleted posts and delete them prior to the import. There must be some identifier that marks a flag as deleted. I don't use bbpress 1.0.3 but you should be able to identify with phpmyadmin what the the difference in one of the tables that "marks a post as deleted".

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • Ok, thank you @peregrine

  • LincLinc Detroit Admin

    Eww. I'll file a bug ticket too.

  • LincLinc Detroit Admin

    @adnoidman Did you ever figure out what the 'deleted' flag is?

Sign In or Register to comment.