From fdaee6293ab83fff8e30853499e487f03c12751c Mon Sep 17 00:00:00 2001
From: Pradeep Nayak <pradeep@pradeep.(none)>
Date: Sun, 5 May 2013 03:08:21 +0530
Subject: [PATCH] --fixed for CRM-12511

----------------------------------------
* CRM-12511: Upgrade error where DB has some membership types with minimum_fee IS NULL
  http://issues.civicrm.org/jira/browse/CRM-12511
---
 CRM/Upgrade/Incremental/sql/4.3.beta4.mysql.tpl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/CRM/Upgrade/Incremental/sql/4.3.beta4.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.3.beta4.mysql.tpl
index aecd253271..7f3b28a34d 100644
--- a/CRM/Upgrade/Incremental/sql/4.3.beta4.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.3.beta4.mysql.tpl
@@ -21,5 +21,5 @@ cpfv.financial_type_id = cmt.financial_type_id,
     cpfv.description_{$locale} = cmt.description_{$locale},
   {/foreach}
 {/if}
-cpfv.amount = cmt.minimum_fee	
+cpfv.amount = IFNULL(cmt.minimum_fee, 0.00)	
 WHERE cps.is_quick_config = 1 AND cpfv.membership_type_id IS NOT NULL;
\ No newline at end of file
-- 
2.25.1