Answers.Body: <p>The issue here was missing XML files. If you run an upgrade and accidentally override the CiviCase XML configuration files, then this will happen.</p>
  
  <p>The solution is to put back those files and CiviCRM may pick them up and import them into the database. If not, you may need to manually copy and paste the XML definitions into the <code>civicrm_case_type</code> table.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-11T15:46:35.997Z
Answers.Text: Note you can store the files in your custom templates folder (as defined at admin - system settings - directories) so they don't get overwritten on upgrades. i.e. custom_templates/CRM/Case/xml/configuration.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-11T13:42:41.087Z
Answers.LastActivityDate: 2019-12-11T13:42:41.087Z
Answers.UserDisplayName: Hershel
Body: <p>After Drupal 7.67 and CiviCRM 5.18.4 upgrades, when you click on add a case, the correct screen opens, you can enter data, then save, and the number of cases showing in the constituent summary is incremented, but no new cases show up in a list to be managed. This was previously, for several years on prior versions, working correctly, Also, even for existing cases, the activity dropdown list is not being populated, although they have worked in the past and the Activity Type Options are correctly setup. </p>
  
  <p>So now, in short, the number of cases in the Contact Summary is correct, such as 2 for a certain client, but when you click on the Cases tab, only 1 case appears. CiviCRM was no upgraded to 5.19.0 and the problem persists.</p>
  
  <p>Examining the Case data directly in the database shows no clear reason for this. Furthermore the options for activity_type for the CiviCase component are also in the database and match those of a fresh install.</p>
  
  <p>Has anyone run into this or can you suggest other things I can do to troubleshoot?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-11-12T17:09:18.627Z
Comments.Text: What was the previous version before upgrade?
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-11-13T00:37:46.553Z
Comments.Text: It was 4.6.x leapfrogging to 5.10, then to 5.18.4
Comments.UserDisplayName: Hugh Daniel
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-11-13T00:53:39.297Z
Comments.Text: Ok check the case type definition then. It's possible something didn't get upgraded in there and that might explain the missing activity dropdown choices. Also check in sites/default/files/civicrm/ConfigAndLog and there's a log file in there that might indicate some upgrade issues.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-11-13T13:48:53.307Z
Comments.Text: Thanks! I will check this out.
Comments.UserDisplayName: Hugh Daniel
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-12-09T21:17:45.613Z
Comments.Text: @hershel I see your edit - were you able to check the CASE TYPE definition (not the activity type option_values), i.e. `select * from civicrm_case_type`. And is it using external xml files or is the definition column in that table populated?
Comments.UserDisplayName: Demerit
Tags: <civicase>
Title: After 5.18.4 Upgrade, Cases are Missing from the List
ThreadText: # After 5.18.4 Upgrade, Cases are Missing from the List
  
  (Asked by: username_0 on 2019-11-12)
  
  After Drupal 7.67 and CiviCRM 5.18.4 upgrades, when you click on add a case, the correct screen opens, you can enter data, then save, and the number of cases showing in the constituent summary is incremented, but no new cases show up in a list to be managed. This was previously, for several years on prior versions, working correctly, Also, even for existing cases, the activity dropdown list is not being populated, although they have worked in the past and the Activity Type Options are correctly setup.
  
  So now, in short, the number of cases in the Contact Summary is correct, such as 2 for a certain client, but when you click on the Cases tab, only 1 case appears. CiviCRM was no upgraded to 5.19.0 and the problem persists.
  
  Examining the Case data directly in the database shows no clear reason for this. Furthermore the options for activity\_type for the CiviCase component are also in the database and match those of a fresh install.
  
  Has anyone run into this or can you suggest other things I can do to troubleshoot?
  
  **Tags:** civicase
  
  > **Comments:**
  > **username_1**: What was the previous version before upgrade?  
  > **username_0**: It was 4.6.x leapfrogging to 5.10, then to 5.18.4  
  > **username_1**: Ok check the case type definition then. It's possible something didn't get upgraded in there and that might explain the missing activity dropdown choices. Also check in sites/default/files/civicrm/ConfigAndLog and there's a log file in there that might indicate some upgrade issues.  
  > **username_0**: Thanks! I will check this out.  
  > **username_1**: @hershel I see your edit - were you able to check the CASE TYPE definition (not the activity type option_values), i.e. `select * from civicrm_case_type`. And is it using external xml files or is the definition column in that table populated?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2019-12-11. Score: 1
  
  The issue here was missing XML files. If you run an upgrade and accidentally override the CiviCase XML configuration files, then this will happen.
  
  The solution is to put back those files and CiviCRM may pick them up and import them into the database. If not, you may need to manually copy and paste the XML definitions into the `civicrm_case_type` table.
  
  > **Comments:**
  > **username_1**: Note you can store the files in your custom templates folder (as defined at admin - system settings - directories) so they don't get overwritten on upgrades. i.e. custom_templates/CRM/Case/xml/configuration.  
  
  ---
  
  