Thread

This question may be related to a resolved thread.

Try to upgrade from ee213 to ee221. It failed. The notice is:

A Database Error Occurred
Error Number: 1142

There seems to be a solution:

“After giving the ‘Manage Indexes’ permission to my MySQL user, it seems I was able to upgrade successfully. Now I’m unable to login and have encountered another error.”

I use phpMyAdmin to manage the database. I don’t find, where to Manage Indexes.

The mysql-documentation about permissions is a little to complicated ... Perhaps someone could give me a hint?

Frank

Hi Frank,

Please work with your host to enable the Manage Indexes permission on your MySQL server. We’re not actually able to assist with that sort of thing due to the wide range of configurations that hosts use for the setups.

Once you have the correct permission setup on your MySQL server, please make sure you clear your database and restore the database backup before trying your upgrade again.

this just happened to me for the first time too.  i not only had to restore my database but recopy over my original config.php file.  the update process modified the “app_version” to 214 within it.  i was afraid that rerunning the update process on a 1.6.x database wouldn’t be complete or work at all if the update process thought it was on 2.1.4.

this is the first time i’ve seen this issue with any EE updates.  is this ‘modify indexes’ permission a new requirement?  seems like enough people are having the exact same problem and the update instructions perhaps should be modified to prepare us for this.

thanks

Morning Chris- I thought index permission had always been required, but took a quick look at the 1.x docs and it wasn’t in there.  It is fairly rarely used, particularly when compared to the others.  But still, definitely needed (and in the 2.x doc’s requirements).

That said, I’m thinking either a user note or a ‘core’ note might well be advised in the 1.x->2.x instructions.  Maybe in ‘Prepare for the Upgrade’ make a note to check mysql user permissions and link to the requirements page?  Or would that confuse more folks than it would help?