navidrome / navidrome

🎧☁️ Modern Music Server and Streamer compatible with Subsonic/Airsonic
https://www.navidrome.org
GNU General Public License v3.0
10.63k stars 806 forks source link

Random sort changes each time you switch pages #749

Closed markasoftware closed 1 year ago

markasoftware commented 3 years ago

In random sort mode, clicking the next page button changes the random ordering, so some of the same albums show up. Maybe a random seed should be stored in the url?

SteveDinn commented 3 years ago

I posted about this on the discord several weeks back. Should have logged a bug :)

I don't think there's any point in having the random section paginated because it doesn't make any sense. Any "next" or "previous" page is just another first page of a random query.

deluan commented 3 years ago

Thanks for opening this. There's no simple (and performant) way to use a seed in a random sorted SQLite3 query. I did some research, there are some hacks, but they are not performant. Will keep this open if someone has any ideas.

AeronCyther commented 3 years ago

I think I have a potential solution for this.

github-actions[bot] commented 1 year ago

This issue has been automatically marked as stale because it has not had recent activity. The resources of the Navidrome team are limited, and so we are asking for your help. If this is a bug and you can still reproduce this error on the master branch, please reply with all of the information you have about it in order to keep the issue open. If this is a feature request, and you feel that it is still relevant and valuable, please tell us why. This issue will automatically be closed in the near future if no further activity occurs. Thank you for all your contributions.

github-actions[bot] commented 11 months ago

This issue has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.