Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 2.1
-
Fix Version/s: 2.2.0
-
Component/s: CiviCRM Search
-
Labels:None
Description
If you use a comma to help designate 1000's places in the Aggregate Contribution custom search, CiviCRM 2.1.0 and up (possibly in 2.0 as well) you get a MySQL error because CiviCRM doesn't first filter the field for acceptable characters. This search needs to filter out unacceptable characters (commas, dollar signs, dashes) before dumping them into a SQL statement.