- This topic has 8 replies, 3 voices, and was last updated 13 years, 2 months ago by shark64.
9th November 2007 at 3:24 pm #1923
I have created a Static Playlist via the Firefly playlist webpage. I want to edit it. Does it exist on the disc anywhere?9th November 2007 at 3:59 pm #14300
The playlists are in the database, so you need to execute some sql using sqlite.
bash-3.2# sqlite3 /opt/var/mt-daapd/songs3.db
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> .headers ON
sqlite> select * from playlists;
3|Muse - Black Holes & Revelations|1|11|artist = "Muse" AND album includes "Black"|0||0
4|Prince - Planet Earth|1|10|artist = "Prince" and album ="Planet Earth"|0||0
5|Moby - Play|1|18|artist="Moby" and album="Play"|0||0
6|Jamelia - Thank You|1|14|artist="Jamelia" and album="Thank You"|0||0
7|Coldplay - X & Y|1|13|artist="Coldplay" and album="X & Y"|0||0
8|KT Tunstall - Eye to the telescope|1|12|artist="KT Tunstall" and album="Eye to the Telescope"|0||0
10|Jack Johnson|1|15|artist="Jack Johnson"|0||0
11|Lily Allen - Alright Still|1|11|Artist = "Lily Allen" and album = "Alright, S
14|The Rolling Stone Magazines 500 Greatest Songs Of All Time|1|501|album includes "The Rolling Stone Magazines 500 Greatest Songs Of All Time"|0||0
You can then issue an update set query=’xxxxx’ where id=x9th November 2007 at 4:39 pm #14301
Ouch 🙁9th November 2007 at 4:43 pm #143029th November 2007 at 5:40 pm #14303
That was a reaction to the solution not your playlist. 😉
Is that the “sql” for a static playlist?9th November 2007 at 6:03 pm #14304
Sorry, a static playlist is an .m3u file that is parsed by firefly.
In my example, if have podcast.m3u which is just a list of mp3 files.
bash-3.2# cat podcast.m3u
so you could you just edit the m3u file9th November 2007 at 7:45 pm #14305
Yes. But I created this static playlist thru the hidden “playlist” page so I have no idea where I can edit it.9th November 2007 at 9:36 pm #14306
Yes. But I created this static playlist thru the hidden “playlist” page so I have no idea where I can edit it.
Sorry again,I now understand.
they are stored in the database in playlistitems.
I wrote this sql to retrieve them
sqlite> select p.id,p.title,songid,s.path from playlistitems l inner join playlists p on l.playlistid=p.id inner join songs s on s.id=l.songid;
17|podcast|2551|/share/hdd/data/public/mp3/iTunes Music/Lily Allen/Alright, Still/07 Shame For You.m4a
17|podcast|1638|/share/hdd/data/public/mp3/iTunes Music/KT Tunstall/Eye to the Telescope/06 Silent Sea.m4a
17|podcast|1635|/share/hdd/data/public/mp3/iTunes Music/KT Tunstall/Eye to the Telescope/03 Under the Weather.m4a
17|podcast|1633|/share/hdd/data/public/mp3/iTunes Music/KT Tunstall/Eye to the Telescope/01 Other Side of the World.m4a
17|podcast|1361|/share/hdd/data/public/mp3/iTunes Music/Jean-Michel Jarre/Equinoxe/06 Equinoxe Part 6.mp3
17|podcast|1359|/share/hdd/data/public/mp3/iTunes Music/Jean-Michel Jarre/Equinoxe/04 Equinoxe Part 4.mp3
17|podcast|1357|/share/hdd/data/public/mp3/iTunes Music/Jean-Michel Jarre/Equinoxe/02 Equinoxe Part 2.mp3
17|podcast|1356|/share/hdd/data/public/mp3/iTunes Music/Jean-Michel Jarre/Equinoxe/01 Equinoxe Part 1.mp3
playlistitems has the following structure
sqlite> .schema playlistitems
CREATE TABLE playlistitems (
id INTEGER PRIMARY KEY NOT NULL,
playlistid INTEGER NOT NULL,
songid INTEGER NOT NULL
so you need to add/remove rows in that table – not for the faint hearted 🙂
Does pressing delete on the song not work ?
Dragging a song to a playlist will add it I found.29th February 2008 at 7:48 pm #14307shark64Guest
From reading the above it appears that maybe the best way to get rid of the static playlist is to do some sort of database rebuilt. Will a full scan do this or do I have to uninstall firefly and then reinstall from scratch? Seems like a lot of trouble to delete a few static playlists but if that is the only way then so be it.
- The forum ‘Setup Issues’ is closed to new topics and replies.