Solved: 6 Years, 8 Months, 3 Weeks ago How to unsubscribe all users from forum subscriptions
#1
Solved: 6 Years, 8 Months, 3 Weeks ago
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?
Reply
#2
Solved: 6 Years, 8 Months, 3 Weeks ago
UPDATE `mybb_users` SET `subscriptionmethod` = '0';

AND / OR
TRUNCATE TABLE mybb_forumsubscriptions;
TRUNCATE TABLE mybb_threadsubscriptions;


Reply
#3
Solved: 6 Years, 8 Months, 3 Weeks ago
(2014-09-07, 12:27 PM).m. Wrote:
UPDATE `mybb_users` SET `subscriptionmethod` = '0';

AND / OR

TRUNCATE TABLE mybb_forumsubscriptions;
TRUNCATE TABLE mybb_threadsubscriptions;




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
a Star tickled Pink
Reply
#4
Solved: 6 Years, 8 Months, 3 Weeks ago
Via your database administratoive tool
Do NOT pm me for support on ANY of my plugins
DO pm me if you got suggestions for existing ones (although posting in the proper thread is preferred), or suggestions/ideas for new plugins (keep in mind I'm an amateur but not necessarily a beginner.)
Reply
#5
Solved: 6 Years, 8 Months, 3 Weeks ago
(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;





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';
Find me here or at my new blog about MyBB, Web Design, SEO
My Services
MyBB Themes
Reply
#6
Solved: 6 Years, 8 Months, 3 Weeks ago
Thank you very much ThemeFreaknet

PinkStar
a Star tickled Pink
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)