From abe9581c5c60aeefc30b3b55f7514e8ad30a56c3 Mon Sep 17 00:00:00 2001 From: Pradeep Nayak Date: Sun, 21 Jul 2013 02:03:02 +0530 Subject: [PATCH] -- fixed for CRM-13065 ---------------------------------------- * CRM-13065: Upgrade error http://issues.civicrm.org/jira/browse/CRM-13065 --- CRM/Upgrade/Incremental/php/FourThree.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/CRM/Upgrade/Incremental/php/FourThree.php b/CRM/Upgrade/Incremental/php/FourThree.php index 4b31d2bd27..e0b1da7533 100644 --- a/CRM/Upgrade/Incremental/php/FourThree.php +++ b/CRM/Upgrade/Incremental/php/FourThree.php @@ -330,7 +330,7 @@ ADD CONSTRAINT `FK_civicrm_financial_item_contact_id` FOREIGN KEY (`contact_id`) $upgrade = new CRM_Upgrade_Form(); //here we update price set entries $sqlFinancialIds = " -SELECT id, name +SELECT id, LCASE(name) name FROM civicrm_financial_type WHERE name IN ('Donation', 'Event Fee', 'Member Dues'); "; @@ -342,9 +342,9 @@ WHERE name IN ('Donation', 'Event Fee', 'Member Dues'); UPDATE civicrm_price_set ps SET ps.financial_type_id = CASE - WHEN ps.extends LIKE '%1%' THEN {$financialIds['Event Fee']} - WHEN ps.extends LIKE '2' THEN {$financialIds['Donation']} - WHEN ps.extends LIKE '3' THEN {$financialIds['Member Dues']} + WHEN ps.extends LIKE '%1%' THEN {$financialIds['event fee']} + WHEN ps.extends LIKE '2' THEN {$financialIds['donation']} + WHEN ps.extends LIKE '3' THEN {$financialIds['member dues']} END WHERE financial_type_id IS NULL "; -- 2.25.1