Playlists Randomly Deleted

Need help? Post your questions here.

Moderator: moderators

Playlists Randomly Deleted

Postby CeePeeBee » Fri Feb 01, 2019 10:44 am

Hi all,

I logged into Subsonic this morning to play some music and I found that my playlists were all empty - zero songs.

Did a bit of digging and found this in the log:

Code: Select all
CONNECT USER SA
SET AUTOCOMMIT FALSE
DELETE FROM PLAYLIST WHERE ID=1
INSERT INTO PLAYLIST VALUES(1,'admin',TRUE,'Gym2017','',106,24145,'2017-06-10 13:14:05.233000000','2019-02-01 10:11:27.293000000',NULL)


Interestingly, this was my specific playlist I was interested in, but all other playlists are empty now too. 10:11 is around when I logged in too.

So, I took a look at the playlist itself on the db.view and it shows as below:

Code: Select all
ID    USERNAME    IS_PUBLIC    NAME    COMMENT    FILE_COUNT    DURATION_SECONDS    CREATED                            CHANGED    
1                        true            Gym2017                           106                       24145                    2017-06-10 13:14:05.233    2019-02-01 10:11:27.293    


As you can see, the index still thinks that the songs are there. My question is, is there anyway for me to get that list of songs (paths) and re-populate? Also, anybody have any idea why me logging on wiped the playlists?
CeePeeBee
 
Posts: 8
Joined: Sat Jun 01, 2013 11:27 am

Re: Playlists Randomly Deleted

Postby CeePeeBee » Wed Feb 06, 2019 4:06 pm

bump - any iedas?
CeePeeBee
 
Posts: 8
Joined: Sat Jun 01, 2013 11:27 am


Return to Help

Who is online

Users browsing this forum: No registered users and 17 guests