← Back to team overview

mahara-contributors team mailing list archive

[Bug 1885589] Re: MySQL Error when upgrading from 18.04.02 to 19.04+

 

Hi Philippe,

It looks like this error could be related to MySQL configuration. A
quick search online shows that the "definer error" might be due to MySQL
trying to update the DB or create an object under a DB user that doesn't
exist. This can happen for example when you are trying to migrate your
DB to another site.

Is it's a new install please make sure you've granted the correct
privileges to the user. According to the following post, it might be
related to the problem you're having:

https://stackoverflow.com/questions/38361787/error-1449-the-user-
specified-as-a-definer-rootlocalhost-does-not-exis

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1885589

Title:
  MySQL Error when upgrading from 18.04.02 to 19.04+

Status in Mahara:
  New

Bug description:
  Greetings from Germany,

  While trying to upgrade Mahara from 18.04.02 to 19.04 we've encountered following problem with our MySQL Server:
  Failed to get a recordset: mysqli error:[1449: The user specified as a definer ($mysqluser@$mysqlhost) does not exist]

  This problem seems to occur regardless of what version we try to
  upgrade to (tried with 18.10, 19.04, 19.10, 20.04).

  
  Philippe

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1885589/+subscriptions


References