Playlists Randomly Deleted

[CeePeeBee]

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]

bump - any iedas?

[CeePeeBee]

Seriously..no idea how to recover data that is CLEARLY sitting in a cache somewhere?

[Jägs]

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.

[CeePeeBee]

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]

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

[3Dscrewer]

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.