From f0a7bcb5fab3d4d0e2318ad61db1c871d7d4860a Mon Sep 17 00:00:00 2001
From: CiviCRM <info@civicrm.org>
Date: Thu, 3 Jul 2014 16:49:12 +0530
Subject: [PATCH] CRM-14629: fix query to enable cancel/update on recurring
 contribution if no associated contributions are present

---
 CRM/Contribute/BAO/ContributionRecur.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/CRM/Contribute/BAO/ContributionRecur.php b/CRM/Contribute/BAO/ContributionRecur.php
index 2f36c94cd9..98c636f465 100644
--- a/CRM/Contribute/BAO/ContributionRecur.php
+++ b/CRM/Contribute/BAO/ContributionRecur.php
@@ -396,13 +396,13 @@ SELECT rec.id                   as recur_id,
        rec.currency,
        con.id                   as contribution_id,
        con.contribution_page_id,
-       con.contact_id,
+       rec.contact_id,
        mp.membership_id";
 
     if ($entity == 'recur') {
       $sql .= "
       FROM civicrm_contribution_recur rec
-INNER JOIN civicrm_contribution       con ON ( con.contribution_recur_id = rec.id )
+LEFT JOIN civicrm_contribution       con ON ( con.contribution_recur_id = rec.id )
 LEFT  JOIN civicrm_membership_payment mp  ON ( mp.contribution_id = con.id )
      WHERE rec.id = %1
   GROUP BY rec.id";
-- 
2.25.1