Answers.Body: <p>OK - This is really heinous!!!
  I've been trying all day - posted the query and after doing that read following set of instructions on how to do <strong>Alternate Moving the database using phpMyAdmin</strong> -&gt; <a href="https://wiki.civicrm.org/confluence/display/CRMDOC/Alternate+Moving+the+database+using+phpMyAdmin" rel="nofollow noreferrer">see the link</a> and look at the heading <strong>Post Import Activities</strong>.
  It reads</p>
  <blockquote>
  <p>Very Important: If you have custom data profiles set up in your civiCRM, they may be present but for some unknown reason not be active. Go to your Administer &gt;&gt; Customize &gt;&gt; Custom Data and select &quot;View and Edit Custom Fields&quot;. Select &quot;Edit Field&quot; for any one of the custom fields in the group and save it without making any changes. This will make civiCRM aware of the custom data fields and everything should be back on track.</p>
  </blockquote>
  <p>I've got two set of custom fields, did what I'd been tolded = didn't work; did it again with the second set = <strong>and voila</strong>, everything works again.</p>
  <p>There's two things on my mind:</p>
  <p>1.) Can any of the more tenured members comment on what the problem is - it must be a bug, it can't be by design!?</p>
  <p>2.) Who the heck is user:backup_Mk047aB???</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-24T18:11:56.720Z
Answers.Text: You elaborate here on your question. So it is better to add this insight to your question instead of creating an answer.
Answers.UserDisplayName: Kainuk - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-07T19:00:51.193Z
Answers.LastActivityDate: 2016-10-07T19:00:51.193Z
Answers.LastEditDate: 2020-06-17T09:00:50.810Z
Answers.UserDisplayName: Abteilung Gerontopsychiatrie
Answers.Body: <p>Let me do a guess (the problem is already solved, so probably we will never find out what happened).</p>
  
  <p>The problem is caused not by a CiviCRM bug but by a MySQL peculiarity. In MySQL it is possible to define a trigger on a table. That is a piece of code that executes when a row is added or updated.  Custom tables have triggers (they update the timestamp of the related table).
  If you want to make a backup and export the table, the trigger is also exported. And MySQL also exports in the trigger code the name of the user that makes the export. 
  Your first question was who is <em>backup_Mk047aB</em>? Most likely the database user used for the backup.</p>
  
  <p>In editing the definition of the custom field you force CiviCRM to recreate the trigger code. But now it is recreated with the correct user, so the error disappears.</p>
  
  <p>This is, however, a complicated workaround. It is more convenient to force a rebuild by calling the url:</p>
  
  <p><code>http://example.org.org/wp-admin/admin.php?page=CiviCRM&amp;q=civicrm/menu/rebuild&amp;reset=1&amp;triggerRebuild=1</code></p>
  
  <p>See <a href="https://docs.civicrm.org/sysadmin/en/latest/troubleshooting/#trigger-rebuild" rel="nofollow noreferrer">https://docs.civicrm.org/sysadmin/en/latest/troubleshooting/#trigger-rebuild</a>.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-24T20:01:03.353Z
Answers.Text: This is almost certainly correct.  This is a variation of the same problem discussed here: https://civicrm.stackexchange.com/questions/619/why-do-i-get-access-denied-you-need-at-least-one-of-the-super-privileges-f/2561#2561.  I would expect to see this behavior after the database was moved to a new server with a new MySQL username.
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-24T18:09:46.200Z
Answers.LastActivityDate: 2018-08-24T20:36:47.367Z
Answers.LastEditDate: 2018-08-24T20:36:47.367Z
Answers.UserDisplayName: Kainuk - CiviCooP
Body: <p>While the back-end is working - e.g. I can add fields to profiles, etc. -, I see form data perfectly fine when calling pages, I cannot modify or add contacts resulting in </p>
  
  <pre><code>Sorry but we are not able to provide this at the moment. DB Error: unknown error
  </code></pre>
  
  <p>The log shows the following:</p>
  
  <pre><code>#6 /*/wordpress/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(895): DB_common-&gt;raiseError(-1, NULL, NULL, NULL, "1449 ** The user specified as a definer ('backup_Mk047aB'@'%') does not exist")
  </code></pre>
  
  <p>Searching the CiviCRM database - I cannot find a reference to a user called "backup_Mk047aB" (not anywhere in Wordpress databases either).</p>
  
  <p>A previous post notes that </p>
  
  <blockquote>
    <p>You will get more details in civicrm log file (*/file/civicrm/ConfigAndLog). Also the main reason of this type error is, we are using few fields that are disabled. check custom fields status that are using for contact. <a href="https://civicrm.stackexchange.com/questions/7947/error-sorry-but-we-are-not-able-to-provide-this-at-the-moment">see here</a></p>
  </blockquote>
  
  <p>I then tried using my webpage form and populated all available fields of all profiles and then get</p>
  
  <pre><code>Database Error Code: The user specified as a definer ('backup_Mk047aB'@'%') does not exist, 1449
  
  Additional 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; INSERT INTO civicrm_value_eda_individual_characteristic_2  ( name_of_affiliation_10,address_line_1_11,address_line_2_12,entity_id ) VALUES ( '','Henriette','',2 ) ON DUPLICATE KEY UPDATE name_of_affiliation_10 = '',address_line_1_11 = 'Henriette',address_line_2_12 = '' [nativecode=1449 ** The user specified as a definer ('backup_Mk047aB'@'%') does not exist]
  [type] =&gt; DB_Error
  [user_info] =&gt; INSERT INTO civicrm_value_eda_individual_characteristic_2  ( name_of_affiliation_10,address_line_1_11,address_line_2_12,entity_id ) VALUES ( '','Henriette','',2 ) ON DUPLICATE KEY UPDATE name_of_affiliation_10 = '',address_line_1_11 = 'Henriette',address_line_2_12 = '' [nativecode=1449 ** The user specified as a definer ('backup_Mk047aB'@'%') does not exist]
  [to_string] =&gt; [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_value_eda_individual_characteristic_2  ( name_of_affiliation_10,address_line_1_11,address_line_2_12,entity_id ) VALUES ( '','Henriette','',2 ) ON DUPLICATE KEY UPDATE name_of_affiliation_10 = '',address_line_1_11 = 'Henriette',address_line_2_12 = '' [nativecode=1449 ** The user specified as a definer ('backup_Mk047aB'@'%') does not exist]"]
  )
  </code></pre>
  
  <p>Although I've been back-upping my site - this error just came along...</p>
  
  <p><strong>I'm lost und would love to meet user:backup_Mk047aB - any ideas!?</strong></p>
  
Tags: <wordpress><custom-fields><database><error>
Title: Who is 'backup_Mk047aB'@'%' from the error 'The user specified as a definer ('backup_Mk047aB'@'%') does not exist'
ThreadText: # Who is 'backup_Mk047aB'@'%' from the error 'The user specified as a definer ('backup_Mk047aB'@'%') does not exist'
  
  (Asked by: username_0 on 2016-10-07)
  
  While the back-end is working - e.g. I can add fields to profiles, etc. -, I see form data perfectly fine when calling pages, I cannot modify or add contacts resulting in 
  Sorry but we are not able to provide this at the moment. DB Error: unknown error
  
  The log shows the following:
  #6 /*/wordpress/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(895): DB_common->raiseError(-1, NULL, NULL, NULL, "1449 ** The user specified as a definer ('backup_Mk047aB'@'%') does not exist")
  
  Searching the CiviCRM database - I cannot find a reference to a user called "backup_Mk047aB" (not anywhere in Wordpress databases either).
  A previous post notes that 
  
  You will get more details in civicrm log file (*/file/civicrm/ConfigAndLog). Also the main reason of this type error is, we are using few fields that are disabled. check custom fields status that are using for contact. see here
  
  I then tried using my webpage form and populated all available fields of all profiles and then get
  Database Error Code: The user specified as a definer ('backup_Mk047aB'@'%') does not exist, 1449
  
  Additional details:
  
  Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => handle
          )
  [code] => -1
  [message] => DB Error: unknown error
  [mode] => 16
  [debug_info] => INSERT INTO civicrm_value_eda_individual_characteristic_2  ( name_of_affiliation_10,address_line_1_11,address_line_2_12,entity_id ) VALUES ( '','Henriette','',2 ) ON DUPLICATE KEY UPDATE name_of_affiliation_10 = '',address_line_1_11 = 'Henriette',address_line_2_12 = '' [nativecode=1449 ** The user specified as a definer ('backup_Mk047aB'@'%') does not exist]
  [type] => DB_Error
  [user_info] => INSERT INTO civicrm_value_eda_individual_characteristic_2  ( name_of_affiliation_10,address_line_1_11,address_line_2_12,entity_id ) VALUES ( '','Henriette','',2 ) ON DUPLICATE KEY UPDATE name_of_affiliation_10 = '',address_line_1_11 = 'Henriette',address_line_2_12 = '' [nativecode=1449 ** The user specified as a definer ('backup_Mk047aB'@'%') does not exist]
  [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_value_eda_individual_characteristic_2  ( name_of_affiliation_10,address_line_1_11,address_line_2_12,entity_id ) VALUES ( '','Henriette','',2 ) ON DUPLICATE KEY UPDATE name_of_affiliation_10 = '',address_line_1_11 = 'Henriette',address_line_2_12 = '' [nativecode=1449 ** The user specified as a definer ('backup_Mk047aB'@'%') does not exist]"]
  )
  
  Although I've been back-upping my site - this error just came along...
  I'm lost und would love to meet user:backup_Mk047aB - any ideas!?
  
  **Tags:** wordpress, custom-fields, database, error
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2016-10-07. Score: 1
  
  OK - This is really heinous!!!
  I've been trying all day - posted the query and after doing that read following set of instructions on how to do **Alternate Moving the database using phpMyAdmin** -> [see the link](https://wiki.civicrm.org/confluence/display/CRMDOC/Alternate+Moving+the+database+using+phpMyAdmin) and look at the heading **Post Import Activities**.
  It reads
  
  > Very Important: If you have custom data profiles set up in your civiCRM, they may be present but for some unknown reason not be active. Go to your Administer >> Customize >> Custom Data and select "View and Edit Custom Fields". Select "Edit Field" for any one of the custom fields in the group and save it without making any changes. This will make civiCRM aware of the custom data fields and everything should be back on track.
  
  I've got two set of custom fields, did what I'd been tolded = didn't work; did it again with the second set = **and voila**, everything works again.
  
  There's two things on my mind:
  
  1.) Can any of the more tenured members comment on what the problem is - it must be a bug, it can't be by design!?
  
  2.) Who the heck is user:backup\_Mk047aB???
  
  > **Comments:**
  > **username_1**: You elaborate here on your question. So it is better to add this insight to your question instead of creating an answer.  
  
  ---
  
  ### Answer by username_1 on 2018-08-24. Score: 1
  
  Let me do a guess (the problem is already solved, so probably we will never find out what happened).
  
  The problem is caused not by a CiviCRM bug but by a MySQL peculiarity. In MySQL it is possible to define a trigger on a table. That is a piece of code that executes when a row is added or updated. Custom tables have triggers (they update the timestamp of the related table).
  If you want to make a backup and export the table, the trigger is also exported. And MySQL also exports in the trigger code the name of the user that makes the export.
  Your first question was who is *backup\_Mk047aB*? Most likely the database user used for the backup.
  
  In editing the definition of the custom field you force CiviCRM to recreate the trigger code. But now it is recreated with the correct user, so the error disappears.
  
  This is, however, a complicated workaround. It is more convenient to force a rebuild by calling the url:
  
  `http://example.org.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/menu/rebuild&reset=1&triggerRebuild=1`
  
  See <https://docs.civicrm.org/sysadmin/en/latest/troubleshooting/#trigger-rebuild>.
  
  > **Comments:**
  > **username_2**: This is almost certainly correct.  This is a variation of the same problem discussed here: https://civicrm.stackexchange.com/questions/619/why-do-i-get-access-denied-you-need-at-least-one-of-the-super-privileges-f/2561#2561.  I would expect to see this behavior after the database was moved to a new server with a new MySQL username.  
  
  ---
  
  