Rebuild Triggers (and views) should also rebuild CiviCase views (#2262) · Issues · Development / Core

Rebuild Triggers (and views) should also rebuild CiviCase views

Overview

When moving CiviCRM's database to a new server and/or setting up a new database user, the views which are a part of CiviCase are not rebuilt with the new credentials after running the command civicrm-sql-rebuild-triggers :

VIEWS
civicrm_view_case_activity_upcoming
civicrm_view_case_activity_recent

Reproduction steps

Change the database user name and credentials
rebuild triggers
DB Error when accessing CiviCase components

Environment information

CiviCRM: 5.32.2
PHP: 7.3
CMS: Drupal 7.x
Database: MariaDB

Comments

Also relates to #1214

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information