SQL query to reset the social groups permission error?

[jilly]

Can someone help me with a sequel query to reset all usergroups to have the options for Social Groups be:
Can Always Post Messages - NO
Can Always Create Discussions - NO

I have over 100 usergroups and it would take a long time for me to manually reset them all.
I tried the one in the bug report and that didn't seem to work

[Wayne Luke]

After running the query that you have, open a single usergroup up for editing and save it. Don't change any settings.

[jilly]

Do you have to do it with each usergroup? (open and save?) I have opened up and edited seferal and saved them, and none of the subsequent ones had the proper permissions - was it because I was manually resetting them?

[Wayne Luke]

If you manually reset them then you override the query. When ever you manipulate the database directly you need to rebuild the datastore cache. In this case opening one usergroup and saving it immediately after running the query will trigger a rebuild of the datastore cache.

[jilly]

Okay, I re-ran the query, and then opend a usergroup and saved it to reset the permisisons, but it did not work. :(

[Wayne Luke]

I don't know why it wouldn't have. Unfortunately, then you will have to reset all the permissions manually.