Bug #20484
openDid not receive email notification of reply
0%
Description
Hi Ray -- I posted a message today to our CAC team forum. I received an email notification of my own post, but I did not receive a notification of Colin's reply. I double-checked and my email subscription is all posts. I'm wondering whether the recent release might have changed something . . . can you possibly test and see what might be going on? I did also check my spam folder.
https://commons.gc.cuny.edu/groups/cac-community-team-project-planning/notifications/
Related issues
Updated by Raymond Hoh 9 months ago
- Related to Bug #12499: no email notification added
Updated by Raymond Hoh 9 months ago
I checked the group email subscription queued items database table for Colin's particular reply to Matt's topic and it looks like all 22 members that are subscribed to receive email for the CAC Team group did not get the email:
mysql> select * from wp_bpges_queued_items where activity_id = 999250; +---------+---------+----------+-------------+-----------+---------------------+ | id | user_id | group_id | activity_id | type | date_recorded | +---------+---------+----------+-------------+-----------+---------------------+ | 2533983 | 455 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533984 | 1 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533985 | 49 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533986 | 18 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533987 | 388 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533988 | 4088 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533989 | 3396 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533990 | 5503 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533991 | 3042 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533992 | 7270 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533993 | 4203 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533994 | 3272 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533995 | 14418 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533996 | 10971 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533997 | 11407 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533998 | 55 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2533999 | 23201 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2534000 | 17661 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2534001 | 21887 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2534002 | 31943 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2534003 | 18055 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | | 2534004 | 20753 | 465 | 999250 | immediate | 2024-06-17 17:54:15 | +---------+---------+----------+-------------+-----------+---------------------+ 22 rows in set (0.00 sec)
(If the query above returned empty, then this would mean that email was sent for Colin's reply.)
So then, I checked to see if our health check job for group email subscriptions was running or not. This health check job helps to send out older notifications that were not sent out originally by the Group Email subscription plugin and it looks like that job was removed. I just queued the health check job again and it looks like older, pending email notifications are going out now, including Colin's reply. Also see #12499 where the no email notification bug was last reported.
I guess the next thing to look at is to see why the Group Email Subscription plugin sometimes fails to send out notifications without the health check job. It might be related to how the plugin relies on self-pinging the server to do the sending.