From f6bb0b409d6e03bb68ba7ef5a96f11df60f5af9b Mon Sep 17 00:00:00 2001 From: CiviCRM Date: Thu, 5 Jun 2014 16:40:40 +0530 Subject: [PATCH] 4.5 upgrade fix --- CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl index 3df4319e62..bf5d2dc4bb 100644 --- a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl @@ -551,9 +551,10 @@ AND pv.membership_type_id IS NOT NULL AND membership_id IS NOT NULL; -- update line items for contributions with contribution id -UPDATE civicrm_line_item +UPDATE civicrm_line_item cln +LEFT JOIN civicrm_contribution cc ON cc.id = cln.entity_id AND cln.contribution_id IS NULL and cln.entity_table = 'civicrm_contribution' SET contribution_id = entity_id -WHERE contribution_id IS NULL and entity_table = 'civicrm_contribution'; +WHERE cc.id IS NOT NULL; -- update case type menu UPDATE civicrm_navigation set url = 'civicrm/a/#/caseType' WHERE url LIKE 'civicrm/admin/options/case_type%'; -- 2.25.1