I successfully updated piwik 2.7 to 3.0, after that logged out and revert admin pass from the database using the values it used to have in piwik_user table.
But now when I login and go to page Visitors -> Visitor Log I get this output:
Mysqli prepare error: Unknown column ‘log_link_visit_action.interaction_position’ in ‘field list’
Thanks for the reply.
So if I got this right, I should manually add columnt interaction_position (MEDIUMINT UNSIGNED DEFAULT NULL) manually. But on which table?
OK I added the column, I no longer get this error but no activity is shown
Also I get a warning:
WARNING: /var/www/piwik/plugins/Actions/Actions.php(43): Notice - Undefined index: visit_total_interactions - Piwik 3.0.0 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
In my logs I see Error query: fetch() failed: Unknown column ‘visit_total_interactions’ in 'field list’
Should I add column visit_total_interactions (MEDIUMINT UNSIGNED DEFAULT 0) on table piwik_log_visit ?
I added the column and now I see real-time visitors.
Also I noticed that when I run /var/www/piwik/console core:archive
I get the error: Unknown column 'log_conversion.config_device_type' in 'field list' - caused by plugin DevicesDetection
Is there any way, other than re-running the update, to check the database scheme?
Also I saw that there’s an open issue for this error.