Jun 2024
4 / 4
Jun 2024
Jun 2024
oscar
Jun '24

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

  • created

    Jun '24

  • last reply

    Jun '24
  • 3

    replies

  • 527

    views

  • 2

    users

  • 1

    like

  • 1

    link

StefanUEGroupware GmbH
Jun '24

Hi Oscar.

Then you should change the provider/book a VPS…

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

FastCGI active?

PHP version?

Stefan

oscar
Jun '24

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
Jun '24

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 :wink: ) 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.