CiviCRM Community Forums (archive)

The error according to the log file is as follows:

[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_email
 SET is_primary = 0   WHERE (  civicrm_email.id = 2 )   [nativecode=1449 ** The user specified as a definer ('root'@'localhost') does not exist]"]
)


The problem is, I can't find where it's trying to use that db user. I had previously installed this Civi installation on my local machine and the root@localhost user is my local db user. civicrm.settings.php and settings.php have been updated to reflect moving the site to a remote development server but this error still persists. I can't find in the database or anywhere else a reference to that old user and so have no idea how or why it's trying to use it!

Any suggestions would be much appreciated.

Thanks,

welly

Marvellous! That worked a treat. Thanks very much!