CUNY Academic Commons

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.