Validate issue

I have a problem with validation:

[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
[FIX]:
Run the following SQL statements to fix it
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’

How to fix it?

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