Answers.Body: <p>The administrator disabled gssapi on the server, after that the update went smoothly, I have no idea why.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-01-14T15:19:25.100Z
Answers.LastActivityDate: 2021-01-14T15:19:25.100Z
Answers.UserDisplayName: gebseng
Answers.Body: <p>Mysql has a feature called binary logging. You have it turned on, so either:</p>
  <p>(a) turn it off, OR</p>
  <p>(b) the mysql user needs to have the SUPER privilege, OR</p>
  <p>(c) you need to set the mysql configuration variable log_bin_trust_function_creators.</p>
  <p>See <a href="https://docs.civicrm.org/installation/en/latest/general/requirements/#binary-logging" rel="nofollow noreferrer">https://docs.civicrm.org/installation/en/latest/general/requirements/#binary-logging</a></p>
  <p>You may need to ask your hosting provider what they will allow.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-01-12T11:28:09.137Z
Answers.Text: Thanks for the reply! The administrator set the log_bin_trust_function_creators variable and granted me SUPER privilege. He also says that binary logging was turned off already. When I go to the CiviCRM upgrade screen now, I still get exactly the same error message as before. Is there a different step I could try?
Answers.UserDisplayName: gebseng
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-11-17T19:03:36.423Z
Answers.Text: Just want to link it to this also: https://dba.stackexchange.com/questions/269083/cant-set-log-bin-trust-function-creators-1-on-machine-startup-mysql-8-0
Answers.UserDisplayName: salah-1
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-12-21T15:43:10.983Z
Answers.LastActivityDate: 2020-12-21T15:43:10.983Z
Answers.UserDisplayName: Demerit
Body: <p>I'm running CiviCRM in Wordpress 5.6</p>
  <p>I tried upgrading from CiviCRM 5.21 to 5.32 following this process: <a href="https://docs.civicrm.org/sysadmin/en/latest/upgrade/wordpress/" rel="nofollow noreferrer">https://docs.civicrm.org/sysadmin/en/latest/upgrade/wordpress/</a></p>
  <p>Now, the last step is visiting the update page, but there I get this error message:</p>
  <pre><code>Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
  DB Error: unknown error
   Fehlerbeschreibung
  Datenbank-Errorcode: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable), 1419
  Zusätzliche Details:
  Array
  (
      [callback] =&gt; Array
          (
              [0] =&gt; CRM_Core_Error
              [1] =&gt; handle
          )
  
      [code] =&gt; -1
      [message] =&gt; DB Error: unknown error
      [mode] =&gt; 16
      [debug_info] =&gt; CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EACH ROW BEGIN END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]
      [type] =&gt; DB_Error
      [user_info] =&gt; CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EACH ROW BEGIN END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]
      [to_string] =&gt; [db_error: message=&quot;DB Error: unknown error&quot; code=-1 mode=callback callback=CRM_Core_Error::handle prefix=&quot;&quot; info=&quot;CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EACH ROW BEGIN END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]&quot;]
  )
  </code></pre>
  <p>What could I do next? System Status says</p>
  <pre><code>Database Upgrade Required
  New codebase version detected. You must visit upgrade screen to upgrade the database.
  </code></pre>
  <p>thanks, geb</p>
  
Tags: <wordpress><database><upgrade>
Title: database error when finishing update to 5.32
ThreadText: # database error when finishing update to 5.32
  
  (Asked by: username_0 on 2020-12-21)
  
  I'm running CiviCRM in Wordpress 5.6
  I tried upgrading from CiviCRM 5.21 to 5.32 following this process: https://docs.civicrm.org/sysadmin/en/latest/upgrade/wordpress/
  Now, the last step is visiting the update page, but there I get this error message:
  Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
  DB Error: unknown error
   Fehlerbeschreibung
  Datenbank-Errorcode: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable), 1419
  Zusätzliche Details:
  Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => handle
          )
  
      [code] => -1
      [message] => DB Error: unknown error
      [mode] => 16
      [debug_info] => CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EACH ROW BEGIN END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]
      [type] => DB_Error
      [user_info] => CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EACH ROW BEGIN END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]
      [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EACH ROW BEGIN END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]"]
  )
  
  What could I do next? System Status says
  Database Upgrade Required
  New codebase version detected. You must visit upgrade screen to upgrade the database.
  
  thanks, geb
  
  **Tags:** wordpress, database, upgrade
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2021-01-14. Score: 2
  
  The administrator disabled gssapi on the server, after that the update went smoothly, I have no idea why.
  
  
  ---
  
  ### Answer by username_1 on 2020-12-21. Score: 2
  
  Mysql has a feature called binary logging. You have it turned on, so either:
  
  (a) turn it off, OR
  
  (b) the mysql user needs to have the SUPER privilege, OR
  
  (c) you need to set the mysql configuration variable log\_bin\_trust\_function\_creators.
  
  See <https://docs.civicrm.org/installation/en/latest/general/requirements/#binary-logging>
  
  You may need to ask your hosting provider what they will allow.
  
  > **Comments:**
  > **username_0**: Thanks for the reply! The administrator set the log_bin_trust_function_creators variable and granted me SUPER privilege. He also says that binary logging was turned off already. When I go to the CiviCRM upgrade screen now, I still get exactly the same error message as before. Is there a different step I could try?  
  > **username_2**: Just want to link it to this also: https://dba.stackexchange.com/questions/269083/cant-set-log-bin-trust-function-creators-1-on-machine-startup-mysql-8-0  
  
  ---
  
  