Editing a playlist results in Error 500 #957

Activity

1. djotaku commented on Aug 7, 2026

   

   djotaku

   on Aug 7, 2026

   More actions

   Same thing is happening to me. Let me know if there's anywhere I can check in the logs to help
2. djotaku commented on Aug 10, 2026

   

   djotaku

   on Aug 10, 2026

   More actions

   Hey, I wanted to add a little more context based on my experience with how it's happening on my pod. It is definitely true that any edits to a user made smart playlist will result in a 500 error. It seems that the changes are recorded. And it also seems that the system can tolerate this happening a few times before it does give the symptom that the original reporter stated. That is to say it seems that if I edit just one smart playlist and it gets the 500 error it's fine. But if I keep doing it then eventually all my playlists disappear and I have to revert to a known good backup.
3. kalmatthew commented on Aug 24, 2026

   

   kalmatthew

   on Aug 24, 2026

   More actions

   I hit this exact bug today and tracked down the root cause via direct DB/log access (Postgres backend). (Investigation and this comment were done by Claude Code on my behalf, not by me directly — flagging that for transparency.)

   Editing a user-created playlist through the UI writes NULL into the Playlists.description column (confirmed: my playlist's last_updated timestamp matched the moment the error started). The backend's get_playlists query decodes that column as String rather than Option<String>, so any playlist with a NULL description makes the entire get_playlists response 500 — which is why home page ("no playlists exist") and the playlist page both break at once, exactly as reported above.

   Server log (Rust backend, Postgres):

   API Error: 500 - Database error: error occurred while decoding column "description": unexpected null; try decoding as an `Option`
   

   Workaround (no data loss, no backup restore needed): set the affected playlist's description back to an empty string instead of NULL, e.g.:

   UPDATE "Playlists" SET description = '' WHERE description IS NULL;

   That immediately restores get_playlists for all users without needing to revert to a backup.

   Suggested real fix: either (a) make the edit-playlist endpoint write '' instead of NULL when no description is given, or (b) make the get_playlists query decode description as Option<String> so a NULL doesn't 500 the whole response.
4. madeofpendletonwool commented on Oct 29, 2026

   

   madeofpendletonwool

   on Oct 29, 2026

   Owner

   More actions

   Fixed in #1039 - Episodes missing a title or artwork were breaking the playlist preview. Those are handled now and editing works again. Will be released officially with the next release coming soon.
5. madeofpendletonwool

   closed this as completedon Oct 29, 2026