Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 3.2.2
-
Fix Version/s: 3.2.4
-
Component/s: CiviReport
-
Labels:None
Description
CiviReport has a hardcoded table prefix check in CRM/Report/Form.php which looks for 'civicrm_value' prefix on tables. In older versions of CiviCRM, these tables were created with a different prefix, 'custom_value'.
If a field in a table created using CiviCRM 1.x is used to restrict a report, then clicking 'Preview' will throw an SQL error as CiviCRM attempts to reference fields which are not included by CRM_Report_Form::customDataFrom(), because it does not recognise those fields as custom data fields.