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

Filtering on frequency_unit Breaks Recur report

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.6, 4.7
    • Fix Version/s: 4.7.9
    • Component/s: CiviReport
    • Labels:
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code

      Description

      On the Recurring Contributions report, selecting Frequency Unit as a filter throws a fatal error of "DB Error: Unknown Field". To reproduce on the demo instance:

      1. Load the report at http://dmaster.demo.civicrm.org/civicrm/report/instance/21?reset=1&output=criteria
      2. From the filters tab, select any option for frequency_unit i.e. "Frequency Unit is one of week, month"
      3. Update Report
      4. Export to CSV

      The error thrown indicates that month and week are unknown columns. Probably caused by Recur.php using INT for frequency_units when the option was changed to a string in 4.5.

        Attachments

          Activity

            People

            • Assignee:
              tobiaslounsbury Tobias Lounsbury
              Reporter:
              maxhunter Max Hunter
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: