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

Update does not detect the newly available DB schema upgrades #6383

Closed
orlitzky opened this issue Oct 3, 2014 · 9 comments
Closed

Update does not detect the newly available DB schema upgrades #6383

orlitzky opened this issue Oct 3, 2014 · 9 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Milestone
2.8.0

Comments

@orlitzky
Copy link

orlitzky commented Oct 3, 2014

This is the same problem as issue #6295, except I do have the Contents plugin installed and enabled. It shows up on the "Plugins" screen, and a system check runs fine, and core:update tells me there's nothing to do. But when I run my nightly archive, I still see the error:

Column not found: 1054 Unknown column 'log_link_visit_action.idaction_content_name' in 'where clause'";}'

Is it possible that the Contents plugin needed to be enabled before I ran core:update? If so, is there a way to get the update to run after-the-fact?
@tsteur
Copy link
Member

tsteur commented Oct 4, 2014

Try to run ./console core:clear-caches or something like php console core:clear-caches within the Piwik directory and then core:update again. It might work afterwards. Make sure to clear any opcache (such as APC) in case you are using one and if possible.

If it still does not work, try to execute the SQL query delete from piwik_option where option_name like 'version_log_link_visit_action.idaction_content_%'; and execute the above mentioned steps again. Depending on your table prefix you might have do use a different table name than piwik_option

@orlitzky
Copy link
Author

orlitzky commented Oct 4, 2014

Ah, thank you. Clearing the Piwik/Zend caches allowed core:update to continue and now the archive process seems to be working.

@orlitzky orlitzky closed this as completed Oct 4, 2014
@mattab
Copy link
Member

mattab commented Oct 5, 2014

@tsteur maybe we could automatically run the core:clear-caches command prior to executing the core:update command?

@mattab mattab reopened this Oct 5, 2014
@mattab mattab added the Bug For errors / faults / flaws / inconsistencies etc. label Oct 5, 2014
@mattab mattab changed the title Archive error after upgrade to 2.7.0 Update does not detect the newly available DB schema upgrades Oct 5, 2014
@mattab mattab added this to the Short term milestone Oct 5, 2014
@tsteur
Copy link
Member

tsteur commented Oct 6, 2014

Go for it. You can simply call the method to clear the caches

@mattab mattab added the Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. label Oct 6, 2014
@mattab mattab modified the milestones: Piwik 2.8.0, Short term Oct 6, 2014
@mattab
Copy link
Member

mattab commented Oct 6, 2014

@cqwww your PHP is not using php 5.3

@mattab mattab closed this as completed in eb25aea Oct 6, 2014
@mattab
Copy link
Member

mattab commented Oct 6, 2014

@cqwww can you enable the "Contents" plugin in your Settings>Plugins screen?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Projects
None yet
Milestone
2.8.0
Development

No branches or pull requests
4 participants
@tsteur @mattab @orlitzky and others