Answers.Body: <p>It runs <a href="https://github.com/civicrm/civicrm-core/blob/1015f65a6391f1e8c82b9c9b69407e9190a14c3f/CRM/Core/DAO.php#L2555-L2556" rel="nofollow noreferrer">these two queries</a> so you could try running the following using <code>cv</code> and see if it shows a useful error:</p>
  <p><code>cv ev -vvv '(new CRM_Core_DAO())-&gt;query(&quot;CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EACH ROW BEGIN END&quot;);'</code></p>
  <p><code>cv ev -vvv '(new CRM_Core_DAO())-&gt;query(&quot;DROP TRIGGER IF EXISTS civicrm_domain_trigger&quot;);'</code></p>
  <p>or alternatively add some debugging to see the details of the exception at <a href="https://github.com/civicrm/civicrm-core/blob/1015f65a6391f1e8c82b9c9b69407e9190a14c3f/CRM/Core/DAO.php#L2560" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/blob/1015f65a6391f1e8c82b9c9b69407e9190a14c3f/CRM/Core/DAO.php#L2560</a> and then try the upgrade again.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-09-17T02:23:20.683Z
Answers.Text: Thank you, I just also want to confirm that I do have the trigger privlege.
Answers.UserDisplayName: Elin
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-09-22T15:11:36.480Z
Answers.Text: Applying the patch then gave some additional information, which ultimately required adjustig the MySQL config. Then it all worked.
Answers.UserDisplayName: Elin
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-09-16T02:46:57.147Z
Answers.LastActivityDate: 2024-09-16T02:46:57.147Z
Answers.UserDisplayName: Demerit
Body: <p>I just attempted an update on my Joomla 4 site.
  When I attempted to run the database update I got this message:
  CiviCRM 5.77.0 requires MySQL trigger privileges.</p>
  <p>I was somewhere in the 5.7x range prior to the update, not completely up to date but not far behind either.</p>
  <p>I've had this site with joomla+Civi for years and never had a problem with updating.</p>
  <p>I'm on Mysqli 8.0.34-cll-lve  so I don't think that's the issue.</p>
  <p>What would cause this?</p>
  
Tags: <upgrade><joomla><database>
Title: MySQL trigger privileges
ThreadText: # MySQL trigger privileges
  
  (Asked by: username_0 on 2024-09-16)
  
  I just attempted an update on my Joomla 4 site.
  When I attempted to run the database update I got this message:
  CiviCRM 5.77.0 requires MySQL trigger privileges.
  
  I was somewhere in the 5.7x range prior to the update, not completely up to date but not far behind either.
  
  I've had this site with joomla+Civi for years and never had a problem with updating.
  
  I'm on Mysqli 8.0.34-cll-lve so I don't think that's the issue.
  
  What would cause this?
  
  **Tags:** upgrade, joomla, database
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2024-09-16. Score: 0 | Accepted answer
  
  It runs [these two queries](https://github.com/civicrm/civicrm-core/blob/1015f65a6391f1e8c82b9c9b69407e9190a14c3f/CRM/Core/DAO.php#L2555-L2556) so you could try running the following using `cv` and see if it shows a useful error:
  
  `cv ev -vvv '(new CRM_Core_DAO())->query("CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EACH ROW BEGIN END");'`
  
  `cv ev -vvv '(new CRM_Core_DAO())->query("DROP TRIGGER IF EXISTS civicrm_domain_trigger");'`
  
  or alternatively add some debugging to see the details of the exception at <https://github.com/civicrm/civicrm-core/blob/1015f65a6391f1e8c82b9c9b69407e9190a14c3f/CRM/Core/DAO.php#L2560> and then try the upgrade again.
  
  > **Comments:**
  > **username_0**: Thank you, I just also want to confirm that I do have the trigger privlege.  
  > **username_0**: Applying the patch then gave some additional information, which ultimately required adjustig the MySQL config. Then it all worked.  
  
  ---
  
  