From 5e8d4170b5a57197bae42fe15152c11c7c148b0b Mon Sep 17 00:00:00 2001 From: Edsel Date: Thu, 21 May 2015 19:01:43 +0530 Subject: [PATCH] ICM-1 Drop table before creating if exists to avoid cruft --- CRM/Report/Form.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Report/Form.php b/CRM/Report/Form.php index e52f91beed..926a9f18d6 100644 --- a/CRM/Report/Form.php +++ b/CRM/Report/Form.php @@ -4496,6 +4496,7 @@ LEFT JOIN civicrm_contact {$field['alias']} ON {$field['alias']}.id = {$this->_a public function getPermissionedFTQuery(&$query) { CRM_Financial_BAO_FinancialType::getAvailableFinancialTypes($financialTypes); + CRM_Core_DAO::executeQuery("DROP TEMPORARY TABLE IF EXISTS civicrm_contribution_temp"); $sql = "CREATE TEMPORARY TABLE civicrm_contribution_temp AS SELECT {$query->_aliases['civicrm_contribution']}.id {$query->_from} INNER JOIN civicrm_line_item {$query->_aliases['civicrm_line_item']} @@ -4505,7 +4506,6 @@ LEFT JOIN civicrm_contact {$field['alias']} ON {$field['alias']}.id = {$this->_a AND {$query->_aliases['civicrm_contribution']}.financial_type_id IN (" . implode(',' , array_keys($financialTypes)) . ") AND {$query->_aliases['civicrm_line_item']}.financial_type_id IN (" . implode(',' , array_keys($financialTypes)) . ") GROUP BY {$query->_aliases['civicrm_contribution']}.id"; - CRM_Core_DAO::executeQuery($sql); $query->_from .= " INNER JOIN civicrm_contribution_temp temp ON {$query->_aliases['civicrm_contribution']}.id = temp.id "; } -- 2.25.1