Error - upgrading from version 1.11.1 to version 1.12

Support & Bugs
1

Hi,

I am getting this error while I upgrading from version 1.11.1 to the new version 1.12

Critical Error during the update process:

/home/XXX/XXX/piwi/core/Updates/1.12-b1.php:
Error trying to execute the query ‘ALTER TABLE piwik_log_link_visit_action
ADD custom_float FLOAT NULL DEFAULT NULL’.
The error was: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘custom_float’

I also tried through phpmyadmin but still the error appears.

Please advice.

Thanks,
Sam

2

This FAQ can help you solve this problem: Update - Analytics Platform - Matomo

3

I changed piwik to maintenance mode and then I ran this command via phpmyadmin.

UPDATE piwik_option SET option_value = “1.11” WHERE option_name = “version_core”;

Then on Update PIWIK page(version 1.11 to the new version 1.12.) I clicked on UPGRADE PIWIK button but I still got the same error as earlier.

Error trying to execute the query ‘ALTER TABLE piwik_log_link_visit_action
ADD custom_float FLOAT NULL DEFAULT NULL’.
The error was: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘custom_float’

:frowning:

Any help?

4

try UPDATE piwik_option SET option_value = “1.12-b1” WHERE option_name = “version_core”;

5

[quote=matt]
try UPDATE piwik_option SET option_value = “1.12-b1” WHERE option_name = “version_core”;[/quote]

Great, it worked fine this time and it upgraded without any error.