Activity notification every hour stopped working

Hello:

I have noticed recently that my hourly Activity notification stopped working. I made sure that activity app is working properly which is it when I click on activity I can see new entries but hourly notification is not coming in to my inbox. Now sharing out files and sending notification about the new shares works just fine. Also, cron job is working every 15 minutes:

I did noticed that it stopped working after I have attempted to customize “Activity notification mail” mail template so I reverted back to originally.

Here is my personal page for activity:

Is there a place in database that I can look or somewhere else where possible something is just hanged ?

Here is my Nextcloud configuration:

OS: RHEL 7.3
NC version: 10.0.3
PHP Version: 7.0.10
Memory Limit: 512.0 MB
Max Execution Time: 3600
Upload max size: 513.0 MB
Database: MariaDB
Type: mysql
Version: 5.5.52
Size: 2.7 MB

Hi @GigglingPresident ,

In the database you can find the setting here:

mysql> select * from oc_preferences;
+----------+----------------+-------------------------------+-------------------------------+
| userid   | appid          | configkey                     | configvalue                   |
+----------+----------------+-------------------------------+-------------------------------+
| <USER> | activity       | notify_email_comments         | 1                             |
| <USER> | activity       | notify_email_file_changed     | 0                             |
| <USER> | activity       | notify_email_file_created     | 0                             |
| <USER> | activity       | notify_email_file_deleted     | 0                             |
| <USER> | activity       | notify_email_file_restored    | 0                             |
| <USER> | activity       | notify_email_public_links     | 1                             |
| <USER> | activity       | notify_email_remote_share     | 1                             |
| <USER> | activity       | notify_email_shared           | 1                             |
| <USER> | activity       | notify_email_systemtags       | 1                             |
| <USER> | activity       | notify_setting_batchtime      | 3600                          |
| <USER> | activity       | notify_setting_self           | 1                             |
| <USER> | activity       | notify_setting_selfemail      | 0                             |
| <USER> | activity       | notify_stream_comments        | 1                             |
| <USER> | activity       | notify_stream_file_changed    | 1                             |
| <USER> | activity       | notify_stream_file_created    | 1                             |
| <USER> | activity       | notify_stream_file_deleted    | 1                             |
| <USER> | activity       | notify_stream_file_restored   | 1                             |
| <USER> | activity       | notify_stream_files_favorites | 0                             |
| <USER> | activity       | notify_stream_public_links    | 1                             |
| <USER> | activity       | notify_stream_remote_share    | 1                             |
| <USER> | activity       | notify_stream_shared          | 1                             |
| <USER> | activity       | notify_stream_systemtags      | 1                             | 

The relevant line is:
| <USER> | activity | notify_setting_batchtime | 3600 |

The value is provided in seconds.
There is another thread open, describing the same problem in NC 11.0.2. Maybe we will get a solution there, which could help you as well:

Excellent… Thank you for advice. I will definitely watch this table if issue shows up again.