Update 0.2.28 -> 0.5 error... [resolved]


First, thx for this great soft !

As I try to upgrade my server, I’ve some troubles :

  • /var/www/localhost/htdocs/piwik/core/Updates/0.4.3.php: Error trying to
    execute the query ‘DROP INDEX index_idaction ON log_action’. The error was:
    SQLSTATE[42000]: Syntax error or access violation: 1091 Ne peut effacer (DROP)
    ‘index_idaction’. V�rifiez s’il existe

To make it work :

mysql piwik -p

Enter password: *************
mysql> create index index_idaction on log_action(idaction);

and then the upgrade seems work

php index.php

returns “Piwik a été mis à jour avec succès !” (french version).

Best regards.