PIWIK 1.3 db upgrade problem - SQLSTATE[42000]


(Betablocker) #1

Hello - i get the following error when trying to update piwik from latest to 1.3.

Kritischer Fehler während der Aktualisierung:
/var/kunden/webs/joiler/www/piwik/core/Updates/1.2.5-rc7.php:
Error trying to execute the query ‘ALTER TABLE piwik_log_visit
ADD INDEX index_idsite_idvisitor (idsite, idvisitor)’.
The error was: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name ‘index_idsite_idvisitor’

Someone got an idea?

Since 1.2 the automatic update doesnt work anymore - at the last upgrade version i had to work in phpmyadmin too.

Greetings from Germany


(Matthieu Aubry) #2

see 301 Moved Permanently