Remove all thread subscriptions?

[welo]

Is there a query that will bulk remove everyone's email notification subscriptions (not just reset the option)? I could have sworn I saw something about this and cannot find it anymore. Thanks .

[Floris]

Maybe this is what you are looking for.

Admin Control Panel > Import & Maintenance > Execute SQL Query > Automatic Query

On-line manual with more details: Execute SQL Query

[welo]

Thanks Floris. However, unless I'm just misreading them, there aren't any queries to actually blanket strip existing email notifications. Maybe it was over at vb.org I saw this.

[Floris]

Hm, yeah. This is probably for future and current preference, but won't do already subscribed ones. Sorry.

(I'll ask a friend if he knows)

[Steve Machol]

Is there a query that will bulk remove everyone's email notification subscriptions (not just reset the option)? I could have sworn I saw something about this and cannot find it anymore. Thanks .

Backup your database, then run this query:

DELETE FROM subscribethread;

This will remove ALL thread subscriptions.

[Deep Blue]

in vB2 you could prune all subscribed threads, has this disappeared?

[Steve Machol]

That was never a feature in vB2.

[Deep Blue]

It so was, from the admin panel you were able to unsubscribe everyone from their subscribed threads!

[welo]

Backup your database, then run this query:

DELETE FROM subscribethread;

This will remove ALL thread subscriptions.

So basically to remove all subscriptions I just need to empty the prefix_subscribethread table? I thought of that and wasn't sure what else I might screw up if I did it.

[Steve Machol]

It so was, from the admin panel you were able to unsubscribe everyone from their subscribed threads!

You are right. Here are the different options.

vB3:
Unsubscribe All Users from Specific Threads
Unsubscribe All Threads from Specific Users

vB2:
Unsubscribe users from specific threads
Mass unsubscribe users from threads (by date)