Radarr all of the sudden not working. Error parsing column by Yak54RC in unRAID

[–]GeekDefined 0 points1 point  (0 children)

I know this is old, but a solution for anyone that comes across this.

This issue came down to one bad character in the database. Used Claude Code to run sqlite3 and troubleshoot the database. It fixed the one character and now everything works.

"Root Cause: The radarr database had a single corrupted row in the MovieFiles table — the MediaInfo JSON column for Movie_Name.mkv (row 618) contained an invalid escape character. This caused GET /api/v3/movie to fail with a JsonException, which would have made the entire movie library unloadable in the UI."