Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
C
Core
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 978
    • Issues 978
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Operations
    • Operations
    • Incidents
  • Analytics
    • Analytics
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • Development
  • Core
  • Issues
  • #2262

Closed
Open
Opened Dec 19, 2020 by bnagorcka@bnagorcka

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

  1. Change the database user name and credentials
  2. rebuild triggers
  3. 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
Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
Reference: dev/core#2262