From 368d2a885312ac15093ad0610488266c2a331637 Mon Sep 17 00:00:00 2001 From: Pradeep Nayak Date: Fri, 15 Mar 2013 23:38:38 +0530 Subject: [PATCH] --fixed for CRM-12061, fee_amount should be greater then 0 to create extra entry --- CRM/Upgrade/Incremental/php/FourThree.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/php/FourThree.php b/CRM/Upgrade/Incremental/php/FourThree.php index c82367c08c..db6c482c09 100644 --- a/CRM/Upgrade/Incremental/php/FourThree.php +++ b/CRM/Upgrade/Incremental/php/FourThree.php @@ -522,7 +522,7 @@ FROM civicrm_contribution con AND efaPP.account_relationship = {$assetAccountIs}) LEFT JOIN {$tempTableName1} tpi ON ft.payment_instrument_id = tpi.instrument_id -WHERE con.fee_amount IS NOT NULL AND (con.contribution_status_id IN (%1, %3) OR (con.contribution_status_id =%2 AND con.is_pay_later = 1)) +WHERE ft.fee_amount IS NOT NULL AND ft.fee_amount != 0 AND (con.contribution_status_id IN (%1, %3) OR (con.contribution_status_id =%2 AND con.is_pay_later = 1)) GROUP BY con.id"; CRM_Core_DAO::executeQuery($sql, $queryParams); -- 2.25.1