MyBB Community Forums
Clean all threads subscriptions - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: Clean all threads subscriptions (/thread-225782.html)



Clean all threads subscriptions - mhh_rabih - 2019-12-20

Dear folks,
Hope my post finds you well.

Due to massive subscriptions on threads which mostly are very old, I would like to clean all threads subscriptions at once.
What if I truncate the table: mybb_threadssubscriptions? 
Will this do the job? 
I only need clean but not disable so if a member want to re-subscribe to a thread he can.

Best regards.


RE: Clean all threads subscriptions - SvePu - 2019-12-20

You simply could truncate db tables "threadsubscriptions" or "forumsubscriptions" - then all subscriptions are gone.


RE: Clean all threads subscriptions - [ExiTuS] - 2019-12-20

Yes,
truncate mybb_threadsubscriptions to remove all subscriptions on threads.
Optionally truncate mybb_forumsubscriptions to remove all subscriptions on forums.

There should be no need to refresh chaches.

[ExiTuS]