Sorting on BPM within playlist blanks results

[peacock]

Please fill in this bug report template:

Lexicon version: 1.8.7
Operating system (remove one): Windows 11

Bug description: When sorting a playlist on BPM, no results are shown. You only see the songs in the list when it’s not sorted on bpm.

Step by step to reproduce: open a playlist and sort in on bpm

Screenshot:
Not sorted:

Sorted:

[Christiaan]

Can you upload your Lexicon database & logs? From the Help menu.
I’ll take a look

[peacock]

done.

[Christiaan]

Thanks, checking on monday!

[Christiaan]

Checked it; your database is corrupt but I was able to recover it. You can use the following database backup: https://drive.google.com/file/d/1Y9Ip9aB57qV5io6JwhCaLonhvjEYjy-M/view?usp=sharing

Let me know when you downloaded it and I’ll delete the link.

[peacock]

Thank you, just downloaded it.

I have an event this saturday so I’m going to wait to try anything untill next week.
I’ve been working in RB for preperation, I assume I can restore this database of lexicon and then import from RB, so I don’t lose any work?

Would this also solve the issue I have with the sync? SqliteError: database disk image is malformed when syncing to rekordbox - #2 by peacock

[Christiaan]

Yeah you can do that, no problem. Yes I think that is the same issue

[peacock]

OK I’ll give you an update when I’ve been able to try it.

Any ideas on what got the database to be corrupted so I can try and avoid it in the future?
Or maybe a nice feature would be an automatic repair attempt?

[Christiaan]

Could be power loss, hard disk error or failure and a few other reasons