Activity App Email Boxes unchecked for users

ℹ️ Support
1

We use the Activity app to notify users when they have new uploaded files. The notifications were working just fine. I recently upgraded from 19.x to 22.2.0. In the settings for the Activity app, the checkboxes for “A file or folder has been changed” and “A file has been added to or removed from your favorites” used to be checked for every user, but now they are all unchecked?

We have hundreds of users, so it would take several hours to use the impersonate app to go into each users account and re-check those boxes. And even if we did do that, there’s no assurance that the boxes would stay checked.

Does anyone know of a SQL query that would recheck those boxes for all users simultaneously? And does anyone have any idea why those boxes would now be unchecked?

Thank you,
Mark

Nextcloud version: 22.2.0
Operating system and version: Ubuntu 20.04
Apache version: 2.4.41
PHP version: 7.4.3
MySQL version: 15.1 Distrib 10.3.31-MariaDB

2

I’m still not sure how the “A file or folder has been changed” and “A file has been added to or removed from your favorites” boxes got unchecked. But here’s my fix:

Login to MySQL with your Nextclouduser user and run the following MySQL query:

UPDATE nextcloud.oc_preferences SET configvalue = ‘1’ WHERE appid = ‘activity’ AND (configkey = ‘notify_email_favorite’ OR configkey = ‘notify_email_file_changed’ OR configkey = ‘notify_email_file_created’);

That’s it. All of your users should now receive email notifications whenever a file is uploaded or modified.