From 36e8f052797605a5f4c7a91693da759fb6b1cfad Mon Sep 17 00:00:00 2001 From: monishdeb Date: Wed, 11 Feb 2015 11:34:24 +0530 Subject: [PATCH] CRM-15946 fix - Upgrade to 4.6 alpha fails on 'Add and update reference_date column for Schedule Reminders' https://issues.civicrm.org/jira/browse/CRM-15946 --- CRM/Upgrade/Incremental/php/FourSix.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/php/FourSix.php b/CRM/Upgrade/Incremental/php/FourSix.php index 09cbeeccf9..e318661e4c 100644 --- a/CRM/Upgrade/Incremental/php/FourSix.php +++ b/CRM/Upgrade/Incremental/php/FourSix.php @@ -143,7 +143,7 @@ class CRM_Upgrade_Incremental_php_FourSix { //Retrieve schedule reminders for membership entity and is not repeatable and no absolute date chosen. $query = "SELECT schedule.* FROM civicrm_action_schedule schedule - LEFT JOIN civicrm_action_mapping mapper ON mapper.id = schedule.mapping_id AND + INNER JOIN civicrm_action_mapping mapper ON mapper.id = schedule.mapping_id AND mapper.entity = 'civicrm_membership' AND schedule.is_repeat = 0 AND schedule.start_action_date IS NOT NULL"; -- 2.25.1