mysql error while upgrading 5.3.1.1 to 5.3.2
Permalink
Hi there, I'm trying to finally update to the latest version of c5, but I'm having trouble getting 5.3.2 to update. I've uploaded all the files to the /concrete directory and now I've gone tohttp://www.mysite.com/index.php/tools/required/upgrade.... When I click the button to upgrade I get this error:
Error occurred while upgrading: mysql error: [1142: INDEX command denied to user 'cierrac1_admin'@'localhost' for table 'BlockTypes'] in EXECUTE("DROP INDEX btHandle ON BlockTypes")
I have no idea what this means :(.Can anyone help?
Error occurred while upgrading: mysql error: [1142: INDEX command denied to user 'cierrac1_admin'@'localhost' for table 'BlockTypes'] in EXECUTE("DROP INDEX btHandle ON BlockTypes")
I have no idea what this means :(.Can anyone help?
1) 5.4.0.5 is the latest release version of C5, but 5.4.1 is just around the corner - out of beta and in RC (release candidate) status. You might consider holding off and upgrading when 5.4.1 is released.
2) The error you're encountering suggests that the DB user doesn't have sufficient privileges to modify tables in the manner being attempted - i.e. deleting indexes. I guess you'd have to grant appropriate privileges using DB admin software (PHP MyAdmin or some such.)
-Steve