From d6f78416b3d9dac1c99c5a8f03e52c206513611b Mon Sep 17 00:00:00 2001 From: Eileen McNaughton Date: Wed, 15 Mar 2023 18:58:00 +1300 Subject: [PATCH] Do not report missing triggers if the user cannot check them --- CRM/Utils/Check/Component/Schema.php | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/CRM/Utils/Check/Component/Schema.php b/CRM/Utils/Check/Component/Schema.php index 56f121c611..2911a9917d 100644 --- a/CRM/Utils/Check/Component/Schema.php +++ b/CRM/Utils/Check/Component/Schema.php @@ -264,6 +264,10 @@ class CRM_Utils_Check_Component_Schema extends CRM_Utils_Check_Component { * @return array|\CRM_Utils_Check_Message[] */ public function checkRelationshipCacheTriggers():array { + if (\Civi::settings()->get('logging_no_trigger_permission')) { + // The mysql user does not have permission to view whether the trigger exists. + return []; + } $dao = CRM_Core_DAO::executeQuery("SHOW TRIGGERS WHERE (`Table` = 'civicrm_relationship' OR `Table` = 'civicrm_relationship_type') AND `Statement` LIKE '%civicrm_relationship_cache%';"); if ($dao->N !== 3) { $msg = new CRM_Utils_Check_Message( -- 2.25.1