Hey guys/Girls,
My librenms install has been not updated for over a year (totally my fault for not looking in to it earlier) after solving some issues concerning daily.sh the install is now up to date ( i think) however the validate.php gives me the following error:
| Component | Version |
|---|---|
| LibreNMS | 1.65-19-ge5bb6d8 |
| DB Schema | 2020_03_25_165300_add_column_to_ports (162) |
| PHP | 7.2.31-1+ubuntu16.04.1+deb.sury.org+1 |
| Python | 3.5.2 |
| MySQL | 10.0.38-MariaDB-0ubuntu0.16.04.1 |
| RRDTool | 1.5.5 |
| SNMP | NET-SNMP 5.7.3 |
| ==================================== |
[OK] Composer Version: 1.10.8
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
Off course i tried running ./lnms migrate however the migrat script craps out on
-
Application In Production! *
Do you really wish to run this command? (yes/no) [no]:
yes
Migrating: 2020_04_06_001048_the_great_index_rename
In Connection.php line 669:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘deleted’; check that column/key exists (SQL: ALTER TABLE access_points DROP INDEX deleted, ADD INDEX access_points_deleted_index(deleted)
In PDOStatement.php line 129:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘deleted’; check that column/key exists
In PDOStatement.php line 127:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘deleted’; check that column/key exists
Now i tried running “SQL: ALTER TABLE access_points DROP INDEX deleted, ADD INDEX access_points_deleted_index(deleted);”
however this throws error:
-bash: syntax error near unexpected token `(’
I must be doing something wrong but cannot find out what any assistance is welcome.
(please note i am a moderate linux user at best and sql Is almost a total stranger to me)