Category Remains Muted after Category is available to Everyone
Craig_Oates has a “sneak-peaks” category that was initially restricted to a specific group. After removing the group requirement and changing permissions, users still have the category muted in their preferences.
simon provides a solution to unmute the category for all users by adjusting the default categories muted setting in the site settings page. If the category is listed, remove it and apply the changes historically. If not listed, add and then remove the category from the setting, applying the changes historically.
Alternatively, users with the Data Explorer plugin can view category notification levels for all users with a SQL query. The query requires a category name and notification level, with 0 representing a muted category.
codinghorror corrects the category name to “sneak-peeks.”
We have a category that is for “sneak-peaks” so select customers are invited only. Those customers had their own Group and could see this category.
The “sneak-peak” has since matured, so we have removed the Group requirement and changed the permissions to see the category as Everone See/ Reply and only Admins to create.
However, users seem to have the same category as “muted” in preferences.
How can I view all users that currently have this category as muted, and how do I remove this for them?
To unmute a category for all users, go to your site settings page and enter default categories into the search box. This will take you to all your default category notification settings. If the sneak-peaks category is listed in your default categories muted setting, remove it from that setting. When you save the setting, you will be asked if you “would you like to apply this change historically?” Selecting “Yes” will unmute the category for all users on your site.
If the sneak-peaks is not listed in your default categories muted setting, you can still unmute it for all users. First, add sneak-peaks to the default categories muted setting. Save the setting, but do not select the option to apply changes historically. Now, remove sneak-peaks from your default categories muted setting. Save the setting again, but this time do select the option to apply changes historically. This will unmute the category for all users.
If you have the Data Explorer plugin installed on your site, you can view the category notification levels for all users in a category with the following query:
--[params]
-- string :category_name
-- string :notification_level
SELECT
cu.user_id
FROM category_users cu
JOIN categories c
ON c.id = cu.category_id
WHERE c.name = :category_name
AND cu.notification_level = :notification_level
To run the query, you need to supply a category name and a notification level. The notification level is set with a number. To find all users who have muted a category, enter 0 into the notification level input. The available notification levels are 0 (muted), 2 (tracking), 3 (watching), 4 (watching first post.)
