Solved how to disable auto subscribe?

I have upgrade my Kunena to latest version 4.0.7 and now when a user reply a topic, it gets automatic subscription to that topic. It's absolutely crazy in large forums like mine, where a topic could have 20 or 30 replies in one day and a user could reply 10 to 20 topics. So, in one day he could receive hundreds of notification emails.

Please, help me in how to disable this!?

I have 72000 registered users, so, tell the users how to disable it manually in his profiles is not a "profesional" option. I need the SQL sentence and instructions on where to disable it for new users.

www.kunena.org/forum/k-4-0-support-archi...nena-4-05-sos#168447

Thanks, then solution is

Change #_ with your prefix.

What about new users? will them have it set to Yes or No? i'm using jomsocial, so register process is a different.

Related to this. How can i edit the text for the "new reply" notification email?

new users get the default setting (configuration option). As far i know jomsocial does not have kunena user settings on their edit profile. So they can't change it thereself.

Only using by the buttons on the forum, for example subscribe category/topic.

For editing text you can edit the strings on:
plugins\kunena\community\language\en-GB\en-GB.plg_kunena_community.sys.ini

but you need to create a language override, else the strings are gone on a update.

Yes, my users can disable it thereself because i have created a new option in the Kunena Menu to have direct acces to edit kunena user settings

The language string file that you pointed is the en-gb version, but i receive the emails in spanish language. In plugins\kunena\community\language there isn't es-ES folder or version of the file... so... where it could be?