Update from 0.4.4 to 0.5.4


(schurl) #1

hello,

i’m using piwik for month now, and i’m very happy with it.
today i saw that a update is available and i tried to do this.

first no errors occured, but then he told me to update the database.

when i click on upgrade piwik the following error occurs:

Critical Error during the update process:
censored/html/piwik/core/Updates/0.5.php:
Error trying to execute the query ‘CREATE INDEX index_type_hash ON piwik_log_action (type, hash);’.
The error was: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user ‘censored’@‘localhost’ to database ‘censored

on the server the version 4.1.15 of mysql is installed

please help me to update piwik

thank you, schurl


(vipsoft) #2

Ask your admin to grant you INDEX privilege or run the query for you: ‘CREATE INDEX index_type_hash ON piwik_log_action (type, hash);’.

Then continue the update.


(schurl) #3

i will contact the admin, thanks for your answer!