Timezone issue

[oscar]

Hi all,
I installed the latest release this morning (outside docker - my provider doesn´t support that).
Everything seems to work ok, except cron is sending me an error at every run:

An error happened (mysqli_sql_exception): Unknown or incorrect time zone: 'Europe/Berlin' (1298): Instructions to install timezones in your DB: https://mariadb.com/kb/en/mysql_tzinfo_to_sql/
File: /vendor/egroupware/adodb-php/drivers/adodb-mysqli.inc.php, Line: 856
[...]

The system timezone is Europe/Amsterdam and when I execute phpinfo() from at cli level that’s what I get as Default Timezone and as date.timezone (both local and master value).
Yet, if I show phpinfo from the Admin area in eGW, Default Timezone is “Europe/Berlin” (both others are still Amsterdam).

Any ideas here?
Thanks in advance,
Oscar

[StefanU]

Hi Oscar.

(outside docker - my provider doesn´t support that

Then you should change the provider/book a VPS…

Since Docker, we hardly have such problems any more compared to the past.

---

FastCGI active?

Unknown or incorrect time zone - nach Update 23.1

PHP version?

Stefan

[oscar]

PHP version is 8.2 and no FastCGI active, but the other issue you refer to is different: thatś about the Europe/Berlin timezone being unknown, while on my server the timezone is Europe/Amsterdam.

So it looks like somewhere in the process a default is taken.
I already tried updating the catch in api/src/DateTime.php to see if that would help, but no luck there.

[oscar]

Got it: the config table contained:

+------------+-----------------+---------------+
| config_app | config_name     | config_value  |
+------------+-----------------+---------------+
| phpgwapi   | server_timezone | Europe/Berlin |
+------------+-----------------+---------------+

Setting this to Europe/Amsterdam (in my case) fixed it.
My database is around 20 years old (yes, that’s how long I´m an eGW user already ) so the problem might have been in there for a long time already unnoticed.

I now get the same error (Unknown or incorrect time zone) for the correct timezone, but that I know how to fix.