Hi @aureq unfortunately nobody else reported the issue and I couldn't reproduce it. I'm closing but if anyone experiences this again please let us know!

Hi, I've just updated our Piwik from 1.x to 2.10.
In my upgrade instructions I saw the same error and DeviceDetection plugin was disabled automatically.

Thanks for this issue and information, I could manage to activate this plugin.
My workaround was here:

• Add missing two columns manually, following migration error message.
• After that, run update (activate) plugin task.

 alter table piwik_log_visit add column config_os_version VARCHAR( 100 ) DEFAULT NULL;
 alter table piwik_log_visit add column config_device_type  VARCHAR( 100 ) DEFAULT NULL;

I hope this will be of some help.

P.S.
To run console archive script, I had to add more column.

alter table piwik_log_visit add column config_device_type  VARCHAR( 100 ) DEFAULT NULL;
alter table piwik_log_visit add column config_os_version VARCHAR( 100 ) DEFAULT NULL;

@mattab

I experienced the issue if upgrade from v1.11 to v2.11.2

Examine the SQL update script in update page, it attempts to change following columns in piwik_log_visit first before it is added.

execute first, two columns are missing so update fails
ALTER TABLE piwik_log_visit
CHANGE config_os_version config_os_version VARCHAR( 100 ) DEFAULT NULL,
CHANGE config_device_type config_device_type VARCHAR( 100 ) DEFAULT NULL;

execute later
ALTER TABLE piwik_log_visit
ADD COLUMN config_device_type TINYINT( 100 ) NULL DEFAULT NULL,
ADD COLUMN config_device_model VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
ADD COLUMN config_os_version VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
ADD COLUMN visit_total_events SMALLINT(5) UNSIGNED NOT NULL,
ADD COLUMN config_device_brand VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
ADD COLUMN user_id VARCHAR(200) NULL,
ADD COLUMN config_browser_engine VARCHAR(10) NOT NULL;

Thanks @atthakorn for the pointers, the following worked great for me while upgrading from 2.0.3 to 2.13.0 :

mysql> delete from piwik_option where option_name like 'version_log\_%';
mysql> ALTER TABLE piwik_log_visit
    -> ADD COLUMN config_device_type TINYINT( 100 ) NULL DEFAULT NULL,
    -> ADD COLUMN config_os_version VARCHAR( 100 ) CHARACTER SET utf8 \
COLLATE utf8_general_ci NULL DEFAULT NULL,
    -> ADD COLUMN config_device_model VARCHAR( 100 ) CHARACTER SET utf8 COLLATE \
utf8_general_ci NULL DEFAULT NULL,
    -> ADD COLUMN config_device_brand VARCHAR( 100 ) CHARACTER SET utf8 COLLATE \
utf8_general_ci NULL DEFAULT NULL;

Then

./console core:clear-caches
./console core:update

Finally, reactivating the DevicesDetection plugin from Administration -> Plugins passed the update successfully.