XF 2.2 Email notifications being sent despite being disabled...

[Jwrbloom]

My Users and even I are getting email notifications on watched topics, despite setting them to either No or Yes (vs. Yes, with email).

 

[Paul B]

They will need to also stop watching all threads and forums.

 

[Jwrbloom]

They will need to also stop watching all threads and forums.

Doesn't that defeat the purpose of the settings?

They want to watch topics they're participating in, so it notifies them when they are on the site. They just don't want to get an email.

 

[Jwrbloom]

 

[Paul B]

The settings do not override any existing content they are already watching with email notifications.

 

[Jwrbloom]

The settings do not override any existing content they are already watching with email notifications.

So unfollow all content, then set it back?

 

[Jwrbloom]

Can I just update the database and set the registration settings to Yes (w/o email)?

 

[Chromaniac]

Can't say that it is possible through sql manipulation coz it involves multiple users and multiple threads and forums and more like direct conversations and all that. Developers usually discourage such attempts as these are usually not something stored in single tables in database. Someone else might have a better idea about this.

Proper route is to use the link in the footer of each mail sent by the forum (disable all emails. is a link that is included in all alerts sent by the forum). Or on watched sections on the forum itself like these links here:

https://xenforo.com/community/watched/forums
https://xenforo.com/community/watched/threads

PS: This applies for already watched data. Changing watched setting for all members should be doable through a mysql command.

This might be useful: https://xenforo.com/community/threa...ifications-for-every-user.219169/post-1666641

(I tried chatgpt but the mysql command it generated does not seem to show any results here so not posting the command it suggested)

 

[Jwrbloom]

Can't say that it is possible through sql manipulation coz it involves multiple users and multiple threads and forums and more like direct conversations and all that. Developers usually discourage such attempts as these are usually not something stored in single tables in database. Someone else might have a better idea about this.

Proper route is to use the link in the footer of each mail sent by the forum (disable all emails. is a link that is included in all alerts sent by the forum). Or on watched sections on the forum itself like these links here:

https://xenforo.com/community/watched/forums
https://xenforo.com/community/watched/threads

PS: This applies for already watched data. Changing watched setting for all members should be doable through a mysql command.

This might be useful: https://xenforo.com/community/threa...ifications-for-every-user.219169/post-1666641

(I tried chatgpt but the mysql command it generated does not seem to show any results here so not posting the command it suggested)

So it wouldn't be it the xf_thread_watch table, under email_subscribe, which appears to be binary 0 or 1?

user_id | thread_id | email_subscribe

 

[beerForo]

They can unsubscribe from one of the emails they received.
Confirm action
Stop notification emails from all threads

 

[Jwrbloom]

They can unsubscribe from one of the emails they received.
Confirm action
Stop notification emails from all threads

Understood, but they would have to do it individually. If I set all previous subscribes from 1 to 0, that solves the problem in bulk.

Then make changes to the User Option table impacts futures instances.

 

[beerForo]

You can still run into the issue again if someone checks the box and unchecks it later, they will still receive the same emails. They can unsubscribe in the email though just like you would if you got one from a company.

 

[Jwrbloom]

You can still run into the issue again if someone checks the box and unchecks it later, they will still receive the same emails. They can unsubscribe in the email though just like you would if you got one from a company.

I did both.

thread_watch table I switched all 1's to 0's (that combats previous watched topics)

Then in options I switch all watch_email to watch_no_email (that compost previous watched topics)

 

[beerForo]

Well they can still check the box themselves and uncheck it later so it puts the user back in the some position but if it works for you great.

 

[beerForo]

I guess those who wanted the emails will now complain oops!

 

[Jwrbloom]

34

I guess those who wanted the emails will now complain oops!

None of them wanted emails. It's a 40 member but active community.

 

[beerForo]

That's cool glad it worked.

 

[Jwrbloom]

That's cool glad it worked.

Fingers crossed.