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.