Piwik 3.0 database upgrade error

I ran into the same issue
The sql to create that table can be found on Github(Mysql.php:79), it would be:

CREATE TABLE piwik_plugin_setting (
plugin_name VARCHAR(60) NOT NULL,
setting_name VARCHAR(255) NOT NULL,
setting_value LONGTEXT NOT NULL,
user_login VARCHAR(100) NOT NULL DEFAULT ‘’,
INDEX(plugin_name, user_login)
) ENGINE=Innodb DEFAULT CHARSET=utf8

But I then get the next error;

  • SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘plugin_name’ in ‘where clause’

EDIT: The above was caused by piwik_site_setting not having the plugin_name column, you might have to DROP piwik_site_setting (Backup your data!) and run the following;

CREATE TABLE piwik_site_setting (
idsite INTEGER(10) UNSIGNED NOT NULL,
plugin_name VARCHAR(60) NOT NULL,
setting_name VARCHAR(255) NOT NULL,
setting_value LONGTEXT NOT NULL,
INDEX(idsite, plugin_name)
) ENGINE=INNODB DEFAULT CHARSET=utf8

UPDATE: It completed but with the following warning, Googling that (or part of it) gives no info on how to resolve it though

[!] Warning messages:
* You are not allowed to change the value of the setting "enable_plugin_update_communication" in plugin "CoreUpdater"
The update completed successfuly, however there were issues during the process. Please read the above descriptions for details. For further help:

After this Piwik finally loaded but a lot of dahboard modules said “ViewDataTable ID ‘table’ is already in use!”

I was able to solve this by removing > plugins/CoreVisualizations/Visualizations/HtmlTable/PivotBy.php
as described in this post

The update documentation didn’t seem to mention any issues updating from older versions to 3.0, and it doesn’t give the option to update incrementally either?
Not updating incrementally seems to be the cause according to this Github issue;

2 Likes