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!
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.