X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=sql%2FGenerateData.php;h=2ef3c09c53704ad38f3e2e38b0dec51ea6488a92;hb=6b242b6e5990932c2002c74d3017aa7101c734dc;hp=f837c0a70f4639769f233d9ac75858b194e6f343;hpb=38e3b733d59dc8bd7b59117be948831396787d2b;p=civicrm-core.git

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);