Some columns in external playlists (iTunes, Traktor, ...) cannot be sorted (initially)

[fwcd]

Bug Description

To reproduce:

• Open Mixxx
• Open a playlist in an iTunes or Traktor library
• Sort by BPM
• The table will not sort correctly and the log will emit

warning [Main] BaseSqlTableModel::setSort invalid column: 14

Now, interestingly, once the user sorts by artist or title, the sort by BPM will work correctly and the issue seems to be 'fixed' for the rest of the session. So there's probably something strange in the way the table is initialized.

This issue also seems to be rather old, it occurs on recent 2.4 and main builds all the way back to at least f67460d (probably longer).

Version

2.4-alpha-1426-g45eb0bbddf

OS

macOS 13.3.1

[fwcd]

Sorting by the # column is also broken and doesn't do anything at all even after the 'fix'.

Edit: This will be fixed by #11498

[fwcd]

Fixed with

• iTunes: Factor out ITunesPlaylistModel and fix sort column mapping #11498
• BaseSqlTableModel: Fix bounds check #11499