From 909a777b397db3266f03f378b17483a7b7705abf Mon Sep 17 00:00:00 2001 From: "Donald A. Lobo" Date: Mon, 15 Apr 2013 16:16:04 -0700 Subject: [PATCH] CRM-12355 ---------------------------------------- * CRM-12355: Upgrade fails with "CREATE TEMPORARY TABLE ... A table must have at least 1 column]" http://issues.civicrm.org/jira/browse/CRM-12355 --- CRM/Upgrade/Incremental/php/FourThree.php | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/CRM/Upgrade/Incremental/php/FourThree.php b/CRM/Upgrade/Incremental/php/FourThree.php index e241c7e5f5..4f2fa2a6f3 100644 --- a/CRM/Upgrade/Incremental/php/FourThree.php +++ b/CRM/Upgrade/Incremental/php/FourThree.php @@ -382,14 +382,13 @@ AND ceft.entity_table = 'civicrm_contribution' ); $accountType = key(CRM_Core_PseudoConstant::accountOptionValues('financial_account_type', NULL, " AND v.name = 'Asset' ")); - $financialAccountId = - $query = " + $query = " SELECT id FROM civicrm_financial_account WHERE is_default = 1 AND financial_account_type_id = {$accountType} "; - CRM_Core_DAO::singleValueQuery($query); + $financialAccountId = CRM_Core_DAO::singleValueQuery($query); $accountRelationsips = CRM_Core_PseudoConstant::accountOptionValues('account_relationship', NULL); -- 2.25.1