I previously tested out a migration from a super old version of Piwik (1.12) to Matomo 3.14.1, and then to 4.0.0. There was at least one manual intervention that I had to make to get things working.
I figured that it would be safe to migrate all the way from 1.12 to 4.0 as part of the live migration from an old server to a new one. However, I’m getting this error on the Matomo dashboard after the migration:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_link_visit_action.pageview_position' in 'field list'
I noticed that the old column name
interaction_position (according to 4.0.0-b1.php) is not in the table definition either.
I would appreciate any help… I’m looking through code and other related issues people have had in the past, but so far I’ve had no luck. Thanks! : )