Upgrade from 1.5.1 to 1.6 failed

Support & Bugs
1

Here I wanted to update, which I now know was a mistake, be cause i get this error

/home/+++++/+++++_html/piwik/core/Updates/1.6-b1.php:
Error trying to execute the query ‘ALTER TABLE piwik_log_conversion_item
ADD idaction_category2 INTEGER(10) UNSIGNED NOT NULL AFTER idaction_category,
ADD idaction_category3 INTEGER(10) UNSIGNED NOT NULL,
ADD idaction_category4 INTEGER(10) UNSIGNED NOT NULL,
ADD idaction_category5 INTEGER(10) UNSIGNED NOT NULL’.
The error was: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘idaction_category2’

2

hmm ok I will delet all my Piwik stats, its the only option, its shame.

3

IT sounds like you already run the upgrade. You can also run:


UPDATE `piwik_option` SET option_value = "1.6" WHERE option_name = "version_core";

Then you don’t have to delete your stats.

4

hmm i have done already, i will upload a new version and then just not update anymore.