Another XF site that I use has it set to have the thread automatically watched anytime the users replies, likes, etc. I thought I saw this option somewhere before but I cannot find it for the life of me now...
The issue is, that most of them started to complain regarding the tons of mails they're receiving.
For me it would be a much nicer move to be able to have the "Watch this thread... and receive email notifications" unticked by default. This way noone is automatically subscribed to a thread.
If someone wants to follow a thread, discussion he can tick it, but by default should be unticked.
I've found this from @Jake Bunce, posted in 2011. Is this going to work on the latest database?
SET default_watch_state = '';
Wired things happen.
Did the query with the result "271 rows affected. (Query took 0.2835 sec)", but the "Watch this thread... and receive email notifications" is still ticked by default and in /account/alert-preferences is everything ticked too.
Am I missing something?