Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: Removing all Bozo data from my database


John Conners
Participant

@johnconners

To stop all users from being marked as bozos you’ll need to run the following SQL scripts (you mentioned you did this above but thought I’d put the exact statements in to make sure you didn’t miss anything):

delete from bb_usermeta where meta_key = ‘is_bozo’;

delete from bb_usermeta where meta_key = ‘bb_bozo_topics’;

And to un-bozo all topics and posts you’ll need to run the following scripts:

delete from bb_topicmeta where meta_key = ‘bozos’;

update bb_topics set topic_status = 0 where topic_status = 2;

update bb_posts set post_status = 0 where post_status = 2;

I’d back your database up first though just to be on the safe side but the above should do the trick. I suspect the topic totals will be out of sync once you do this so you’ll need to recount the totals from the admin section.

Skip to toolbar