Skip to:
Content
Pages
Categories
Search
Top
Bottom

Removing a boatload of spam posts and tags

  • I’ve just found an old 1.03 bbpress install with a ton of spam posts and spam tags. I don’t want to start over completely. I suppose going thru phpMyAdmin directly would be fastest, unless the 2.0 beta has new admin options in the backend.

    To remove unwanted posts, I can just run a query for all posts created after a certain date in the bb_posts table.

    How do I remove tags? I’m not sure what the relationship between bb_terms, bb_term_relationships, and bb_term_taxonomy are.

    Are there other tables I need to look at where SPAM might have gotten in?

    After I get rid of all the SPAM I’ll be looking to move to 2.0 asap :)

  • You must be logged in to reply to this topic.
Skip to toolbar