Skip to content
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

Jump to bottom

After upgrading to piwik 3.13.1 Tables Errors #15562

Closed
msonnad opened this issue Feb 13, 2020 · 4 comments
Closed

After upgrading to piwik 3.13.1 Tables Errors #15562

msonnad opened this issue Feb 13, 2020 · 4 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@msonnad
Copy link

msonnad commented Feb 13, 2020

Hi We are getting the
Mysqli prepare error: Table 'piwik.piwik_locks' doesn't exist

Mysqli prepare error: Table 'piwik.piwik_brute_force_log' doesn't exist
errors .

Tried to update the UPDATE piwik.piwik_option SET option_value = "3.13.1" WHERE option_name = "version_core";
This doesnt make any impact.
Very often we used to get
image

this error.

Thanks, Manjunath S S
@toredash
Copy link
Contributor

I suspect you have forgot to update your database tables.

Please run:
./path/to/matomo/console core:update

@msonnad
Copy link
Author

msonnad commented Feb 13, 2020 •
edited

@toredash Thanks for your reply.
Can u please help me where to run this command?

I tried running under deployment directory /apache2/htdocs/Piwik, and under PHP/
not able to execute the command.

****************************** Update **************************
I aable to run the command. and successfully updated the table
image

After update also, I am seeing the same error on UI.
image

@sgiehl
Copy link
Member

sgiehl commented Feb 13, 2020

You might have broke the update process by manually updating the version in the options table.
Maybe try setting the option back to the version you had before and rerun the update on console

@msonnad
Copy link
Author

msonnad commented Feb 13, 2020

Hi @sgiehl ,
Thanks its worked for me.
After updating the Piwik . We need to execute the core: update

@tsteur tsteur closed this as completed Feb 13, 2020
@tsteur tsteur added the answered For when a question was asked and we referred to forum or answered it. label Feb 13, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@tsteur @toredash @sgiehl @msonnad