View Full Version : [Solved] Unsubscribe All Users from Specific Threads
Stratis
07-12-2015, 07:05 AM
I have an issue, when I want to delete subscribes from users it says "No Threads Matched Your Query" This is wrong, because I see that member is subscribed to that thread.
I thing that i cannot delete subscribes that they have the option "Notification none" I don't know how this option is there for users. That's what I see to mine two other user I have.
If option is something else except Through my control panel only, no problem.
Any help why this is happening, Thanks
ForceHSS
07-12-2015, 05:23 PM
Can you post the query you are using
Stratis
07-12-2015, 05:38 PM
I just go to admins panel.
Threads & Posts - Unsubscribe - Unsubscribe All Users from Specific Threads
Enter the threadid(s) of the threads from which you want to unsubscribe users.
I put there thread id, or to the other option
Unsubscribe All Threads from Specific Users
that's all, thanks
ForceHSS
07-12-2015, 06:16 PM
Double check thread id as it must be wrong. You could go to users profile from admincp click on Quick User Links and Delete Subscriptions then from there
Stratis
07-13-2015, 02:41 AM
The id thread are ok, and I can delete members subscribes that they choose notification by email, if they choose only by control panel, then I cannot delete.
By user as you say, yes this way I can delete it, but I don't want to delete all subscribes for all threads. Thank you for the answer.
Meanwhile I have removed code from all places so members cannot have the option "Through my control panel only"
ForceHSS
07-13-2015, 04:40 AM
Run this query from your admincp
DELETE FROM `subscribethread` WHERE (`subscribethreadid`='x')
Change the x to what you need it will remove anyone subscribe to the thread you want
Or if you want to do for just one user for one thread
DELETE FROM `subscribethread` WHERE `userid`='x' AND (`subscribethreadid`='x')
Change the userid and subscribethreadid
Stratis
07-13-2015, 04:53 AM
Thanks for this help, I will do so.
Any way I must find why I cannot delete those subscribes from user that select notification "Through my control panel only" with the physical way as supposed to be.
I am sure that the advice with query will work.
Thank you very much, hope though some one else maybe had same issue, or he don't know
if it even exist. I did not to, and came up with this issue when I try to delete them.
ForceHSS
07-13-2015, 04:57 AM
Check server error logs there might be some info there, well this hope
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.