Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-21848

Mailing no longer filters out email addresses on hold from recipient group

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.7.31
    • Fix Version/s: 5.0.0
    • Component/s: CiviMail
    • Labels:
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Needs Funding
    • Verified?:
      No
    • How it works currently:
      Hide
      Create a test contact and put there email address on hold.
      Create a test mailing group and add the above address.
      Create a new mailing and add the above group as recipients
      Email address isn't filtered out.

      SELECT * FROM `civicrm_mailing_recipients` JOIN civicrm_email ON civicrm_mailing_recipients.email_id = civicrm_email.id WHERE `mailing_id` = 158 AND civicrm_email.on_hold =1


      id mailing_id contact_id email_id phone_id id contact_id location_type_id email is_primary is_billing on_hold is_bulkmail hold_date reset_date signature_text signature_html
      2162629 1607 1 awilson@bademail.com 1 0 1 0 2015-05-04 18:50:02
      2162630 10802 1 amanda@bademail.com 1 0 1 0 2018-02-06 21:20:03
      Show
      Create a test contact and put there email address on hold. Create a test mailing group and add the above address. Create a new mailing and add the above group as recipients Email address isn't filtered out. SELECT * FROM `civicrm_mailing_recipients` JOIN civicrm_email ON civicrm_mailing_recipients.email_id = civicrm_email.id WHERE `mailing_id` = 158 AND civicrm_email.on_hold =1 id mailing_id contact_id email_id phone_id id contact_id location_type_id email is_primary is_billing on_hold is_bulkmail hold_date reset_date signature_text signature_html 2162629 1607 1 awilson@bademail.com 1 0 1 0 2015-05-04 18:50:02 2162630 10802 1 amanda@bademail.com 1 0 1 0 2018-02-06 21:20:03
    • How it should work:
      Email address which is on hold should be filtered out of recipient list.

      Description

      I had to abort my last mailing due to excessive bounces.  In looking into the issue I discovered addresses which are on_hold are no longer being filtered out from the recipient list when you add the mailing group.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              darrick Darrick Servis
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: