MyBB Community Forums

what the query to unsubscribe all users from all forum subscriptions. I have a feeling people are clicking this on accident.

---

Can i Just delete all rows in the forumsubscriptions table?

UPDATE `mybb_users` SET `subscriptionmethod` = '0';

AND / OR

TRUNCATE TABLE mybb_forumsubscriptions;

TRUNCATE TABLE mybb_threadsubscriptions;

(2014-09-07, 12:27 PM).m. Wrote: [ -> ]

UPDATE `mybb_users` SET `subscriptionmethod` = '0';

AND / OR

TRUNCATE TABLE mybb_forumsubscriptions;

TRUNCATE TABLE mybb_threadsubscriptions;

[automatic subscriptions]

I too want to unsubscribe my members most likely accidental subscriptions, but not sure how to do it.
Where to I use these strings?

Thank  you
PinkStar

Via your database administratoive tool

(2015-02-27, 08:17 PM)PinkStar Wrote: [ -> ]

(2014-09-07, 12:27 PM).m. Wrote: [ -> ]

UPDATE `mybb_users` SET `subscriptionmethod` = '0';

AND / OR

TRUNCATE TABLE mybb_forumsubscriptions;

TRUNCATE TABLE mybb_threadsubscriptions;

[automatic subscriptions]

I too want to unsubscribe my members most likely accidental subscriptions, but not sure how to do it.
Where to I use these strings?

Thank  you
PinkStar

If you have CPANEL enabled host its easy. Of course, backup your database always before any changes.

1. log into phpMyAdmin
   
2. find & select your database in the left column
   
3. find "SQL" tab in the right column
   
4. use the query - UPDATE mybb_users SET subscriptionmethod = '0';
   

Thank you very much ThemeFreaknet

PinkStar