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
-
Labels:
-
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.