Errors in update 2.16.4

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

Hello,
same for me - 2.16.2 --> 2.16.4 - got thousands of those Errors when updating!

Next to “Notice - date_default_timezone_set(): Timezone ID ‘’ is invalid” Errors

See here: http://temp.in.futureweb.at/piwik/2.16.4.update.log

CT-100-bash-4.2# php -v
PHP 7.0.11 (cli) (built: Sep 15 2016 09:38:31) ( NTS )
Copyright (c) 1997-2016 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies
    with Zend OPcache v7.0.11, Copyright (c) 1999-2016, by Zend Technologies

Andreas Schnederle-Wagner

Looks like the same error as another thread here

1 Like

Hi guys, sorry there is an issue in the upgrade and it can corrupt your scheduled reports definition :frowning: we are right now working on a fix and will release 2.16.5 ASAP. Very sorry about the trouble.

Piwik 2.16.5 has been released and fixes this issue. In case your Scheduled reports are not working anymore you may have to re-create them manually, or you can also restore the table piwik_report (containing your Scheduled reports definition) from a backup if you have one. We are sorry for any inconvenience caused.

Hi @matthieu,
thx for quick fix … 735 scheduled reports have been wrecked by this Bug! :-/
Fortunately we have a pretty good backup policy! :wink:
bye from Austria
Andreas