MySQL error after update to 2.7.0


#1

I have updated my piwik instalation from 2.6.1 to 2.7.0 but there was some error during update. Piwik is still working but “core:archive” isn’t and I am getting following error: Unknown column ‘log_visit.user_id’ in ‘field list’

Full output of console core:archive:

ERROR CoreConsole[2014-10-01 12:57:41] [26c74] Got invalid response from API request: https://stats.simplia.cz/index.php?module=API&method=API.get&idSite=86&period=day&date=last52&format=php&token_auth=9ff5b6d6b7f35105e0a58348ae9bd825&trigger=archivephp. Response was 'a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:72:“Mysqli prepare error: Unknown column ‘log_visit.user_id’ in ‘field list’”;}'
ERROR CoreConsole[2014-10-01 12:57:41] [26c74] Got invalid response from API request: https://stats.simplia.cz/index.php?module=API&method=API.get&idSite=86&period=day&date=last52&format=php&token_auth=9ff5b6d6b7f35105e0a58348ae9bd825&trigger=archivephp. Response was 'a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:72:“Mysqli prepare error: Unknown column ‘log_visit.user_id’ in ‘field list’”;}'
ERROR CoreConsole[2014-10-01 12:57:41] [26c74] Empty or invalid response ‘’ for website id 86, Time elapsed: 0.237s, skipping
ERROR CoreConsole[2014-10-01 12:57:41] [26c74] Empty or invalid response ‘’ for website id 86, Time elapsed: 0.237s, skipping

I have tried use this FAQ After the update, I get sql errors, I would like to try the update again. How do I force Piwik to re-upgrade the database from a past version? - Analytics Platform - Matomo to force DB upgrade and it runs without error but nothing changes.


(Matthieu Aubry) #2

in this case you can manualy fix it by adding a “user_id” column to your log_visit table (TYPE should be VARCHAR)


#3

I did fresh install to new database, used Navicat to compare structure and applied them manually. It is working fine now.