Ejegg has submitted this change and it was merged.
Change subject: Aggregate contact ID in select (MySQL 5.7 fix)
......................................................................
Aggregate contact ID in select (MySQL 5.7 fix)
We want the latest contact ID - this makes that deterministic and
makes stricter 5.7 defaults happy.
Change-Id: Ifc902597d89801695f05f0175806a267427093a1
---
M silverpop_export/update_table.sql
1 file changed, 1 insertion(+), 1 deletion(-)
Approvals:
Ejegg: Verified
Awight: Looks good to me, approved
diff --git a/silverpop_export/update_table.sql
b/silverpop_export/update_table.sql
index d796db1..ba294e0 100755
--- a/silverpop_export/update_table.sql
+++ b/silverpop_export/update_table.sql
@@ -198,7 +198,7 @@
INSERT INTO silverpop_export_stat
(email, exid, max_amount_usd, total_usd, cnt_total, has_recurred_donation)
SELECT
- e.email, ex.id, MAX(ct.total_amount), SUM(ct.total_amount),
+ e.email, MAX(ex.id), MAX(ct.total_amount), SUM(ct.total_amount),
count(*),
MAX(IF(SUBSTRING(ct.trxn_id, 1, 9) = 'RECURRING', 1, 0))
FROM civicrm.civicrm_email e FORCE INDEX(UI_email)
--
To view, visit https://gerrit.wikimedia.org/r/288030
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Ifc902597d89801695f05f0175806a267427093a1
Gerrit-PatchSet: 3
Gerrit-Project: wikimedia/fundraising/tools
Gerrit-Branch: master
Gerrit-Owner: Ejegg <eeggles...@wikimedia.org>
Gerrit-Reviewer: Awight <awi...@wikimedia.org>
Gerrit-Reviewer: Ejegg <eeggles...@wikimedia.org>
Gerrit-Reviewer: Springle <sprin...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
