Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-20025

DB Error on email task for advanced search for contributions

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.7.16
    • Fix Version/s: 4.7.18
    • Component/s: None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      User and Admin Doc
    • Funding Source:
      Contributed Code
    • Verified?:
      No

      Description

      Remove extraneous final comma in the IN clause list when trying to email all contributions from advanced Search:
      SELECT contact_id
      FROM civicrm_contribution
      WHERE id IN ( 45,46,32,47,35,48,41,49,27,34,50,51,43,23,52,53,54,55,20,42,33,56,22,57,58,59,15,60,24,61,62,63,14,17,64,65,66,67,68,69,70,71,72,73,74,75,38,76,19,77,30,78,31,29,79,80,39,25,81,82,36,83,18,84,85,86,16,87,40,26,88,37,89,90,91,21,28,92,93,94,3,9,5,1,4,6,7,2,8,13,12,11,10, )

      Steps to replicate -

      1. Click on Contacts > Advanced Search
      2. Perform a search while viewing the results as Contributions
      3. Select ALL the records displayed and attempt to send an Email via the actions dropdown.

      Error as below:
      http://pastebin.com/WN1gwS0Z

      I could replicate this on my local and on dmaster. Above pastebin result is from dmaster demo.

        Attachments

          Activity

            People

            • Assignee:
              edsel Edsel Lopez
              Reporter:
              edsel Edsel Lopez
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: