Activity list is not showing in contacts after upgrade to latest civicrm 5.9.1
I enable SQL debugging and its shows last query: SELECT COUNT(DISTINCT(tbl.activity_id)) as count FROM ( SELECT civicrm_activity.id as activity_id from civicrm_activity left join civicrm_option_value on civicrm_activity.activity_type_id = civicrm_option_value.value left join civicrm_option_group on civicrm_option_group.id = civicrm_option_value.option_group_id INNER JOIN civicrm_activity_contact ac ON ac.activity_id = civicrm_activity.id INNER JOIN civicrm_contact contact ON ac.contact_id = contact.id where ac.contact_id = 40023 AND civicrm_option_group.name = 'activity_type' AND civicrm_activity.is_deleted = 0 AND civicrm_activity.is_current_revision = 1 AND civicrm_activity.is_test= 0 AND ( civicrm_option_value.component_id IS NULL OR civicrm_option_value.component_id IN ( 1,2,4,5,6,8,9 ) ) ) as tbl LEFT JOIN civicrm_case_activity ON ( civicrm_case_activity.activity_id = tbl.activity_id ) WHERE civicrm_case_activity.id IS NULL;
Which means it return only count of activity not the list.