Undefined index: timezone in /home/www/piwik/core/Site.php on line 66

Support & Bugs
1

Hi
my update 0.5 to 0.6 ended up in an error-page:

#3 Piwik_FrontController->dispatch() called at [/home/www/piwik/index.php:59]
#2 Piwik_Controller->__construct() called at [/home/www/piwik/core/FrontController.php:118]
#1 Piwik_Site->getTimezone() called at [/home/www/piwik/core/Controller.php:54]
Backtrace -->
#0 Piwik_ErrorHandler(8, Undefined index: timezone, /home/www/piwik/core/Site.php, 66, Array ()) called at [/home/www/piwik/core/Site.php:66]

Notice: Undefined index: timezone in /home/www/piwik/core/Site.php on line 66

After that i did a new installation and want to use my old database tables.
When i now log into my piwik, i cannot see data that is older than today and i cannot pick a date older than today.

What happened here?

2

Do you have a “timezone” field in your piwik_site table? If not, it looks like the upgrade didn’t execute well for you. Which version were you upgrading from?

3

i have a timezone column in the table filled with “UTC” - and updated from version 0.55.

4

To resolve the issue that you can’t select a date older than today, you can manually set the piwik_site.ts_created date to an older date.

5

Thx this solved the rest of my problems, too.
now i see my old data again.