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