@Power2All opened this Issue on September 12th 2017

Found another issue after upgrade, looks like a twig issue.

image

@sgiehl commented on September 12th 2017 Member

That does not seem to be a twig problem. The visitor data provided for rendering seems to be incorrect. Could you try to open this url and check if the response contains an error:
method=Live.getLastVisitsDetails&idSite=1&filter_limit=10&format=php&serialize=0&disable_generic_filters=1 (you may need to adjust the idSite param)

@Power2All commented on September 12th 2017

Bug found.
Seems something changed with the upgrade process, and MySQL is not properly updated:

{result: "error",…}
message
:
"Mysqli prepare error: Unknown column 'log_link_visit_action.idpageview' in 'field list'"
result
:
"error"

Any idea how to fix this?
Did something change in tables?

@sgiehl commented on September 12th 2017 Member

Could you please paste the result of this query:

SELECT option_value FROM piwik_option WHERE option_name = 'version_log_link_visit_action.idpageview';
@Power2All commented on September 12th 2017

image

@sgiehl commented on September 12th 2017 Member

Could you check if this file exists on your Piwik:
piwik/plugins/Actions/Columns/IdPageview.php

@Power2All commented on September 12th 2017

-rw-r--r-- 1 09-webstats www-data 896 Sep 12 10:17 plugins/Actions/Columns/IdPageview.php

@sgiehl commented on September 12th 2017 Member

You can run the SQL DELETE FROM piwik_option WHERE option_name = 'version_log_link_visit_action.idpageview';
Afterwards Piwik should automatically create the missing coulmn when you open it.

@tsteur commented on September 12th 2017 Owner

@Power2All do you remember from which Piwik version you updated?

@tsteur commented on September 12th 2017 Owner

@sgiehl we are getting similar error on demo.piwik.org on an ecommerce website (Marketplace)

A fatal error occurred

The following error just broke Piwik (v3.1.0-rc1):

Key "icon" for array with keys "type, url, pageTitle, pageIdAction, idpageview, serverTimePretty, timeSpentRef, pageId, contentName, contentPiece, contentTarget, contentInteraction, interactionPosition, timestamp" does not exist.
in
/storage/piwik-demo/www/demo.piwik.org/plugins/Live/templates/getLastVisitsStart.twig line 148

image

edit: noticed this is different issue and created https://github.com/piwik/piwik/issues/12037

@sgiehl commented on September 12th 2017 Member

guess that is caused by content actions. Seems I missed to have them correctly handled in real time widget

@Power2All commented on September 13th 2017

You can run the SQL DELETE FROM piwik_option WHERE option_name = 'version_log_link_visit_action.idpageview';
Afterwards Piwik should automatically create the missing coulmn when you open it.

When I did this, it came finally with a "update your database" when accessing piwik again.
After the upgrade, it still showed the above red text error, but when it parsed some stuff, it started to work again.
So far now it looks good.

@sgiehl commented on September 13th 2017 Member

@Power2All do you remember from which Piwik version you updated?

@mattab commented on September 21st 2017 Owner

Hi @sgiehl is this issue maybe fixed?

@sgiehl commented on September 21st 2017 Member

No. This is unrelated to the last release. Sure, the error now pops up, as the idpageview column is now used. But it should have been created in an update before. Not sure why I wasn't.

@mattab commented on September 21st 2017 Owner

Might be duplicate of https://github.com/piwik/piwik/issues/11981 and probably other issues

Powered by GitHub Issue Mirror