Database Error after update to 0.4.5


(fert) #1

Hi,
I just copied the new files on to my webspace. When trying to access Piwik again, I click on “Upgrade Piwik”, then I get this message:

/homepages/1/d275xxxxxx/htdocs/piwik/core/Updates/0.4.3.php:
Error trying to execute the query 'DROP INDEX index_idaction ON piwik_log_action'.
The error was: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘index_idaction’; check that column/key exists

The screen with the “Upgrade Piwik” button says “upgrade from 0.4.2 to 0.4.5” - I am not 100% sure, but if I remember correctly, my previous version was 0.4.1 and NOT 0.4.2
Can anyone help me with this one?
Kind regards,
Fert


(vipsoft) #2

Piwik applies updates incrementally. Internally, it was updated from 0.4.1 to 0.4.2.

The 0.4.3 update script is a mixed bag of “magic” to fix some inconsistencies, but is naive in that it does not know what Piwik version you first/initially installed.

If you don’t have INDEX privilege or that index doesn’t exist, then comment out that SQL statement to move on.

See http://forum.piwik.org/index.php?showtopic=1324


(fert) #3

Thank you, that fixed it!