@orlitzky opened this Issue on October 3rd 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 commented on October 4th 2014 Owner

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 commented on October 4th 2014

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

@mattab commented on October 5th 2014 Owner

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

@tsteur commented on October 6th 2014 Owner

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

@cqwww commented on October 6th 2014

$ ./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

Line 22:

Piwik\Translate::loadEnglishTranslation();

@mattab commented on October 6th 2014 Owner

@cqwww your PHP is not using php 5.3

@cqwww commented on October 6th 2014

"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)

@mattab commented on October 6th 2014 Owner

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

@cqwww commented on October 7th 2014

Thank you @mattab. All is well with the world again!

This Issue was closed on October 6th 2014
Powered by GitHub Issue Mirror