From 9e1a3f4ff7eb8dc61b45a492a37c35b77ccb4137 Mon Sep 17 00:00:00 2001 From: Pradeep Nayak Date: Mon, 21 Oct 2013 19:44:52 +0530 Subject: [PATCH] -- CRM-13446, fixed upgrade if current version is less then 4.3 ---------------------------------------- * CRM-13446: Add ON DELETE Options for constraints fails http://issues.civicrm.org/jira/browse/CRM-13446 --- CRM/Upgrade/Incremental/php/FourThree.php | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) diff --git a/CRM/Upgrade/Incremental/php/FourThree.php b/CRM/Upgrade/Incremental/php/FourThree.php index f9a5eaa23c..695e9587a8 100644 --- a/CRM/Upgrade/Incremental/php/FourThree.php +++ b/CRM/Upgrade/Incremental/php/FourThree.php @@ -78,9 +78,16 @@ class CRM_Upgrade_Incremental_php_FourThree { $constraintArray = array( 'civicrm_contact' => 'contact_id', 'civicrm_campaign' => 'campaign_id', - 'civicrm_payment_processor' => 'payment_processor_id', - 'civicrm_financial_type' => 'financial_type_id' ); + + if (version_compare('4.1alpha1', $currentVer) <= 0) { + $constraintArray['civicrm_campaign'] = 'campaign_id'; + } + + if (version_compare('4.3alpha1', $currentVer) <= 0) { + $constraintArray['civicrm_financial_type'] = 'financial_type_id'; + } + foreach ($constraintArray as $key => $value) { $query = "SELECT contri_recur.id FROM civicrm_contribution_recur contri_recur LEFT JOIN {$key} ON contri_recur.{$value} = {$key}.id WHERE {$key}.id IS NULL"; -- 2.25.1