Update failed 1.58 to 1.64.1 SQL-SCHEMA crashed

[bhaggu]

Got is solved by running script one by one manually.

Ref:

Your database is out of date! [FIX]: ./lnms migrate - error

Are you ran all of this SQL queries ? $ ./lnms migrate --pretend ************************************** * Application In Production! * ************************************** Do you really wish to run this command? (yes/no) [no]: > yes TheGreatIndexRename: ALTER TABLE access_points DROP INDEX deleted, ADD INDEX access_points_deleted_index(deleted); TheGreatIndexRename: ALTER TABLE alerts DROP INDEX device_id, ADD INDEX alerts_device_id_index(device_id); TheGreatIndexRename: ALTER TA…

Thanks
Bhaggu