Answers.Body: <p>I would suggest that you try clearing the cache first of all to see if that helps.  You can do this by deleting the files in the <code>templates_c</code> folder.  The location of this will depend on your CMS.  You can find more details in the <a href="https://docs.civicrm.org/sysadmin/en/latest/upgrade/" rel="nofollow noreferrer">documentation on upgrades</a>.</p>
  
  <p>If that doesn't help please edit you question to provide some more detail (including which CMS you are using).</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-18T07:56:32.960Z
Answers.Text: Hi, Thanks for your suggestion. I got the answer if my question, it was because of custom code was written to override the tpl files and which was confliction with latest CiviCRM.I removed that and rewrite customization needed with latest tpl file and it works.
Answers.UserDisplayName: Anju Dhiman
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-18T09:06:47.170Z
Answers.Text: Thanks for reporting back. I'm glad you managed to sort this out.
Answers.UserDisplayName: William Mortada
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-15T17:34:17.180Z
Answers.LastActivityDate: 2019-02-15T17:34:17.180Z
Answers.UserDisplayName: William Mortada
Body: <p>Activity list is not showing in contacts after upgrade to latest civicrm 5.9.1</p>
  
  <p>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;</p>
  
  <p>Which means it return only count of activity  not the list.</p>
  
Tags: <contacts><activities>
Title: Activity list is not showing in contacts after upgrade to latest civicrm 5.9.1
ThreadText: # Activity list is not showing in contacts after upgrade to latest civicrm 5.9.1
  
  (Asked by: username_0 on 2019-02-13)
  
  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.
  
  **Tags:** contacts, activities
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-02-15. Score: 1
  
  I would suggest that you try clearing the cache first of all to see if that helps. You can do this by deleting the files in the `templates_c` folder. The location of this will depend on your CMS. You can find more details in the [documentation on upgrades](https://docs.civicrm.org/sysadmin/en/latest/upgrade/).
  
  If that doesn't help please edit you question to provide some more detail (including which CMS you are using).
  
  > **Comments:**
  > **username_0**: Hi, Thanks for your suggestion. I got the answer if my question, it was because of custom code was written to override the tpl files and which was confliction with latest CiviCRM.I removed that and rewrite customization needed with latest tpl file and it works.  
  > **username_1**: Thanks for reporting back. I'm glad you managed to sort this out.  
  
  ---
  
  