Playlists location?

Need help? Post your questions here.

Moderator: moderators

Playlists location?

Postby gberg » Wed May 05, 2021 7:23 am

Where are playlists stored on a Ubuntu Subsonic installation?
In the config file /var/subsonic/subsonic.properties I see this line: PlaylistFolder=/var/playlists, but there are no playlist files i that folder?
gberg
 
Posts: 2
Joined: Tue May 04, 2021 7:39 am

Re: Playlists location?

Postby acroyear » Wed May 05, 2021 5:08 pm

they're in the database.

using /db.view

select * from playlist
gets you the playlist id

select * from playlist_file where id = 3
gets you the songs (in order) for the playlist - those are 'media_file_id'

join that to media file
select * from playlist_file pf, media_file mf where pf.playlist_id = 3 and pf.media_file_id = mf.id

and there's your contents
--
Joe Shelby
http://subfiresuite.com/
http://subfireplayer.net/
User avatar
acroyear
 
Posts: 721
Joined: Wed Mar 27, 2013 8:05 pm
Location: Northern, VA

Re: Playlists location?

Postby gberg » Wed May 05, 2021 5:30 pm

Ok, thanks!
But what's the line: PlaylistFolder=/var/playlists for then?
gberg
 
Posts: 2
Joined: Tue May 04, 2021 7:39 am

Re: Playlists location?

Postby acroyear » Tue May 11, 2021 11:00 pm

legacy. i think it was how playlists used to be managed in an earlier version.
--
Joe Shelby
http://subfiresuite.com/
http://subfireplayer.net/
User avatar
acroyear
 
Posts: 721
Joined: Wed Mar 27, 2013 8:05 pm
Location: Northern, VA

Re: Playlists location?

Postby Jägs » Wed May 12, 2021 1:32 am

But what's the line: PlaylistFolder=/var/playlists for then?


It's also where Subsonic looks for playlists to import (by default).
Jägs
 
Posts: 98
Joined: Wed Apr 06, 2011 9:52 pm


Return to Help

Who is online

Users browsing this forum: No registered users and 17 guests