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

2 Answers 2


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.

  • 1
    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. Apr 16, 2020 at 16:15
  • 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.
    – Andy Clark
    Apr 16, 2020 at 16:47

We find a 'drush cc all' or 'clear all caches' via the UI sorts these situations post-upgrade

  • Fair point, but not everyone uses drush. Although I need to take serious look at it.. thanks for the hint, Pete
    – Andy Clark
    Apr 16, 2020 at 20:35
  • can do via UI too
    – petednz - fuzion
    Apr 18, 2020 at 1:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.