Hello
SQL error when ./validate.php :
root@librenms:/opt/librenms# ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 1.65-36-g0e9658987 |
| DB Schema | 2020_06_23_00522_alter_availability_perc_column (170) |
| PHP | 7.4.3 |
| Python | 3.8.2 |
| MySQL | 10.3.22-MariaDB-1ubuntu1 |
| RRDTool | 1.7.2 |
| SNMP | NET-SNMP 5.8 |
| ==================================== |
[OK] Composer Version: 1.10.9
[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 (LibreNMS) or the community site (Report database schema issues here - LibreNMS Community):
[FIX]:
Run the following SQL statements to fix.
SQL Statements:
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’ ;
sh: 1: pip3: not found
I tryed to resolv with this topic : Database: incorrect column error
But it was not helpful 
