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: 11
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: 11
Joined: Sat Jun 01, 2013 11:27 am

Re: Playlists Randomly Deleted

Postby CeePeeBee » Tue Feb 19, 2019 8:36 am

Seriously..no idea how to recover data that is CLEARLY sitting in a cache somewhere?
CeePeeBee
 
Posts: 11
Joined: Sat Jun 01, 2013 11:27 am

Re: Playlists Randomly Deleted

Postby Jägs » Fri Feb 22, 2019 1:32 am

Are the playlists actually empty in Subsonic, or do they simply list the songs as "missing?" If the latter--or even if not--did you move the songs to a different location?

Beyond that, I'm not sure I can provide much more assistance. I've had problems with the Subsonic DB getting corrupted in the past, so I wrote a playlist exporter in Perl:

http://forum.subsonic.org/forum/viewtopic.php?f=5&t=17436

It dumps the playlists to M3U files that can be imported back into Subsonic, should you need to recreate them, assuming the songs paths are the same.

Of course, if you playlists are empty, this will not do you any good until you rebuild them, unfortunately.
Jägs
 
Posts: 92
Joined: Wed Apr 06, 2011 9:52 pm

Re: Playlists Randomly Deleted

Postby CeePeeBee » Fri Mar 08, 2019 6:39 pm

Hey,

Thanks for coming back.

The playlists say they are empty, but when I look at them in the overview page, it shows a number of songs, so there must be a table in the DB somewhere that is either totalling up a number of rows, or has a static field in. If it's the former, I can at least get the list of items that WERE in my playlist so I can rebuild.

Nothing has moved in terms of the music. It's been in the same place for 3 years!

https://pasteboard.co/I4vm1Iq.jpg
CeePeeBee
 
Posts: 11
Joined: Sat Jun 01, 2013 11:27 am

Re: Playlists Randomly Deleted

Postby CeePeeBee » Fri Mar 08, 2019 6:54 pm

Don't worry about it, I just dug up my old SQL skills and queried the db.view and despite the playlist table having the static data, the playlist_file table has nothing other than one playlist ID with entries.....they're gone :(
CeePeeBee
 
Posts: 11
Joined: Sat Jun 01, 2013 11:27 am

Re: Playlists Randomly Deleted

Postby 3Dscrewer » Sat Mar 09, 2019 8:22 am

If I read this, it should be a good idea to export the playlists, in case of there is still a copy ...
But since there are so many versions, Windows, Linux, MAC and the different versions for NAS Systems, there should be always small difference.

For me, I found that I can't see much in the Log Files of Windows Version, even if a User is logging in, I can't see.
Have to research if different Log Level exists.
3Dscrewer
 
Posts: 47
Joined: Tue Feb 13, 2018 1:11 pm


Return to Help

Who is online

Users browsing this forum: No registered users and 20 guests