Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 3.4.8
-
Fix Version/s: 4.2.0
-
Component/s: CiviReport
-
Labels:None
Description
The Event Participant List report (and any reports created from the template) returns the db error [nativecode=1052 ** Column 'sort_name' in field list is ambiguous] when custom Contact Reference/Auto-Complete fields are used.
The solution is to change a line of code in:
/sites/all/modules/civicrm/CRM/Report/Form/Event/ParticipantListing.php
Modify line 65:
'dbAlias' => 'sort_name'),
changed to:
'dbAlias' => 'contact_civireport.sort_name'),