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

Aggregate Contribution Custom Search throws MySQL errors if you use commas in the minimum or maximum

    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.

        Attachments

          Activity

            People

            • Assignee:
              kurund Kurund Jalmi
              Reporter:
              vrazer Lance Dockins
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: