[GH-ISSUE #422] 1000 song limit in playlists #299

Closed
opened 2026-02-26 02:32:44 +03:00 by kerem · 22 comments
Owner

Originally created by @ronilaukkarinen on GitHub (Aug 24, 2016).
Original GitHub issue: https://github.com/koel/koel/issues/422

Added whole lot of a songs to a playlist, but after I rescanned my library, I had exactly 1000 songs on the playlist. Before there were over 7000 songs on that list. Does koel have some limit?

Version: Koel 3.3.0
Screenshot

Originally created by @ronilaukkarinen on GitHub (Aug 24, 2016). Original GitHub issue: https://github.com/koel/koel/issues/422 Added whole lot of a songs to a playlist, but after I rescanned my library, I had exactly 1000 songs on the playlist. Before there were over 7000 songs on that list. Does koel have some limit? Version: Koel 3.3.0 [Screenshot](https://dl.dropboxusercontent.com/u/18447700/Screen%20Shot%202016-08-24%20at%2014.47.57.png)
kerem closed this issue 2026-02-26 02:32:44 +03:00
Author
Owner

@BernardGoldberger commented on GitHub (Aug 24, 2016):

I have playlists with more than 1,000 songs.

I would say that for some reason it seems like the songs have gotten a new ID when you scanned them again, to test this you can do the following, filter the playlist id in the playlist_song table in your DB, and check how many rows there are.

<!-- gh-comment-id:242075933 --> @BernardGoldberger commented on GitHub (Aug 24, 2016): I have playlists with more than 1,000 songs. I would say that for some reason it seems like the songs have gotten a new ID when you scanned them again, to test this you can do the following, filter the playlist id in the `playlist_song` table in your DB, and check how many rows there are.
Author
Owner

@phanan commented on GitHub (Aug 26, 2016):

No, Koel doesn't have such a limitation. Can you try what @bdgold said and see how many rows there are in the DB?

<!-- gh-comment-id:242642421 --> @phanan commented on GitHub (Aug 26, 2016): No, Koel doesn't have such a limitation. Can you try what @bdgold said and see how many rows there are in the DB?
Author
Owner

@ronilaukkarinen commented on GitHub (Sep 15, 2016):

Sorry for this taking so long, been busy... I have 2243 rows in playlist_song. But still seeing exactly 1000 in the front end side. It doesn't grow if I add a song.

<!-- gh-comment-id:247242939 --> @ronilaukkarinen commented on GitHub (Sep 15, 2016): Sorry for this taking so long, been busy... I have 2243 rows in `playlist_song`. But still seeing exactly 1000 in the front end side. It doesn't grow if I add a song.
Author
Owner

@BernardGoldberger commented on GitHub (Sep 15, 2016):

It might sound like a stupid question, but how do know it only lists 1,000 songs? is it because the stat says so? or did you go to check if a recent added song is there?

<!-- gh-comment-id:247303538 --> @BernardGoldberger commented on GitHub (Sep 15, 2016): It might sound like a stupid question, but how do know it only lists 1,000 songs? is it because the stat says so? or did you go to check if a recent added song is there?
Author
Owner

@ronilaukkarinen commented on GitHub (Sep 15, 2016):

Good question! why I didn't check that before, I don't know... just assumed. Yes, they show up when I use search. And in fact, the number updates when I add the songs, but when I remove them, it shows 1001. Something wrong with the number.

<!-- gh-comment-id:247306009 --> @ronilaukkarinen commented on GitHub (Sep 15, 2016): Good question! why I didn't check that before, I don't know... just assumed. Yes, they show up when I use search. And in fact, the number updates when I **add** the songs, but when I remove them, it shows 1001. Something wrong with the number.
Author
Owner

@BernardGoldberger commented on GitHub (Sep 15, 2016):

Does the issue repeat itself with new playlists?

<!-- gh-comment-id:247310759 --> @BernardGoldberger commented on GitHub (Sep 15, 2016): Does the issue repeat itself with new playlists?
Author
Owner

@phanan commented on GitHub (Sep 15, 2016):

And in fact, the number updates when I add the songs, but when I
remove them, it shows 1001

That's weird :D Can you record a gif?

On Thu, Sep 15, 2016 at 8:10 PM, bdgold notifications@github.com wrote:

Does the issue repeat itself with new playlists?


You are receiving this because you modified the open/close state.
Reply to this email directly, view it on GitHub
https://github.com/phanan/koel/issues/422#issuecomment-247310759, or mute
the thread
https://github.com/notifications/unsubscribe-auth/AHrt0lCAyGWKBmhqpenetlTbqxE1mOp6ks5qqTWwgaJpZM4Jr7G1
.

<!-- gh-comment-id:247321454 --> @phanan commented on GitHub (Sep 15, 2016): > And in fact, the number updates when I _add_ the songs, but when I > remove them, it shows 1001 That's weird :D Can you record a gif? On Thu, Sep 15, 2016 at 8:10 PM, bdgold notifications@github.com wrote: > Does the issue repeat itself with new playlists? > > — > You are receiving this because you modified the open/close state. > Reply to this email directly, view it on GitHub > https://github.com/phanan/koel/issues/422#issuecomment-247310759, or mute > the thread > https://github.com/notifications/unsubscribe-auth/AHrt0lCAyGWKBmhqpenetlTbqxE1mOp6ks5qqTWwgaJpZM4Jr7G1 > .
Author
Owner

@BernardGoldberger commented on GitHub (Sep 15, 2016):

Remove? how do you remove a song from a playlist?

<!-- gh-comment-id:247326089 --> @BernardGoldberger commented on GitHub (Sep 15, 2016): Remove? how do you remove a song from a playlist?
Author
Owner

@phanan commented on GitHub (Sep 15, 2016):

You press Delete?

On Thu, Sep 15, 2016 at 9:21 PM, bdgold notifications@github.com wrote:

Remove? how do you remove a song from a playlist?


You are receiving this because you modified the open/close state.
Reply to this email directly, view it on GitHub
https://github.com/phanan/koel/issues/422#issuecomment-247326089, or mute
the thread
https://github.com/notifications/unsubscribe-auth/AHrt0px9PEUompDns15XONaKen_s2axFks5qqUZqgaJpZM4Jr7G1
.

<!-- gh-comment-id:247326580 --> @phanan commented on GitHub (Sep 15, 2016): You press Delete? On Thu, Sep 15, 2016 at 9:21 PM, bdgold notifications@github.com wrote: > Remove? how do you remove a song from a playlist? > > — > You are receiving this because you modified the open/close state. > Reply to this email directly, view it on GitHub > https://github.com/phanan/koel/issues/422#issuecomment-247326089, or mute > the thread > https://github.com/notifications/unsubscribe-auth/AHrt0px9PEUompDns15XONaKen_s2axFks5qqUZqgaJpZM4Jr7G1 > .
Author
Owner

@BernardGoldberger commented on GitHub (Sep 15, 2016):

Thats to delete the playlist, not to remove a song from the playlist.

<!-- gh-comment-id:247326905 --> @BernardGoldberger commented on GitHub (Sep 15, 2016): Thats to delete the playlist, not to **remove a song** from the playlist.
Author
Owner

@BernardGoldberger commented on GitHub (Sep 15, 2016):

Oh, I see, I have to use the keyboard Del key.

Should probably put in a feature request.

<!-- gh-comment-id:247327329 --> @BernardGoldberger commented on GitHub (Sep 15, 2016): Oh, I see, I have to use the keyboard Del key. Should probably put in a feature request.
Author
Owner

@phanan commented on GitHub (Sep 15, 2016):

No? You can select songs in the playlist and press Delete normally.

On Thu, Sep 15, 2016 at 9:27 PM, bdgold notifications@github.com wrote:

Oh, I see, I have to use the keyboard Del key.

Should probably put in a feature request.


You are receiving this because you modified the open/close state.
Reply to this email directly, view it on GitHub
https://github.com/phanan/koel/issues/422#issuecomment-247327329, or mute
the thread
https://github.com/notifications/unsubscribe-auth/AHrt0iYb4mpsjmu4UbLKFlVG7UU057f1ks5qqUevgaJpZM4Jr7G1
.

<!-- gh-comment-id:247327699 --> @phanan commented on GitHub (Sep 15, 2016): No? You can select songs in the playlist and press Delete normally. On Thu, Sep 15, 2016 at 9:27 PM, bdgold notifications@github.com wrote: > Oh, I see, I have to use the keyboard Del key. > > Should probably put in a feature request. > > — > You are receiving this because you modified the open/close state. > Reply to this email directly, view it on GitHub > https://github.com/phanan/koel/issues/422#issuecomment-247327329, or mute > the thread > https://github.com/notifications/unsubscribe-auth/AHrt0iYb4mpsjmu4UbLKFlVG7UU057f1ks5qqUevgaJpZM4Jr7G1 > .
Author
Owner

@BernardGoldberger commented on GitHub (Sep 15, 2016):

@phanan, I just did some tests on the playlists including favorites and noticed that there are some major bugs when selecting the song within the playlist, might be related or unrelated to the users issue.

Whenever sorting is changed in a playlist selecting becomes messed up, I attached a gif [it a long gif] where I do he following

  1. Create a playlist
  2. Drag some songs in
  3. Verify selection works.
  4. Delete 3 songs and verify the number changes [I use the keyboard to delete].
  5. Change sorting.
  6. Selecting is now messed up.

If you miss it the first time don' worry, I repeat it.

playlists

@ronilaukkarinen Maybe when you are removing songs you are not actually removing them all since they are not all selected as you might have thought.

<!-- gh-comment-id:247381405 --> @BernardGoldberger commented on GitHub (Sep 15, 2016): @phanan, I just did some tests on the playlists including favorites and noticed that there are some major bugs when selecting the song within the playlist, might be related or unrelated to the users issue. Whenever sorting is changed in a playlist selecting becomes messed up, I attached a gif [it a long gif] where I do he following 1. Create a playlist 2. Drag some songs in 3. Verify selection works. 4. Delete 3 songs and verify the number changes [I use the keyboard to delete]. 5. Change sorting. 6. Selecting is now messed up. If you miss it the first time don' worry, I repeat it. ![playlists](https://cloud.githubusercontent.com/assets/10334679/18558120/df78b626-7b3f-11e6-9b85-8d29053f8c04.gif) @ronilaukkarinen Maybe when you are removing songs you are not actually removing them all since they are not all selected as you might have thought.
Author
Owner

@phanan commented on GitHub (Sep 15, 2016):

@bdgold: Yes it's a known issue.

On Fri, Sep 16, 2016 at 12:36 AM, bdgold notifications@github.com wrote:

@phanan https://github.com/phanan, I just did some tests on the
playlists including favorites and noticed that there are some major bugs
when selecting the song within the playlist, might be related or unrelated
to the users issue.

Whenever sorting is changed in a playlist selecting becomes messed up, I
attached a gif [it a long gif] where I do he following

  1. Create a playlist
  2. Drag some songs in
  3. Verify selection works.
  4. Delete 3 songs and verify the number changes.
  5. Change sorting.
  6. Selecting is now messed up.

If you miss it the first time don' worry, I repeat it.

[image: playlists]
https://cloud.githubusercontent.com/assets/10334679/18558120/df78b626-7b3f-11e6-9b85-8d29053f8c04.gif

@ronilaukkarinen https://github.com/ronilaukkarinen Maybe when you are
removing songs you are not actually removing them all since they are not
all selected as you might have thought.


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
https://github.com/phanan/koel/issues/422#issuecomment-247381405, or mute
the thread
https://github.com/notifications/unsubscribe-auth/AHrt0jJoPKoDOjHDGXvmSF7vvTEXtrAFks5qqXP2gaJpZM4Jr7G1
.

<!-- gh-comment-id:247389566 --> @phanan commented on GitHub (Sep 15, 2016): @bdgold: Yes it's a known issue. On Fri, Sep 16, 2016 at 12:36 AM, bdgold notifications@github.com wrote: > @phanan https://github.com/phanan, I just did some tests on the > playlists including favorites and noticed that there are some major bugs > when selecting the song within the playlist, might be related or unrelated > to the users issue. > > Whenever sorting is changed in a playlist selecting becomes messed up, I > attached a gif [it a long gif] where I do he following > 1. Create a playlist > 2. Drag some songs in > 3. Verify selection works. > 4. Delete 3 songs and verify the number changes. > 5. Change sorting. > 6. Selecting is now messed up. > > If you miss it the first time don' worry, I repeat it. > > [image: playlists] > https://cloud.githubusercontent.com/assets/10334679/18558120/df78b626-7b3f-11e6-9b85-8d29053f8c04.gif > > @ronilaukkarinen https://github.com/ronilaukkarinen Maybe when you are > removing songs you are not actually removing them all since they are not > all selected as you might have thought. > > — > You are receiving this because you were mentioned. > Reply to this email directly, view it on GitHub > https://github.com/phanan/koel/issues/422#issuecomment-247381405, or mute > the thread > https://github.com/notifications/unsubscribe-auth/AHrt0jJoPKoDOjHDGXvmSF7vvTEXtrAFks5qqXP2gaJpZM4Jr7G1 > .
Author
Owner

@BernardGoldberger commented on GitHub (Sep 15, 2016):

@phanan I want to clarify that this is a different issue than https://github.com/phanan/koel/issues/427, my issue does not happen in the song, album or artist view.

<!-- gh-comment-id:247415889 --> @BernardGoldberger commented on GitHub (Sep 15, 2016): @phanan I want to clarify that this is a different issue than https://github.com/phanan/koel/issues/427, my issue does not happen in the song, album or artist view.
Author
Owner

@phanan commented on GitHub (Sep 25, 2016):

@bdgold Sorry, I missed this. Can you report this as a separate issue? Thanks!

<!-- gh-comment-id:249424182 --> @phanan commented on GitHub (Sep 25, 2016): @bdgold Sorry, I missed this. Can you report this as a separate issue? Thanks!
Author
Owner

@ronilaukkarinen commented on GitHub (Nov 8, 2016):

This still doesn't work properly, I can't trust my playlists.

Just added 1200 songs on the list, renamed the playlist, waited a bit, refreshed the page = playlist is in the old name and all my changes are gone. I have now 724 songs on the playlist and it doesn't make any sense.

I have sometimes a quite slow Internet connection at home and koel is hosted on my home server, so that may explain the things if songs are not added in real time, for example if I add 200 songs at once? that would also explain the name not updating if it's stuck in "buffer" and doesn't complete in time before I reload the page?

Really needs optimization. For me playlists are right now useless feature.

Feature suggestion for playlists: Spotify-like ("already on the list - skip/add anyway") possible?

Thanks for the effort so far 👍 (have to give credit for the good work to not just complain and demand features... ;) )

<!-- gh-comment-id:259100374 --> @ronilaukkarinen commented on GitHub (Nov 8, 2016): This still doesn't work properly, I can't trust my playlists. Just added 1200 songs on the list, renamed the playlist, waited a bit, refreshed the page = playlist is in the old name and all my changes are gone. I have now 724 songs on the playlist and it doesn't make any sense. I have sometimes a quite slow Internet connection at home and koel is hosted on my home server, so that may explain the things if songs are not added in real time, for example if I add 200 songs at once? that would also explain the name not updating if it's stuck in "buffer" and doesn't complete in time before I reload the page? Really needs optimization. For me playlists are right now useless feature. Feature suggestion for playlists: Spotify-like ("already on the list - skip/add anyway") possible? Thanks for the effort so far 👍 (have to give credit for the good work to not just complain and demand features... ;) )
Author
Owner

@ronilaukkarinen commented on GitHub (Nov 8, 2016):

Oh and when I scroll the playlist, I see about 50 songs and not more regardless how much I scroll, looks like really short list. But when I shuffle them all to my play queue, I see many many songs.

<!-- gh-comment-id:259100908 --> @ronilaukkarinen commented on GitHub (Nov 8, 2016): Oh and when I scroll the playlist, I see about 50 songs and not more regardless how much I scroll, looks like really short list. But when I shuffle them all to my play queue, I see many many songs.
Author
Owner

@phanan commented on GitHub (Nov 8, 2016):

@ronilaukkarinen Right now songs are added into playlists without a feedback, with the assumption of a quick task. I think I'll add the "loading" (YouTube-like) for a better UX. For the second issue, does it happen with a full page reload?

<!-- gh-comment-id:259103942 --> @phanan commented on GitHub (Nov 8, 2016): @ronilaukkarinen Right now songs are added into playlists without a feedback, with the assumption of a quick task. I think I'll add the "loading" (YouTube-like) for a better UX. For the second issue, does it happen with a full page reload?
Author
Owner

@ronilaukkarinen commented on GitHub (Nov 8, 2016):

By second issue you mean name not changing, yes, with a full page reload the name often changes back to previous one (at least when I'm adding songs). If you mean only 50 songs displaying, that seemed to be temporary, full page reload helped. Thanks.

EDIT: Correction, it loads up now about 200 songs, but cannot load further... very strange.

<!-- gh-comment-id:259104485 --> @ronilaukkarinen commented on GitHub (Nov 8, 2016): By second issue you mean name not changing, yes, with a full page reload the name often changes back to previous one (at least when I'm adding songs). If you mean only 50 songs displaying, that seemed to be temporary, full page reload helped. Thanks. EDIT: Correction, it loads up now about 200 songs, but cannot load further... very strange.
Author
Owner

@phanan commented on GitHub (Nov 28, 2016):

@ronilaukkarinen I've added a loading bar on top of the screen. Can you try repeating what you did and see if it's because the requests hadn't completed?

<!-- gh-comment-id:263215123 --> @phanan commented on GitHub (Nov 28, 2016): @ronilaukkarinen I've added a loading bar on top of the screen. Can you try repeating what you did and see if it's because the requests hadn't completed?
Author
Owner

@phanan commented on GitHub (Jan 14, 2017):

Closing due to inactivity.

<!-- gh-comment-id:272628052 --> @phanan commented on GitHub (Jan 14, 2017): Closing due to inactivity.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/koel-koel#299
No description provided.