We have auto update turned off on our prod Librenms
I tried maually updating today from 1.56 to 1.65
I did :
git pull https://github.com/librenms/librenms 1.65
./scripts/composer_wrapper.php install --no-dev
However I got somme errors, same as someone else reported here : /t/lnms-migrate-fails/12335
In Connection.php line 669: SQLSTATE: 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: Syntax error or access violation: 1091 Can’t DROP ‘deleted’; check that column/key exists
PDOStatement.php line 127: SQLSTATE: Syntax error or access violation: 1091 Can’t DROP ‘deleted’; check that column/key exists
lnms migrate did not solve the pb
So I did what was recommended by the previously mentioned bug report :
insert into migrations (migration, batch) VALUES (“2020_04_06_001048_the_great_index_rename”, 1);
and manually run the ~100+ SQL statements
Now LibreNMS is working but still reporting as v1.56 in GUI and by validate.php :
-bash-4.2$ git pull https://github.com/librenms/librenms 1.65
- tag 1.65 -> FETCH_HEAD
|DB Schema||2020_06_23_00522_alter_availability_perc_column (170)|
[OK] Composer Version: 1.10.9
[OK] Dependencies up-to-date.
[OK] Database connection successful
Nothing to migrate.
What can I do to fix?