Only one notification option are saved

goebelt · October 26, 2023, 11:17am

This is a new setup for the activitys notifications. We never tried or used it before.

If a user selects one notifiaction option e.g.“File has changed” the setting ware saved and works.
If we set a second option e.g. " roup memberships were modified" the system tells us “settings are updated” but after we leave the settings and come back again. None of the options are activated any more.

Strange thing!
The admin can set two options in the default global notification option for new user.
If the admin set a third option, ther are no more options activated, like in the user profile.

Nextcloud Hub 6 (27.1.2)
Opensuse 15.5
PHP 8.2
Apache
mariadb

goebelt · October 26, 2023, 11:50am

I have done some debugging.

Here the first click on Notify-File-Changed:

231026 13:45:12   8481 Connect  nextclouddb@localhost on nextclouddb using Socket
                  8481 Query    SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
                  8481 Query    SET SESSION AUTOCOMMIT=1
                  8481 Query    SELECT * FROM `oc_appconfig`
                  8481 Query    SELECT `uid`, `displayname`, `password` FROM `oc_users` WHERE `uid_lower` = 'aa452c19-56c4-4076-a645-fdaf786583d3'
                  8481 Query    SELECT `appid`, `configkey`, `configvalue` FROM `oc_preferences` WHERE `userid` = 'AA452C19-56C4-4076-A645-FDAF786583D3'
                  8481 Query    SELECT `ldap_dn`
                        FROM `oc_ldap_user_mapping`
                        WHERE `owncloud_name` = 'AA452C19-56C4-4076-A645-FDAF786583D3'
                  8481 Query    SELECT * FROM `oc_authtoken` WHERE (`token` = '7bc5817a83a3887e48562565cc21f1891f7e494525f06f649690af49faed9206b5222ded0b6efacae4d1342b1e50858fa21eced1847e5772aa0589871033658a') AND (`version` = 2)
                  8481 Query    SELECT `gu`.`gid`, `g`.`displayname` FROM `oc_group_user` `gu` LEFT JOIN `oc_groups` `g` ON `gu`.`gid` = `g`.`gid` WHERE `uid` = 'AA452C19-56C4-4076-A645-FDAF786583D3'
                  8481 Query    SELECT `gid` FROM `oc_group_admin` WHERE `uid` = 'AA452C19-56C4-4076-A645-FDAF786583D3' LIMIT 1
                  8481 Query    SELECT `provider_id`, `enabled` FROM `oc_twofactor_providers` WHERE `uid` = 'AA452C19-56C4-4076-A645-FDAF786583D3'
                  8481 Query    UPDATE `oc_preferences` SET **`configvalue` = '1'** WHERE (`userid` = 'AA452C19-56C4-4076-A645-FDAF786583D3') AND (`appid` = 'activity') AND (**`configkey` = 'notify_email_file_changed**')
                  8481 Quit

Then i activate notify group_membership changed.
The only SQL statement mariadb logs is the deactivation of the notify-file-change

231026 13:45:16   8482 Connect  nextclouddb@localhost on nextclouddb using Socket
                  8482 Query    SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
                  8482 Query    SET SESSION AUTOCOMMIT=1
                  8482 Query    SELECT * FROM `oc_appconfig`
                  8482 Query    SELECT `uid`, `displayname`, `password` FROM `oc_users` WHERE `uid_lower` = 'aa452c19-56c4-4076-a645-fdaf786583d3'
                  8482 Query    SELECT `appid`, `configkey`, `configvalue` FROM `oc_preferences` WHERE `userid` = 'AA452C19-56C4-4076-A645-FDAF786583D3'
                  8482 Query    SELECT `ldap_dn`
                        FROM `oc_ldap_user_mapping`
                        WHERE `owncloud_name` = 'AA452C19-56C4-4076-A645-FDAF786583D3'
                  8482 Query    SELECT * FROM `oc_authtoken` WHERE (`token` = '7bc5817a83a3887e48562565cc21f1891f7e494525f06f649690af49faed9206b5222ded0b6efacae4d1342b1e50858fa21eced1847e5772aa0589871033658a') AND (`version` = 2)
                  8482 Query    SELECT `gu`.`gid`, `g`.`displayname` FROM `oc_group_user` `gu` LEFT JOIN `oc_groups` `g` ON `gu`.`gid` = `g`.`gid` WHERE `uid` = 'AA452C19-56C4-4076-A645-FDAF786583D3'
                  8482 Query    SELECT `gid` FROM `oc_group_admin` WHERE `uid` = 'AA452C19-56C4-4076-A645-FDAF786583D3' LIMIT 1
                  8482 Query    SELECT `provider_id`, `enabled` FROM `oc_twofactor_providers` WHERE `uid` = 'AA452C19-56C4-4076-A645-FDAF786583D3'
                  8482 Query    UPDATE `oc_preferences` SET **`configvalue` = '0'** WHERE (`userid` = 'AA452C19-56C4-4076-A645-FDAF786583D3') AND (`appid` = 'activity') AND (**`configkey` = 'notify_email_file_changed'**)
                  8482 Quit

ernolf · October 26, 2023, 2:46pm

Could you monitor directly what arives at the database table, instead:

SELECT * FROM oc_preferences WHERE userid = 'AA452C19-56C4-4076-A645-FDAF786583D3' AND appid = 'activity' AND configvalue != 0;

before and after made changes.

Has ldap always been active from the begining?

Much luck,
ernolf

goebelt · November 8, 2023, 1:04pm

Hi,

yes, ldap is on from beginning. This is a complete new installation.

Here are the requested test.
It now looks like i can activate two options.
If i activate the third one, all the options are gone.

start page Notifications. No option are selected

+--------------------------------------+----------+--------------------------+-------------+
| userid                               | appid    | configkey                | configvalue |
+--------------------------------------+----------+--------------------------+-------------+
| AA452C19-56C4-4076-A645-FDAF786583D3 | activity | notify_setting_batchtime | 3600        |
+--------------------------------------+----------+--------------------------+-------------+

Select option “file/folder changed”

+--------------------------------------+----------+---------------------------+-------------+
| userid                               | appid    | configkey                 | configvalue |
+--------------------------------------+----------+---------------------------+-------------+
| AA452C19-56C4-4076-A645-FDAF786583D3 | activity | notify_email_file_changed | 1           |
| AA452C19-56C4-4076-A645-FDAF786583D3 | activity | notify_setting_batchtime  | 3600        |
+--------------------------------------+----------+---------------------------+-------------+

Select option “folder has been shared”

--------------------------------------+----------+---------------------------+-------------+
| userid                               | appid    | configkey                 | configvalue |
+--------------------------------------+----------+---------------------------+-------------+
| AA452C19-56C4-4076-A645-FDAF786583D3 | activity | notify_email_file_changed | 1           |
| AA452C19-56C4-4076-A645-FDAF786583D3 | activity | notify_email_shared       | 1           |
| AA452C19-56C4-4076-A645-FDAF786583D3 | activity | notify_setting_batchtime  | 3600        |
+--------------------------------------+----------+---------------------------+-------------+

Select option “calender was modified”

+--------------------------------------+----------+--------------------------+-------------+
| userid                               | appid    | configkey                | configvalue |
+--------------------------------------+----------+--------------------------+-------------+
| AA452C19-56C4-4076-A645-FDAF786583D3 | activity | notify_setting_batchtime | 3600        |
+--------------------------------------+----------+--------------------------+-------------+