[Forum] Members Receiving Email Notifications for Threads Not Subscribed

[qubed]

Hi -

I recently disabled thread subscription by email and also executed the MySQL Query for:

Do not subscribe
Subscribe No Notification
Instant Notification
Daily Notification
Weekly Notification

However, random users and even myself (Admin) are receiving notifications by email for threads never subscribed to. What is going on and what is the best way to remedy this?? Is there also a specific way to turn off thread/subscription notification by usergroup?

Thanks!

qubed

[TheNewOne]

click on settings top right of your forum see if any are in there

[Wayne Luke]

You want to eliminate all subscriptions and the resulting emails? If so, run these queries:

truncate subscribeforum;
truncate subscribethread;
truncate subscribegroup;
truncate subscribeevent;
truncate subscribediscussion;

These will delete all subscriptions for the the site.

[qubed]

Thanks for the responses. I appreciate it,

If I run the truncates that Wayne mentioned, will users be able to subscribe again to threads after running this?

Also, currently, I noticed that when I post a message that in my Quick Reply/Editor has Subscribe to thread automatically when I am in "Go Advanced" mode. How do I prevent this from being auto checked and also how do I prevent this from being auto checked for users as well if this is also happening to them?

Thank you!

qubed

[Wayne Luke]

Yes, they will be able to resubscribe. It will just reset the tables to their original states.

The auto-check is based on your setting within your User Profile. You should be able to reset this with an auto-query under Maintenance -> Execute SQL Query.

[qubed]

Just to follow-up before I make any changes to my database (I will still back it up anyway), to change the setting so the auto-check is not automatically checked in the user profile, is there a specific SQL Query in the Maintenance section that I should run.

If there is something specific I can run that would uncheck this by default for all users I would prefer to do that than run other SQL Queries that would remove currently subscribed threads. My apologies for the redundancy, just want to make sure I am doing the right thing and choosing the right option to sort this.

[Wayne Luke]

The queries are listed as:

Do Not Subscribe
Subscribe without Notification
Instant Email Notification
Daily Email Notification
Weekly Email Notification

[qubed]

Is there a way to disable Automatic Thread Subscription Mode so all usergroups will be reset to "Do Not Subscribe" in their profile and if they choose to subscribe to a different method they can manually change it from do not subscribe to instant, daily or weekly?

[Wayne Luke]

You can do this using an Automatic Query under Maintenance -> Execute SQL Query.

[Lynne]

You may also want to change this for newly registered users in AdminCP > Settings > Options > User Registration Options > Default Options > Automatic Thread Subscription Mode > Do not subscribe

[qubed]

Following back up on this as I have had the subscriptions turned off since this thread.

Is there a way to turn thread/post subscriptions on for a specific usergroup only?

[Lynne]

Not without modifying the code, no.

[qubed]

Ok. Thank you for the quick response.

What is the best way to turn the subscriptions back on? I'd like users to be able to receive email notifications of their subscribed threads. This is currently off, however they are able to subscribe to threads, just not get an email right now.

To clarify, users who are currently subscribed to threads have Forums > Settings > General Settings > Instant - enabled, but they aren't receiving instant updates.

For new users in vb options, it is currently set to "Do not subscribe". Do I need to turn this back on so existing users can get emails again too?