Database: incorrect column (notifications/datetime)


I run LibreNMS voor a few years now on a Centos 8 VM. Today i have to do a yum update because many patches need to be installed/upgraded.

After the yum update everything looks fine. LibreNMS Webgui is working with no errors.
But when i do a ./validate.php i see de following output:


Component Version
LibreNMS 21.9.0
DB Schema 2021_25_01_0129_isis_adjacencies_nullable (217)
PHP 7.4.23
Python 3.6.8
MySQL 10.3.28-MariaDB
RRDTool 1.7.0


[OK] Composer Version: 2.1.6
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Database: incorrect column (notifications/datetime)
[FAIL] Database: incorrect column (users/created_at)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord ( or the community site (
Run the following SQL statements to fix.
SQL Statements:
SET TIME_ZONE=’+00:00’;
ALTER TABLE notifications CHANGE datetime datetime timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:00’ ;
ALTER TABLE users CHANGE created_at created_at timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:01’ ;

I have not change my timezone by myself but maybe the yum update did. I have use the SQL statements to fix the problem, but that doesn’t help.

Local time: Mon 2021-09-20 14:22:47 CEST
Universal time: Mon 2021-09-20 12:22:47 UTC
RTC time: Mon 2021-09-20 12:22:47
Time zone: Europe/Amsterdam (CEST, +0200)
System clock synchronized: yes
NTP service: active
RTC in local TZ: no

Kind regards,

Jorg Schrievers

Not entirely sure myself, but if you run the sql, the message goes away.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.