Validate.php fails
i have dropped the index and the error comes back
librenms@scarletwitch:~$ ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 25.3.0-20-gfb8c958b2 (2025-03-20T05:15:35-05:00) |
| DB Schema | 2024_10_20_154356_create_qos_table (309) |
| PHP | 8.3.6 |
| Python | 3.12.3 |
| Database | MariaDB 11.7.2-MariaDB-ubu2404 |
| RRDTool | 1.7.2 |
| SNMP | 5.9.4.pre2 |
| =========================================== |
[OK] Composer Version: 2.8.6
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
Attempt to fix this issue (y or n)?:y
In Connection.php line 829:
SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name ‘alert_log_device_id_rule_id_time_logged_index’ (Connection: mysql, SQL: alter table alert_log add index alert_log_device_id_rule_id_time_logged_index(d evice_id, rule_id, time_logged))
In Connection.php line 587:
SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name ‘alert_log_device_id_rule_id_time_logged_index’
If i drop the index the error changes to
In Connection.php line 829:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX alert_log_device_id_index; check that it exists (Connection: mysql, SQL: alter table alert_log drop index alert_log_device_id_index)
In Connection.php line 587:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX alert_log_device_id_index; check that it exists