How to disable auto subscription (blog)

[Omni1]

Hi

(sorry for my english!)

Every time when user adds a comment to the blog will be sent e-mail to all users who commented on the blog with information about the entry. How can I switch off this auto subscription for all users?

I know that it can be turned off in the options for a single user, but I would like to turn off immediately all

Thanks 4 help!

[ozzy47]

You can try this on a test database first to see if it works. (Add a table prefix, if needed). ACP --> Maintenance --> Execute SQL Query

UPDATE blog_user SET subscribeown='none'

and

UPDATE blog_user SET subscribeothers='none'

I think that will work, but, as I said, try it on a test site first. And, before doing it on your live site, be sure to do a database backup.