Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Duplicate
-
Affects Version/s: 4.7.1, 4.7.2
-
Fix Version/s: None
-
Component/s: CiviReport
-
Labels:None
-
Documentation Required?:None
-
Funding Source:Needs Funding
Description
Using either 4.7.1 or 4.7.2 I get a fatal error when I use reports that ran great on 4.6.9.
It seems some custom field groups do not get included in the LEFT JOIN resulting in a fatal error: Unknown column 'value_cv_118_civireport.welke_jaren_mee_als_deelnemer__376' in 'field list']
I am going to help diagnose further and hope someone jumps on this wagon to be able to fix this nasty one.
[Edited: On further analysis I found out that a required LEFT JOIN for the custom field that is selected omitted from the report query. See attached screenshot.]
Possibly related issues:
https://issues.civicrm.org/jira/browse/CRM-18010
https://issues.civicrm.org/jira/browse/CRM-18048
https://issues.civicrm.org/jira/browse/CRM-18051
