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

adnoidman

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!!!

peregrine

were you aiming for three times as many good answers by posting the same thing thrice, or did you have a spasm in your mouse-clicking finger?

triplicate ironic (as some would think:), eh? - much more of this, and we put a restraining device on your clicking finger. @adnoidman

this is triplicate. answer in your other post? goal here - is not to post the same thing twice or for that matter thrice - for everyone's sake

see http://vanillaforums.org/discussion/22060/import-from-bbpress-1-x-brought-all-deleted-posts-with-it-any-easy-way-to-delete-them#latest

Also see the FAQ

Question 99: How do I stop posting the same question 3x?