[GH-ISSUE #2034] [Bug]: Smart Playlist cannot find new songs #1074

Closed
opened 2026-02-26 02:35:09 +03:00 by kerem · 1 comment
Owner

Originally created by @realrolfje on GitHub (Jul 26, 2025).
Original GitHub issue: https://github.com/koel/koel/issues/2034

Originally assigned to: @phanan on GitHub.

Read the Troubleshooting guide.

  • I have read and followed the Troubleshooting guide

Reproduction steps

When importing new songs, I like to have a playlist which can easily find them. To do that, I'd like to create a playlist where "playcount is less than 1". In the current version of Koel, that does not return any songs.

I suspect that this is because the play count is "null" instead of a number, and the comparison in the smart playlist fails.

As a workaround I tried "song not played in the last 9999 days" but that also does not work, probably for the same reason.

Expected behavior

Smart playlist should be able to find newly imported songs which are never played by selecting "playcount is less than 1"

Actual behavior

The playlist returns no songs at all.
When selecting "playcount less than 2", I do see all the songs which are played exectly once.

Logs

No response

Koel version

7.10.3 community edition

How did you install Koel?

Official Docker image

Additional information

Docker image in a docker compose file, connecting to a dockerized MySQL. Otherwise workign (and looking) fine. Thanks for creating Koel!

Originally created by @realrolfje on GitHub (Jul 26, 2025). Original GitHub issue: https://github.com/koel/koel/issues/2034 Originally assigned to: @phanan on GitHub. ### Read the Troubleshooting guide. - [x] I have read and followed the Troubleshooting guide ### Reproduction steps When importing new songs, I like to have a playlist which can easily find them. To do that, I'd like to create a playlist where "playcount is less than 1". In the current version of Koel, that does not return any songs. I suspect that this is because the play count is "null" instead of a number, and the comparison in the smart playlist fails. As a workaround I tried "song not played in the last 9999 days" but that also does not work, probably for the same reason. ### Expected behavior Smart playlist should be able to find newly imported songs which are never played by selecting "playcount is less than 1" ### Actual behavior The playlist returns no songs at all. When selecting "playcount less than 2", I do see all the songs which are played exectly once. ### Logs _No response_ ### Koel version 7.10.3 community edition ### How did you install Koel? Official Docker image ### Additional information Docker image in a docker compose file, connecting to a dockerized MySQL. Otherwise workign (and looking) fine. Thanks for creating Koel!
kerem closed this issue 2026-02-26 02:35:09 +03:00
Author
Owner

@phanan commented on GitHub (Jul 26, 2025):

Thanks for reporting! I will take a look.

<!-- gh-comment-id:3122185455 --> @phanan commented on GitHub (Jul 26, 2025): Thanks for reporting! I will take a look.
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#1074
No description provided.