There is no reference because the code automagically should detect it and offer to add the new field.

Do the files plugins/Actions/Columns/InteractionPosition.php and plugins/Actions/Columns/VisitTotalInteractions.php exist in your Piwik?

I would asume that the files are missing in your Piwik. If so, please re-upload all files from Piwik 3.

If they are present, please re-open this issue

Hello, our piwik installation is not missing the mentioned files

very interesting @billtzim ....

@tsteur do you have some idea how, when both files plugins/Actions/Columns/InteractionPosition.php and plugins/Actions/Columns/VisitTotalInteractions.php exist, yet the updater does not trigger to add those columns?

not without investigating. would say actions plugin is disabled. But then it should also not track anything into that column

I have tried to deactivate / activate the Actions and Live plugins as i have read in other posts but the behaviour remains

I added the column manually
alter table piwik_log_visit add column visit_total_interactions MEDIUMINT UNSIGNED DEFAULT 0;

For now we can't reproduce this issue, but if it occurs again in the future we can hopefully find the root cause

Hi gentlemen
We did face a very similar issue with another column. The add column statement couldn't be executed since we did not have sufficient space on OS level to store a copy of the table:

mysql> alter table piwik_log_link_visit_action add column interaction_position SMALLINT UNSIGNED DEFAULT NULL;
ERROR 1114 (HY000): The table 'piwik_log_link_visit_action' is full

We do have the assumption that the return code of the SQL statement might not be checked properly and the failure of the execution is not detected on application level.
We did add some storage and it was working perfectly.