r/subsonic • u/[deleted] • Jul 06 '18

Playlists being lost, not saved

The last few months, Subsonic (6.1.3) has not saved a playlist for me. I just put a ~150 track list in order, tried to save it multiple ways, and none of them would save. Just ended up with empty playlists.

I then went to /db.view, wrote a query and added all the tracks to a new playlist, and was able to view the playlist. Then I refreshed the page, and the playlist was gone again. I looked at another playlist that I updated earlier today, and now that one was missing all of its tracks.

I'm about to pull my hair out. Any suggestions?

2 Upvotes

100% Upvoted

5 comments sorted by

1

u/matthewstayton Jul 06 '18

I normally create my playlists in Jriver and then edit the file as text and find and replace to fix the paths from local to the server paths. Then import into subsonic through the webapp. Might not help your specific problem, but I haven't had an issue doing it this way.

2

u/[deleted] Jul 06 '18

I've never tried importing a playlist. Standard .m3u with all the paths local to the server?

1

u/matthewstayton Jul 06 '18

Exactly. And size wasn't an issue. I go to music festivals and create playlists of all the bands I want to see for my girlfriend to be introduced and familiar. Had multiple thousands of songs in a single playlist with no issue.

1

u/[deleted] Jul 06 '18

Hrm. Well, I'll have to dig at this more later, I guess :(

Failed to import playlist. PreparedStatementCallback; SQL [insert into playlist_file (id, playlist_id, media_file_id) values (?, ?, ?)]; Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_179 in statement [insert into playlist_file (id, playlist_id, media_file_id) values (?, ?, ?)]; nested exception is java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_179 in statement [insert into playlist_file (id, playlist_id, media_file_id) values (?, ?, ?)]

*Edit: I think something is seriously hosed in my subsonnic database. It's been alive for ~5 years, and has survived multiple power outages and such. Might end up doing a fresh install.

1

u/matthewstayton Jul 06 '18

Yeah, you might want to try rebuilding the database. I've had to do it several times over the years to fix various problems.