From 75d6d47918b19f4885111de3fbc149d90bb691cf Mon Sep 17 00:00:00 2001 From: Pradeep Nayak Date: Sat, 8 Aug 2015 01:47:58 +0530 Subject: [PATCH] --CRM-16526, fixed sql syntax error on new contribution form --- CRM/Price/BAO/PriceSet.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/CRM/Price/BAO/PriceSet.php b/CRM/Price/BAO/PriceSet.php index 8db8da9983..607489c5d6 100644 --- a/CRM/Price/BAO/PriceSet.php +++ b/CRM/Price/BAO/PriceSet.php @@ -444,13 +444,13 @@ WHERE ct.id = cp.financial_type_id AND public static function getAssoc($withInactive = FALSE, $extendComponentName = FALSE, $column = 'title') { $query = " SELECT - DISTINCT ( price_set_id ) as id, {$column} + DISTINCT ( price_set_id ) as id, s.{$column} FROM civicrm_price_set s INNER JOIN civicrm_price_field f ON f.price_set_id = s.id INNER JOIN civicrm_price_field_value v ON v.price_field_id = f.id WHERE - civicrm_price_set.id = civicrm_price_field.price_set_id AND is_quick_config = 0 "; + is_quick_config = 0 "; if (!$withInactive) { $query .= ' AND s.is_active = 1 '; -- 2.25.1