Answers.Body: <p>We find a 'drush cc all' or 'clear all caches' via the UI sorts these situations post-upgrade</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-04-16T20:35:40.153Z
Answers.Text: Fair point, but not everyone uses drush. Although I need to take serious look at it.. thanks for the hint, Pete
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-04-18T01:04:33.343Z
Answers.Text: can do via UI too
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-04-16T19:20:48.573Z
Answers.LastActivityDate: 2020-04-17T02:21:54.983Z
Answers.LastEditDate: 2020-04-17T02:21:54.983Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>The answer is to update the Drupal settings file with the tables listed in menu Administer/System Settings/CMS Database Integration.  There have been new &amp; removed tables. I then cleared the Views cache, and all was well.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-04-16T16:15:53.413Z
Answers.Text: You need to update cms integration in drupal settings.php when you add new custom group. I doubt if it was anything to do with upgrade unless the upgrade deleted custom group and re-created it than its a serious issue because it may be possible that you might have lost data for that custom group.
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-04-16T16:47:43.137Z
Answers.Text: The various views all looked OK after the settings files was updated so doesn't seem to be a loss of data.  I added the Views message to the question text, perhaps that helps? Whatever the fix, it's something to check, which I had missed.
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-04-16T15:09:28.357Z
Answers.LastActivityDate: 2020-04-16T15:09:28.357Z
Answers.UserDisplayName: Andy Clark
Body: <p>I upgraded a client to 5.24 and it broke Drupal Views - my various views all had broken items.  Views message was "This view has been automatically updated to fix missing relationships". However, while saving one view worked, another didn't. Not sure if the right place to alert people to this, but here goes.  Previously the client was on 5.19.4 so your situation may vary.  My answer is below</p>
  
Tags: <drupal-views>
Title: Drupal Views needs settings file update for 5.24
ThreadText: # Drupal Views needs settings file update for 5.24
  
  (Asked by: username_0 on 2020-04-16)
  
  I upgraded a client to 5.24 and it broke Drupal Views - my various views all had broken items. Views message was "This view has been automatically updated to fix missing relationships". However, while saving one view worked, another didn't. Not sure if the right place to alert people to this, but here goes. Previously the client was on 5.19.4 so your situation may vary. My answer is below
  
  **Tags:** drupal-views
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2020-04-16. Score: 1
  
  We find a 'drush cc all' or 'clear all caches' via the UI sorts these situations post-upgrade
  
  > **Comments:**
  > **username_0**: Fair point, but not everyone uses drush. Although I need to take serious look at it.. thanks for the hint, Pete  
  > **username_1**: can do via UI too  
  
  ---
  
  ### Answer by username_0 on 2020-04-16. Score: 1
  
  The answer is to update the Drupal settings file with the tables listed in menu Administer/System Settings/CMS Database Integration. There have been new & removed tables. I then cleared the Views cache, and all was well.
  
  > **Comments:**
  > **username_2**: You need to update cms integration in drupal settings.php when you add new custom group. I doubt if it was anything to do with upgrade unless the upgrade deleted custom group and re-created it than its a serious issue because it may be possible that you might have lost data for that custom group.  
  > **username_0**: The various views all looked OK after the settings files was updated so doesn't seem to be a loss of data.  I added the Views message to the question text, perhaps that helps? Whatever the fix, it's something to check, which I had missed.  
  
  ---
  
  