This solution has resolved the issue for me and I hope it helps you too.
-
- Create a backup of your database.
-
- Open DB Browser for SQLite and select the “m.db” database.
-
- Go to the “Track” table and check if the “lexiconId” column exists to determine if this is the specific issue you are facing.
-
- Go to the “Execute SQL” tab and run the following commands:
DROP INDEX index_Track_lexiconId;
ALTER TABLE Track DROP COLUMN lexiconId;
-
- If there are no errors, save the changes and test the database.