Hello,
I update my piwik 2.16.2 to 2.16.4 and i got some errors when i execute this command:
mhetru@apps-php-pers1:/var/www/piwik$ sudo -u www-data -H /var/www/piwik/console core:update
*** Update ***
Database Upgrade Required
Your Piwik database is out-of-date, and must be upgraded before you can continue.
Piwik database will be upgraded from version 2.16.2 to the new version 2.16.4.
The following dimensions will be updated: log_visit.visit_entry_idaction_url.
This is a major update! It will take longer than usual.
*** Note: this is a Dry Run ***
ALTER TABLE `piwik_log_visit` MODIFY COLUMN `visit_entry_idaction_url` INTEGER(11) UNSIGNED NULL DEFAULT NULL;
*** End of Dry Run ***
A database upgrade is required. Execute update? (y/N) y
Starting the database upgrade process now. This may take a while, so please be patient.
*** Update ***
Database Upgrade Required
Your Piwik database is out-of-date, and must be upgraded before you can continue.
Piwik database will be upgraded from version 2.16.2 to the new version 2.16.4.
The following dimensions will be updated: log_visit.visit_entry_idaction_url.
The database upgrade process may take a while, so please be patient.
WARNING [2016-10-04 07:23:01] /var/www/piwik/core/Updates/2.16.3-b3.php(37): Notice - Undefined variable: timezone - Piwik 2.16.4 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING [2016-10-04 07:23:01] /var/www/piwik/core/Date.php(275): Notice - date_default_timezone_set(): Timezone ID '' is invalid - Piwik 2.16.4 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING [2016-10-04 07:23:01] /var/www/piwik/libs/Zend/Db/Statement/Pdo.php(228): Notice - Array to string conversion - Piwik 2.16.4 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING [2016-10-04 07:23:01] /var/www/piwik/libs/Zend/Db/Statement/Pdo.php(228): Notice - Array to string conversion - Piwik 2.16.4 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING [2016-10-04 07:23:01] /var/www/piwik/core/Updates/2.16.3-b3.php(37): Notice - Undefined variable: timezone - Piwik 2.16.4 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING [2016-10-04 07:23:01] /var/www/piwik/core/Date.php(275): Notice - date_default_timezone_set(): Timezone ID '' is invalid - Piwik 2.16.4 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING [2016-10-04 07:23:01] /var/www/piwik/libs/Zend/Db/Statement/Pdo.php(228): Notice - Array to string conversion - Piwik 2.16.4 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
WARNING [2016-10-04 07:23:01] /var/www/piwik/libs/Zend/Db/Statement/Pdo.php(228): Notice - Array to string conversion - Piwik 2.16.4 - Please report this message in the Piwik forums: http://forum.piwik.org (please do a search first as it might have been reported already)
Thanks!
Mathieu