Hi,
I have an extrange DB schema error.
Already tried to run sql queries, with no luck.
Can you please help me?
-bash-4.2$ ./validate.php
Component | Version |
---|---|
LibreNMS | 1.54-33-g67376e2 |
DB Schema | 2019_07_09_150217_update_users_widgets_settings (140) |
PHP | 7.2.19 |
MySQL | 5.5.60-MariaDB |
RRDTool | 1.6.0 |
SNMP | NET-SNMP 5.7.2 |
====================================
[OK] Composer Version: 1.9.0
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Database: incorrect column (ports_fdb/created_at)
[FAIL] Database: incorrect column (ports_fdb/updated_at)
[FAIL] We have detected that your database schema may be wrong, please report t he following to us on Discord (https://t.libren.ms/discord) or the community sit e (https://t.libren.ms/5gscd):
[FIX]:
Run the following SQL statements to fix.
SQL Statements:
ALTER TABLE ports_fdb
CHANGE created_at
created_at
timestamp NULL ;
ALTER TABLE ports_fdb
CHANGE updated_at
updated_at
timestamp NULL ;
–
MariaDB [librenms]> ALTER TABLE ports_fdb
CHANGE created_at
created_at
timestamp NULL;
ERROR 1054 (42S22): Unknown column ‘created_at’ in ‘ports_fdb’
MariaDB [librenms]> ALTER TABLE ports_fdb
CHANGE updated_at
updated_at
timestamp NULL;
ERROR 1054 (42S22): Unknown column ‘updated_at’ in ‘ports_fdb’
–
Best,
Eugenio