Search displaying Related Contacts produces fatal error
As @DaveD mentioned here #380 (comment 17294)
In 5.13.4 when an advanced search is set to display Related Contacts it produces a fatal error. I have tested on two sites and Dave got the same error on dmaster.demo.
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
FROM civicrm_contact contact_a LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id LEFT JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id
WHERE displayRelType.relationship_type_id = 1
AND displayRelType.is_active = 1
AND (contact_a.is_deleted = 0)
GROUP BY sort_name
ORDER BY sort_name asc [nativecode=1054 ** Unknown column 'displayRelType.relationship_type_id' in 'where clause']
[type] => DB_Error
[user_info] => SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
FROM civicrm_contact contact_a LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id LEFT JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id
WHERE displayRelType.relationship_type_id = 1
AND displayRelType.is_active = 1
AND (contact_a.is_deleted = 0)
GROUP BY sort_name
ORDER BY sort_name asc [nativecode=1054 ** Unknown column 'displayRelType.relationship_type_id' in 'where clause']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
FROM civicrm_contact contact_a LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id LEFT JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id
WHERE displayRelType.relationship_type_id = 1
AND displayRelType.is_active = 1
AND (contact_a.is_deleted = 0)
GROUP BY sort_name
ORDER BY sort_name asc [nativecode=1054 ** Unknown column 'displayRelType.relationship_type_id' in 'where clause']"]
)