Database Error after update to 0.4.5

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:

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,

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.


Thank you, that fixed it!