From 4052437c175255fa43b0c885c588fa8738210679 Mon Sep 17 00:00:00 2001 From: Jitendra Purohit Date: Tue, 21 Apr 2020 15:36:30 +0530 Subject: [PATCH] dev/mail#62 - Mailing Error when civicrm_mailing_group has duplicate entries of recipient groups --- CRM/Mailing/BAO/Mailing.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Mailing/BAO/Mailing.php b/CRM/Mailing/BAO/Mailing.php index a2b20bcf32..46ee694de3 100644 --- a/CRM/Mailing/BAO/Mailing.php +++ b/CRM/Mailing/BAO/Mailing.php @@ -120,7 +120,7 @@ class CRM_Mailing_BAO_Mailing extends CRM_Mailing_DAO_Mailing { $mailingGroup = new CRM_Mailing_DAO_MailingGroup(); $recipientsGroup = $excludeSmartGroupIDs = $includeSmartGroupIDs = $priorMailingIDs = []; $dao = CRM_Utils_SQL_Select::from('civicrm_mailing_group') - ->select('GROUP_CONCAT(entity_id SEPARATOR ",") as group_ids, group_type, entity_table') + ->select('GROUP_CONCAT(DISTINCT entity_id SEPARATOR ",") as group_ids, group_type, entity_table') ->where('mailing_id = #mailing_id AND entity_table RLIKE "^civicrm_(group.*|mailing)$" ') ->groupBy(['group_type', 'entity_table']) ->param('!groupTableName', CRM_Contact_BAO_Group::getTableName()) -- 2.25.1