Upgrade 3.9.1 to 3.10.0 leads to date errors when viewing website details #14644

After upgrading from 3.9.1 to 3.10.0 I am receiving an error when I try to view the details of a website. The "All Websites" page works fine, but when I try to open a website i get the error that the time range is invalid.

PHP Error Log:

2019/07/09 18:34:11 [error] 32<a href='/32'>#32</a>: *72 FastCGI sent in stderr: "PHP message: Error in Matomo: The date &<a href='/039'>#039</a>;-0001-11-30&<a href='/039'>#039</a>; is a date before first website was online. Try date that&<a href='/039'>#039</a>;s after Aug 6, 1991 (timestamp 681436800).: -62169984000" while reading response header from upstream, client: x.x.x.x, server: , request: "GET /index.php?module=CoreHome&action=index&date=today&period=day&idSite=5 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php-fpm7.sock:", host: "xxxxxxx", referrer: "https://xxxxxxx/index.php?module=MultiSites&action=index&idSite=1&period=day&date=today"

Firefox 67, PHP 7.2.19 using Docker Image from https://github.com/crazy-max/docker-matomo

output from database migration:

    *** Update ***

    Database Upgrade Required

    Your Matomo database is out-of-date, and must be upgraded before you can continue.

    Matomo database will be upgraded from version 3.9.1 to the new version 3.10.0.

    *** Note: this is a Dry Run ***

    ALTER TABLE `piwik_report` ADD COLUMN `period_param` VARCHAR(10) NULL;
    ./console plugin:activate "Tour"

    *** End of Dry Run ***

Starting the database upgrade process now. This may take a while, so please be patient.

    *** Update ***

    Database Upgrade Required

    Your Matomo database is out-of-date, and must be upgraded before you can continue.

    Matomo database will be upgraded from version 3.9.1 to the new version 3.10.0.

    The database upgrade process may take a while, so please be patient.

  Executing ALTER TABLE `piwik_report` ADD COLUMN `period_param` VARCHAR(10) NULL;... Done. [1 / 2]
  Executing ./console plugin:activate "Tour"... Done. [2 / 2]

Matomo has been successfully updated!

@roock what is the URL when you open the dashboard? Feel free to hide the domain. We may need access to the instance if that's possible to quickly have a look as we can't reproduce this

@tsteur Thank you for your feedback. The URL is: https://matomo.example.unknown/index.php?module=CoreHome&action=index&date=today&period=day&idSite=1
Access to instance should be possible. Let me know about the details!

Can you email the details to hello at matomo.org? Cheers

I have installed the new matomo instance. I got an below same error while creation version on tag manager.
Start date: The date '-0001-11-30' is a date before first website was online. Try date that's after Aug 6, 1991 (timestamp 681436800).: -62169984000

This should be fixed in a recent 3.13.0 release @SivaranjaniMurugeshan

I will close this issue as I think we made a few fixes in various places. Let me know if someone is still experiencing this issue.

For future reference: the issue was that my superuser created during installation had set the date_registered in piwik_user to 0. Changing it to a valid date solved the issue.