From e614da42dda4be347a6f3ebdb9162c1fe873e5ec Mon Sep 17 00:00:00 2001 From: Seamus Lee Date: Thu, 2 Nov 2017 11:14:44 +1100 Subject: [PATCH] Fix GenerateData for only_full_group_by sqlMode --- sql/GenerateData.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/GenerateData.php b/sql/GenerateData.php index f837c0a70f..2ef3c09c53 100644 --- a/sql/GenerateData.php +++ b/sql/GenerateData.php @@ -1951,7 +1951,7 @@ AND a.details = 'Membership Payment' $sql = "INSERT INTO civicrm_contribution (contact_id, financial_type_id, payment_instrument_id, receive_date, total_amount, currency, receipt_date, source, contribution_status_id) SELECT `contact_id`, $financialTypeID, $paymentInstrumentID, now(), `fee_amount`, 'USD', now(), CONCAT(ce.title, ' : Offline registration'), 1 FROM `civicrm_participant` cp LEFT JOIN civicrm_event ce ON ce.id = cp.event_id -group by `contact_id`;"; +group by `contact_id`, `fee_amount`, `title`;"; $this->_query($sql); -- 2.25.1