From 810e5923b06228309b87eba162e4b9c58eaf8ce9 Mon Sep 17 00:00:00 2001 From: Pradeep Nayak Date: Wed, 26 Feb 2020 01:24:06 +0000 Subject: [PATCH] Fixed DB Error: syntax error if line item refers to civicrm_case --- CRM/Price/BAO/LineItem.php | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) diff --git a/CRM/Price/BAO/LineItem.php b/CRM/Price/BAO/LineItem.php index c1f017f435..11043b9856 100644 --- a/CRM/Price/BAO/LineItem.php +++ b/CRM/Price/BAO/LineItem.php @@ -186,8 +186,8 @@ WHERE li.contribution_id = %1"; */ public static function getLineItems($entityId, $entity = 'participant', $isQuick = FALSE, $isQtyZero = TRUE, $relatedEntity = FALSE) { $whereClause = $fromClause = NULL; - $selectClause = " - SELECT li.id, + $selectClause = ' + SELECT li.id, li.label, li.contribution_id, li.qty, @@ -205,19 +205,19 @@ WHERE li.contribution_id = %1"; li.price_field_value_id, li.financial_type_id, li.tax_amount, - pfv.description"; + pfv.description'; - $condition = "li.entity_id = %2.id AND li.entity_table = 'civicrm_%2'"; + $condition = "li.entity_id = civicrm_%2.id AND li.entity_table = 'civicrm_%2'"; if ($relatedEntity) { - $condition = "li.contribution_id = %2.id "; + $condition = 'li.contribution_id = civicrm_%2.id '; } $fromClause = " - FROM civicrm_%2 as %2 + FROM civicrm_%2 LEFT JOIN civicrm_line_item li ON ({$condition}) - LEFT JOIN civicrm_price_field_value pfv ON ( pfv.id = li.price_field_value_id ) + LEFT JOIN civicrm_price_field_value pfv ON (pfv.id = li.price_field_value_id) LEFT JOIN civicrm_price_field pf ON (pf.id = li.price_field_id )"; - $whereClause = " WHERE %2.id = %1"; + $whereClause = " WHERE civicrm_%2.id = %1"; $orderByClause = " ORDER BY pf.weight, pfv.weight"; if ($isQuick) { -- 2.25.1