CiviCRM Community Forums (archive)

A site that has been working fine for several months suddenly complains whenever an attempt is made to save a contact:

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

    Database Error Code: Access denied; you need the SUPER privilege for this operation, 1227

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => UPDATE  civicrm_contact_en_US  SET contact_type = 'Individual' , do_not_email = 0 , do_not_phone = 0 , do_not_mail = 0 , do_not_sms = 0 , do_not_trade = 0 , is_opt_out = 0 , external_identifier = NULL , sort_name = 'Jansen, Alex' , display_name = 'Alex Jansen' , nick_name = NULL , home_URL = 'http://www.popsandbox.com' , preferred_communication_method = '' , preferred_mail_format = 'Both' , source = NULL , first_name = 'Alex' , middle_name = NULL , last_name = 'Jansen' , prefix_id = NULL , suffix_id = NULL , email_greeting_id = NULL , email_greeting_custom = NULL , postal_greeting_id = NULL , postal_greeting_custom = NULL , addressee_id = NULL , addressee_custom = NULL , job_title = 'President' , gender_id = NULL , birth_date = NULL , is_deceased = 0 , deceased_date = NULL , mail_to_household_id = NULL   WHERE (  civicrm_contact_en_US.id = 10413 )   [nativecode=1227 ** Access denied; you need the SUPER privilege for this operation]
    [type] => DB_Error
    [user_info] => UPDATE  civicrm_contact_en_US  SET contact_type = 'Individual' , do_not_email = 0 , do_not_phone = 0 , do_not_mail = 0 , do_not_sms = 0 , do_not_trade = 0 , is_opt_out = 0 , external_identifier = NULL , sort_name = 'Jansen, Alex' , display_name = 'Alex Jansen' , nick_name = NULL , home_URL = 'http://www.popsandbox.com' , preferred_communication_method = '' , preferred_mail_format = 'Both' , source = NULL , first_name = 'Alex' , middle_name = NULL , last_name = 'Jansen' , prefix_id = NULL , suffix_id = NULL , email_greeting_id = NULL , email_greeting_custom = NULL , postal_greeting_id = NULL , postal_greeting_custom = NULL , addressee_id = NULL , addressee_custom = NULL , job_title = 'President' , gender_id = NULL , birth_date = NULL , is_deceased = 0 , deceased_date = NULL , mail_to_household_id = NULL   WHERE (  civicrm_contact_en_US.id = 10413 )   [nativecode=1227 ** Access denied; you need the SUPER privilege for this operation]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_contact_en_US  SET contact_type = 'Individual' , do_not_email = 0 , do_not_phone = 0 , do_not_mail = 0 , do_not_sms = 0 , do_not_trade = 0 , is_opt_out = 0 , external_identifier = NULL , sort_name = 'Jansen, Alex' , display_name = 'Alex Jansen' , nick_name = NULL , home_URL = 'http://www.popsandbox.com' , preferred_communication_method = '' , preferred_mail_format = 'Both' , source = NULL , first_name = 'Alex' , middle_name = NULL , last_name = 'Jansen' , prefix_id = NULL , suffix_id = NULL , email_greeting_id = NULL , email_greeting_custom = NULL , postal_greeting_id = NULL , postal_greeting_custom = NULL , addressee_id = NULL , addressee_custom = NULL , job_title = 'President' , gender_id = NULL , birth_date = NULL , is_deceased = 0 , deceased_date = NULL , mail_to_household_id = NULL   WHERE (  civicrm_contact_en_US.id = 10413 )   [nativecode=1227 ** Access denied; you need the SUPER privilege for this operation]"]
)

I don't know of any changes that have been made to version of MySQL etc. or to db user. I've checked and the MySQL user has all privileges on the database. Any suggestions for tracking down what the issue might be?

Cheers,
Joe