PlaylistsPath does not appear to work

[adamdmoss]

Description

I'm using
PlaylistsPath = "/music/playlists"
... but in the new Playlists sidebar I see every playlist in my library from outside that path too.

Expected Behaviour

Navidrome only sees the playlists under /music/playlists

Platform information

• Navidrome version: 0.46
• Browser and version: firefox 92.0
• Operating System: Raspbian GNU/Linux 9 / Linux volumio 5.10.25-v7+ Bump ra-data-json-server from 3.18.3 to 3.19.0 in /ui #1408 SMP Mon Mar 22 12:47:11 GMT 2021 armv7l GNU/Linux

[deluan]

The path(s) should be relative to the music folder. So if your MusicFolder is configured as /music then your PlaylistsPath should be simply playlists. Try that and let me know.

EDIT: Also make sure the variable is being read: Set LogLevel=debug and check the beginning of the logs, Navidrome spits out the configuration

[adamdmoss]

Oct  7 12:51:20 volumio navidrome[27227]: | \ | |           (_)   | |
Oct  7 12:51:20 volumio navidrome[27227]: |  \| | __ ___   ___  __| |_ __ ___  _ __ ___   ___
Oct  7 12:51:20 volumio navidrome[27227]: | . ` |/ _` \ \ / / |/ _` | '__/ _ \| '_ ` _ \ / _ \
Oct  7 12:51:20 volumio navidrome[27227]: | |\  | (_| |\ V /| | (_| | | | (_) | | | | | |  __/
Oct  7 12:51:20 volumio navidrome[27227]: \_| \_/\__,_| \_/ |_|\__,_|_|  \___/|_| |_| |_|\___|
Oct  7 12:51:20 volumio navidrome[27227]:                           Version: 0.46.0 (8bbb878b)
Oct  7 12:51:20 volumio navidrome[27227]: Loaded configuration from '/var/lib/navidrome/navidrome.toml': &conf.configOptions{
Oct  7 12:51:20 volumio navidrome[27227]:     ConfigFile:                 "/var/lib/navidrome/navidrome.toml",
...
Oct  7 12:51:20 volumio navidrome[27227]:     MusicFolder:                "/music",
Oct  7 12:51:20 volumio navidrome[27227]:     DataFolder:                 ".",
..
Oct  7 12:51:20 volumio navidrome[27227]:     LogLevel:                   "debug",
Oct  7 12:51:20 volumio navidrome[27227]:     AutoImportPlaylists:        true,
Oct  7 12:51:20 volumio navidrome[27227]:     PlaylistsPath:              "playlists",
...

Sadly it's still serving all the playlists in the music folder.
Does it have the concept of removing playlists that it can't see any more? Wondering if they're there just because it could 'see' them in an earlier version.

[deluan]

Ah, I see. This new config only tells Navidrome where to search for playlists when scanning, it does not touch playlists that were previously imported... You'd have to remove them using the UI, by selecting the ones you want to remove and clicking in "Delete"

[Gomez]

For me it added 7000 playlists :( Is there a way to remove all?

[deluan]

@Gomez Uff... to delete all these playlists at once (not page by page) you only have two options:

1. Delete from command line: sqlite3 ./data/navidrome.db 'delete from playlist'. Make sure you are using the correct path for your database. You'll need to install sqlite3 in your system. There's also some SQLite3 browsers available in the Net
2. Start from scratch by deleting the DB. If you don't have any custom data (users, starts) or don't mind losing them, this is the fastest solution

[certuna]

https://sqlitebrowser.org/

[adamdmoss]

That seems to have worked - thanks!

[Gomez]

1. Delete from command line: `sqlite3 ./data/navidrome.db 'delete from playlist'`. Make sure you are using the correct path for your database. You'll need to install sqlite3 in your system. There's also some SQLite3 browsers available in the Net

Thanks, this worked!

[zardini123]

1. sqlite3 ./data/navidrome.db 'delete from playlist'

This also worked for me. Though a caveat I had to deal with is that the playlists will not be accessible to previous admin users. To get around it, I made a second admin user, logged in there, removed admin rights of all other users, and re-gave them admin rights.

[Merkwurdichliebe]

I can't seem to make this option work either (macOS). I've tried both a full path and a relative path from the MusicFolder. The relative path is correct since I can cd into it from the MusicFolder in Terminal. When debugging I see the "PlaylistPath:" showing the string in my toml file, but no other mention of playlists loading or anything. I know the playlists are properly formatted, because if I remove the PlaylistsPath option from the toml file and just dump the m3u8 files in the MusicFolder, they are properly imported.

[github-actions]

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.