New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Updating from 2.16 to 3.0.0b1 fails: piwik_site_setting doesn't exist #10703
Comments
The table should have been created during 2.14.0 upgrade few months ago. To fix this issue you can create the table manually by running this SQL query
|
maybe one could integrate some kind of check if everything is fine before update? |
gave it a try because we didn't miss the 2.14 and oops... got the same:
|
At least manually creating the table fixes the problem for me. But it can't be so critical then anyway, right? |
Thanks for the report. I'm working on a fix in #10708 This was actually related due to a "problem" in Piwik 2.14.0-b2 when someone had updated to |
Thanks! |
manually creating the table fixes the problem for us too. |
This also breaks plugin uninstallation, which reports: Note that this is after I updated to 3.0beta1 via the web interface. It succeeded and claims that there are no more core updates to do when I try to run it manually from the command line; hopefully this is correct. |
Mine instance isnt working 3 days. Tried to create table manually, but no success. |
@jookk execute the following SQL query in your piwik database: 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,
`user_login` VARCHAR(100) NOT NULL DEFAULT '',
INDEX(idsite, plugin_name)
) ENGINE=$engine DEFAULT CHARSET=utf8 if your Piwik does not use table prefixes, then adjust your table name appropriately, eg. change to if you still have some problem let us know the error message |
Will be fixed with #10708 for anyone who upgrades directly to beta2. if you upgraded to beta 1 and have this error, then the solution is to run one SQL query, see: #10703 (comment) |
I also created the table manually. After this, piwik came out with another error message:
I have no idea, where this column is missing. Can you help me please. |
@Redsmith24 add a field |
|
@mattab, it does not work, I execute your SQL passage CREATE TABLE piwik_plugin_setting (
idsite INTEGER(10) UNSIGNED NOT NULL,
`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(idsite, plugin_name)
) ENGINE=$engine DEFAULT CHARSET=utf8 and the output is
Someone on Piwik’s forum offered a workaround that works 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 Yet it does not solve the subsequent problem which is
It seems additional column should be added like this ALTER TABLE piwik_site_setting
ADD plugin_name VARCHAR(60) NOT NULL; Then Piwik finishes updating, however throws the following warning
Question about its meaning is already published on the forum, but nobody cares to answer. |
@sergeevabc Ok let's continue discussion there: https://forum.piwik.org/t/warning-during-upgrade-to-3-0-0/22296 |
@mattab, I neither started that topic, nor have credentials to answer there, but could answer here: |
@mattab thks, this shot the errors ;-) |
While attempt to upgrade from 2.8.3 to 3.0.1 I got the same error |
Same error upgrading from 2.13.1 to 3.0.1. |
Hi to all 1 2 3 And it works well Bruno |
I've been running Piwik since version 1.something, there never was a major problem even in beta versions. However, trying to update to 3.0.0b1 broke everything:
Now what should I do?
The text was updated successfully, but these errors were encountered: