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?
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
Ah, thank you. Clearing the Piwik/Zend caches allowed core:update to continue and now the archive process seems to be working.
@tsteur maybe we could automatically run the
core:clear-caches command prior to executing the
Go for it. You can simply call the method to clear the caches
$ ./console core:clear-caches
Warning: Unexpected character in input: '\' (ASCII=92) state=1 in $PATH/console on line 22
Parse error: syntax error, unexpected T_STRING in $PATH/console on line 22
"Caches cleared" when using php 5.3.
I get the same error when I try to go to the website after this.
SQL: delete from piwik_option where option_name like 'version_log_link_visit_action.idactioncontent%' results in:
Query OK, 0 rows affected (0.00 sec)
@cqwww can you enable the "Contents" plugin in your Settings>Plugins screen?