Problem event grid after update Icinga(web)2

We’ve updated our Icinga Environment from 2.12 to the last 2.13 Version and Icingaweb from 2.8 to 2.11. Actually all is fine except of one thing. On “history → event grid” we get a error that we not understand.

SQLSTATE[42883]: Undefined function: 7 ERROR: function from_unixtime(timestamp without time zone) does not exist
HINT: No function matches the given name and argument types. You might need to add explicit type casts., query was: SELECT DATE(FROM_UNIXTIME(sth.timestamp)) AS day, SUM(CASE WHEN sth.state = 2 AND sth.type = 'hard_state' THEN 1 ELSE 0 END) AS cnt_critical_hard FROM (SELECT sh.statehistory_id AS id, ('service') AS object_type, h.display_name AS host_display_name, so.name1 AS host_name, so.name2 AS service_description, s.display_name AS service_display_name, so.name1 AS service_host_name, (CASE WHEN sh.state_type = 1 THEN 'hard_state' ELSE 'soft_state' END) AS type, sh.state_time AS timestamp, sh.object_id, sh.state, (CASE WHEN sh.state_type = 1 THEN sh.output ELSE '[ ' || sh.current_check_attempt || '/' || sh.max_check_attempts || ' ] ' || sh.output END) AS output FROM icinga_statehistory AS sh
INNER JOIN icinga_objects AS so ON so.object_id = sh.object_id AND so.is_active = 1 AND so.objecttype_id = 2
INNER JOIN icinga_services AS s ON s.service_object_id = so.object_id
INNER JOIN icinga_hosts AS h ON h.host_object_id = s.host_object_id WHERE (sh.state_time >= '2022-04-20 14:09:16')) AS sth GROUP BY DATE(FROM_UNIXTIME(sth.timestamp)) ORDER BY DATE(FROM_UNIXTIME(sth.timestamp)) DESC

i’ve executed all database update sql-files. but we can’t fix the error.

informations about our environment:
icinga2 - The Icinga 2 network monitoring daemon (version: r2.13.4-1)

Copyright (c) 2012-2022 Icinga GmbH (
License GPLv2+: GNU GPL version 2 or later
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.

System information:
Platform: CentOS Linux
Platform version: 7 (Core)
Kernel: Linux
Kernel version: 4.14.35-2047.514.5.el7uek.x86_64
Architecture: x86_64

Build information:
Compiler: GNU 11.2.1
Build host: runner-hh8q3bz2-project-322-concurrent-0
OpenSSL version: OpenSSL 1.0.2k-fips 26 Jan 2017

Application information:

General paths:
Config directory: /etc/icinga2
Data directory: /var/lib/icinga2
Log directory: /var/log/icinga2
Cache directory: /var/cache/icinga2
Spool directory: /var/spool/icinga2
Run directory: /run/icinga2

Old paths (deprecated):
Installation root: /usr
Sysconf directory: /etc
Run directory (base): /run
Local state directory: /var

Internal paths:
Package data directory: /usr/share/icinga2
State path: /var/lib/icinga2/icinga2.state
Modified attributes path: /var/lib/icinga2/modified-attributes.conf
Objects path: /var/cache/icinga2/icinga2.debug
Vars path: /var/cache/icinga2/icinga2.vars
PID path: /run/icinga2/

Icinga Web 2 2.11.0
Git Commit 46998464ea9f9e3c2889d98f9fb6df639d972550
PHP Version 7.3.29
director 1.9.1
incubator 0.17.0
jira 1.2.1
monitoring 2.11.0
reactbundle 0.9.0
translation 2.11.0


You should upgrade again to v2.11.1 :wink:

Oof thanks, dont saw that issue after hours of searching. .