Fresh out of the box Moodle sets each user’s default setting Forum Auto-subscribe: as Yes: when I post, subscribe me to that forum.

This can be changed by the user when they edit their profile. However, I have found out that many users do not know how to change this, that it can be changed or they forgot to change it. I’ve gotten several questions from teachers wondering why they are getting these strange e-mails from Moodle telling them that Sue Johnson has posted in a Forum in the Moodle Training course they were in months ago!
Now, we tell our staff in the training to change this setting in their profile but I think it would be much easier to make this feature an “opt-in” instead of an “opt-out”. There has been a lot of discussion about this issue and Martin Dougiamas explains that it basically encourages interaction. In my opinion, having this feature be an “opt-in” situation works best for our district. Teachers get enough e-mail and it will more than likely just annoy or frustrate them if they don’t know why they’re getting all of the e-mails or how to stop them from coming in. If a user wants to really follow a Forum they will take the time to click that option when they post.
Another problem with Subscribing to a Forum is that sometimes I want to follow just a post in a Forum, not the entire Forum! I think there should be a “Subscribe to Thread” option, like many of the Forums on the web.
Anyways, while searching the web and the Moodle.org Forums I found an answer to setting the Auto-subscribe setting default to be “No: don’t automatically me to forums” for new users and a way to change that setting for users already in the system:
If you have access to your database through phpmyadmin, then just do the following.
1. Select the mdl_user table
2. Click on the pencil (to edit) beside autosubscribe
3. Change the default value from 1 to 0
The above will change the default value for all new accounts.
1. Select the mdl_user table
2. At the top, click on SQL
3. Erase what is in the query field and enter the following:
UPDATE mdl_user SET autosubscribe = 0
4. Press “Go”
This will change all existing accounts to “No: don’t automatically subscribe me to forums”.
Note: It’s always a good idea to back up your database before doing anything like this. Use at you own risk
Source: http://moodle.org/mod/forum/discuss.php?d=94386
I do not have the rights to phpmyadmin for our Moodle site but I was able tell our network person how to do this and it was done. It seemed to have worked but as we continue trainings some teachers are still getting the “Yes” option. I am currently waiting to try it again with our network person to check out the problem. Although, I am having problems with it working 100% all of my research has pointed to the above solution. Any information about this issue would be greatly appreciated! I may be missing another setting I need to cahnge. Any opinions or information on this?