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:
- Load the report at http://dmaster.demo.civicrm.org/civicrm/report/instance/21?reset=1&output=criteria
- From the filters tab, select any option for frequency_unit i.e. "Frequency Unit is one of week, month"
- Update Report
- 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.