Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

errors when upgrading 0.2.7 to 0.4.4 #533

Closed
jericho63 opened this issue Apr 25, 2016 · 1 comment
Closed

errors when upgrading 0.2.7 to 0.4.4 #533

jericho63 opened this issue Apr 25, 2016 · 1 comment
Labels

Comments

@jericho63
Copy link

hello,

i have these messages when i tried to upgrade to 0.4.4

Errors
Uncaught exception during upgrade: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1142 ALTER command denied to user 'baikal'@'172.17.0.7' for table 'calendars'' in /var/www/baikal.domain.fr/Core/Frameworks/BaikalAdmin/Controller/Install/VersionUpgrade.php:167 Stack trace: #0 /var/www/baikal.domain.fr/Core/Frameworks/BaikalAdmin/Controller/Install/VersionUpgrade.php(167): PDO->exec('ALTER TABLE cal...') #1 /var/www/baikal.domain.fr/Core/Frameworks/BaikalAdmin/Controller/Install/VersionUpgrade.php(61): BaikalAdmin\Controller\Install\VersionUpgrade->upgrade('0.2.7', '0.4.4') #2 /var/www/baikal.domain.fr/Core/Frameworks/Flake/Core/Render/Container.php(71): BaikalAdmin\Controller\Install\VersionUpgrade->render() #3 /var/www/baikal.domain.fr/Core/Frameworks/Flake/Controller/Page.php(85): Flake\Core\Render\Container->renderBlocks() #4 /var/www/baikal.domain.fr/html/admin/install/index.php(83): Flake\Controller\Page->render() #5 {main}

thank you for your help

Jericho

@evert evert added the question label Apr 25, 2016
@evert
Copy link
Member

evert commented Apr 25, 2016

The error pretty much explained it. You set up the baikal user in mysql so it is not allowed to execute the ALTER TABLE statement. Change this and it will work. Note that you need to restart your upgrade process from your backup, as you might otherwise end up with an inconsistent state.

@evert evert closed this as completed Apr 25, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants