CiviCRM Community Forums (archive)

Had an interesting situation -- client reported some of their past mailings were not listed in the scheduled/past mailings list. The records were appearing in civicrm_mailing, they were not archived, and from everything I could tell by reviewing the db, they were no different than any other mailing records.

I took a look at the queries for that page, and found that there was a dependency on civicrm_mailing_group.entity_id, which is a FK to civicrm_group.id. The issue was that some of the missing mailings used a Group that was later deleted from the system. Because the id did not exist, the query broke down and the mailing record did not display.

I don't think the mailing records should be dependent on the existence of the group. Since CiviMail is very dependent on groups, it's not uncommon for people to create a temporary group in order to run a mailing, and then remove that group at a later date when it's no longer needed. But the record of the mailing should remain. The mailing report page, which currently has a hotlink to the groups included in the mailing, should be altered so that it's only linkable if the group exists. CiviMail logs the actual recipients/bounces so that is not dependent on groups.