Playlist order is incorrect

[vifly]

Describe the bug
When I start playing an album, the order of the songs in the playlist is not the same as the album. For example, in screenshot 2, the first song on the album is Wake Up, Get Up, Get Out There, But the first song in the playlist is the 15th song on the album King, Queen and Slave -another version-. (See screenshot 3)

To Reproduce
Steps to reproduce the behavior:

1. Click start playing (screenshot 1)
2. See order is not same (screenshot 3)

Expected behavior
Songs should be in the same order in the album as in the playlist.

Screenshots

Desktop:

• OS: Arch Linux
• Version: 1.1.0 (From archlinuxcn repo)

[dosubot]

Hi @vifly! I'm Dosu and I’m helping the rune team.

This issue happens because the backend doesn't explicitly order album tracks by their track number when building the playlist. Instead, tracks are returned in an undefined order, which causes the playlist to not match the album sequence. The fix is to update the backend logic to always order tracks by their track_number field when fetching songs for an album. This field is present in the media_file_albums entity and should be used to guarantee the correct order in queries that assemble album contents. No existing tickets or discussions were found about this issue, and there haven't been recent changes affecting playlist ordering. For a fix, look for the backend code that fetches album tracks and add an explicit ORDER BY track_number to the relevant queries.
See supporting code details

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}   

[Losses]

Oh gosh... I'll check it after the sync system fully implemented, thank you for the report!!