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
error piwik_plugin_setting' doesn't exist after upgrade to v3 #11067
Comments
You may be able to fix this error by executing the following SQL query: 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 It should have created this table automatically during the update. Was there maybe any error shown? |
I have seen the same error coming from an ancient version 2.8.3 but no previous error |
Same error upgrading from 2.13.1 to 3.0.1. |
Same error here. After running the above SQL query, the error changed to
No errors were shown prior to the database update step. It does seem to mention file issues, but when I tried to resolve those the setup broke, so I'm doing a manual update now. |
+1 upgrading from 2.14.2 Looks like it blew up after |
I believe this is simple... the upgrade
When the 3.x codebase attempts to run this command, it tries to use the 3.x table. Obviously, the appropriate tables (let alone entries) don't exist yet. The "fix" is to upgrade to a late 2.x version before going to 3.x. Even |
OK we will need to investigate this and make sure 100% that the upgrade from 2.0 to 3.0 should work. |
Here's what I did:
I immediately was prompted with the error:
|
I also provided a diagnosis and proposed solution in #11552 (now closed) |
Thank you very much for the steps to reproduce. I can also reproduce it now 👍 we'll investigate in the next few weeks for sure |
I've still had this happen when trying to upgrade from 2.4.0 to 3.2.1 by replacing the files and then accessing the index which triggers the updater. First I got: As suggested I created it manually. Then I got the same error message about The workaround from this forum post that worked was to reset the database, then upgrade to 2.17.0 and finally upgrade to 3.2.1. |
"SQLSTATE[42S02]: Base table or view not found: 1146 Table '[DBNAME].piwik_plugin_setting' doesn't exist"
After automatic upgrade to v3 I receive the above error, I do not know from which version I upgraded.
The text was updated successfully, but these errors were encountered: