Answers.Body: <p>Did you move the database with <code>mysqldump</code> and <code>mysql</code>? Then trigger can fail because he has rights in the old database, and not in the new. The solution is to recreate all triggers. This can be done with the following command.</p>
  <pre><code>wp eval &quot;Civi::service('sql_triggers')-&gt;rebuild(NULL, FALSE);&quot; 
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-24T16:26:51.023Z
Answers.Text: Don't understand, but I managed to add SSH access and run this and it solved the problem. Thanks
Answers.UserDisplayName: Mick Kahn
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-24T11:30:41.417Z
Answers.LastActivityDate: 2021-02-24T11:30:41.417Z
Answers.UserDisplayName: Kainuk - CiviCooP
Body: <p>I am trying to delete a contribution and after I confirm that I want to it just hangs with the pop up and a spinning CiviCRM logo indefinitely. I get the following in the error log.</p>
  <p>Feb 24 10:07:53  [error] $Fatal Error Details = Array
  (
  [callback] =&gt; Array
  (
  [0] =&gt; CRM_Core_Error
  [1] =&gt; handle
  )</p>
  <pre><code>[code] =&gt; -26
  [message] =&gt; DB Error: insufficient permissions
  [mode] =&gt; 16
  [debug_info] =&gt; DELETE FROM civicrm_activity WHERE source_record_id IN ( 3710 ) AND activity_type_id IN ( 6 ) [nativecode=1142 ** TRIGGER command denied to user 'coma6771_crmwp'@'localhost' for table 'civicrm_activity']
  [type] =&gt; DB_Error
  [user_info] =&gt; DELETE FROM civicrm_activity WHERE source_record_id IN ( 3710 ) AND activity_type_id IN ( 6 ) [nativecode=1142 ** TRIGGER command denied to user 'coma6771_crmwp'@'localhost' for table 'civicrm_activity']
  [to_string] =&gt; [db_error: message=&quot;DB Error: insufficient permissions&quot; code=-26 mode=callback callback=CRM_Core_Error::handle prefix=&quot;&quot; info=&quot;DELETE FROM civicrm_activity WHERE source_record_id IN ( 3710 ) AND activity_type_id IN ( 6 ) [nativecode=1142 ** TRIGGER command denied to user 'coma6771_crmwp'@'localhost' for table 'civicrm_activity']&quot;]
  </code></pre>
  <p>)</p>
  <p>The user has full access for the database, but I can't see anything about table specific access.I know it was working quite recently and don't think I have changed anything relevant.</p>
  <p>I'm on WordPress and CiviCRM 5.26.2</p>
  
Tags: <civicontribute>
Title: Cannot delete contributions
ThreadText: # Cannot delete contributions
  
  (Asked by: username_0 on 2021-02-24)
  
  I am trying to delete a contribution and after I confirm that I want to it just hangs with the pop up and a spinning CiviCRM logo indefinitely. I get the following in the error log.
  
  Feb 24 10:07:53 [error] $Fatal Error Details = Array
  (
  [callback] => Array
  (
  [0] => CRM\_Core\_Error
  [1] => handle
  )
  
  ```
  [code] => -26
  [message] => DB Error: insufficient permissions
  [mode] => 16
  [debug_info] => DELETE FROM civicrm_activity WHERE source_record_id IN ( 3710 ) AND activity_type_id IN ( 6 ) [nativecode=1142 ** TRIGGER command denied to user 'coma6771_crmwp'@'localhost' for table 'civicrm_activity']
  [type] => DB_Error
  [user_info] => DELETE FROM civicrm_activity WHERE source_record_id IN ( 3710 ) AND activity_type_id IN ( 6 ) [nativecode=1142 ** TRIGGER command denied to user 'coma6771_crmwp'@'localhost' for table 'civicrm_activity']
  [to_string] => [db_error: message="DB Error: insufficient permissions" code=-26 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM civicrm_activity WHERE source_record_id IN ( 3710 ) AND activity_type_id IN ( 6 ) [nativecode=1142 ** TRIGGER command denied to user 'coma6771_crmwp'@'localhost' for table 'civicrm_activity']"]
  
  ```
  
  )
  
  The user has full access for the database, but I can't see anything about table specific access.I know it was working quite recently and don't think I have changed anything relevant.
  
  I'm on WordPress and CiviCRM 5.26.2
  
  **Tags:** civicontribute
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-02-24. Score: 3 | Accepted answer
  
  Did you move the database with `mysqldump` and `mysql`? Then trigger can fail because he has rights in the old database, and not in the new. The solution is to recreate all triggers. This can be done with the following command.
  
  ```
  wp eval "Civi::service('sql_triggers')->rebuild(NULL, FALSE);" 
  
  ```
  
  > **Comments:**
  > **username_0**: Don't understand, but I managed to add SSH access and run this and it solved the problem. Thanks  
  
  ---
  
  