From ec7990445b7d99c52bab6763ccaafa6f6ffc0c14 Mon Sep 17 00:00:00 2001 From: Jon goldberg Date: Thu, 31 Aug 2017 00:21:38 -0400 Subject: [PATCH] CRM-21121 - Fix crash with sql_mode is only_full_group_by --- CRM/Report/Form/Event/Summary.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/CRM/Report/Form/Event/Summary.php b/CRM/Report/Form/Event/Summary.php index 99a69328da..e4c8572103 100644 --- a/CRM/Report/Form/Event/Summary.php +++ b/CRM/Report/Form/Event/Summary.php @@ -202,7 +202,8 @@ class CRM_Report_Form_Event_Summary extends CRM_Report_Form_Event { $this->_participantWhere GROUP BY civicrm_participant.event_id, - civicrm_participant.status_id"; + civicrm_participant.status_id, + civicrm_participant.fee_currency"; $info = CRM_Core_DAO::executeQuery($sql); $participant_data = $participant_info = $currency = array(); -- 2.25.1