From c9152bd23f061c9d903a679d2cfa02a253a4d70e Mon Sep 17 00:00:00 2001 From: Jamie McClelland Date: Mon, 18 Aug 2014 11:38:32 -0400 Subject: [PATCH] CRM-14930 - ensure data integrity of all contributions. Some auth.net contributions may not have correct net amount set. ---------------------------------------- * CRM-14930: Authorize.net silentpost transactions cannot be edited due to invalid net_amount https://issues.civicrm.org/jira/browse/CRM-14930 --- CRM/Upgrade/Incremental/sql/4.5.beta7.mysql.tpl | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 CRM/Upgrade/Incremental/sql/4.5.beta7.mysql.tpl diff --git a/CRM/Upgrade/Incremental/sql/4.5.beta7.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.beta7.mysql.tpl new file mode 100644 index 0000000000..16e8767696 --- /dev/null +++ b/CRM/Upgrade/Incremental/sql/4.5.beta7.mysql.tpl @@ -0,0 +1,2 @@ +{* file to handle db changes in 4.5.beta7 during upgrade *} +UPDATE civicrm_contribution SET net_amount = total_amount - fee_amount WHERE net_amount = 0 OR net_amount IS NULL; -- 2.25.1