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

Error in database migration from 2.16.3-b2 to 2.16.4. #10699

Closed
k-nut opened this issue Oct 6, 2016 · 9 comments
Closed

Error in database migration from 2.16.3-b2 to 2.16.4. #10699

k-nut opened this issue Oct 6, 2016 · 9 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@k-nut
Copy link

k-nut commented Oct 6, 2016

When trying to upgrade to the 2.16.4 version from 2.16.3-b2 the following error happens during the migration:

Critical Error during the update process:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hour' in 'field list'

Rerunning the migration does not mitigate the problem and the page seems to be stuck in the update state now.

The PHP verison used is 5.4.45
The mysql version is 5.5.52

Let me know if there is any more information that I should provide.
@hebbet
Copy link

hebbet commented Oct 6, 2016

try using 2.16.5

@k-nut
Copy link
Author

k-nut commented Oct 6, 2016

How would I do that? I don't see a way to do it from the GUI as it is stuck in this half updated state now. Should I replace the piwik files on disk?

@RMastop
Copy link
Contributor

RMastop commented Oct 6, 2016

@k-nut use the Manual Three-Step Update, described here:
http://piwik.org/docs/update/#the-manual-three-step-update

@k-nut
Copy link
Author

k-nut commented Oct 7, 2016

I tried this but still get the same error.
This is what the updater says it will do:

Piwik database will be upgraded from version 2.16.3-rc2 to the new version 2.16.5.

The following dimensions will be updated: log_visit.visit_entry_idaction_url.

@k-nut
Copy link
Author

k-nut commented Oct 26, 2016

Any suggestions for what else to try/how to get more debug information?

@mattab
Copy link
Member

mattab commented Nov 3, 2016

@k-nut most likely what is happening is that your mysql server is not finishing to run the SQL query. can you check your mysql error logs for more info? then you can search in our FAQ for a solution to the actual error.

@mattab
Copy link
Member

mattab commented Nov 12, 2016

@k-nut to fix your issue please create a new column hour in the table mentioned in the message. The column has a type of "integer". this should fix your update path hopefully 👍

@mattab mattab closed this as completed Nov 12, 2016
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Nov 12, 2016
@k-nut
Copy link
Author

k-nut commented Nov 12, 2016

@mattab sorry for the many questions but this would be the log_visit table then?

@k-nut
Copy link
Author

k-nut commented Nov 12, 2016

Nevermind. I figured out that it is the reports table that needs this new column. Thank you for your help @mattab, @hebbet and @RMastop 💐

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
@mattab @k-nut @hebbet @RMastop