Error Parsing Column on Load

Help & Support
1

Sonarr version (exact version) : 4.0.15.2941
Mono version (if Sonarr is not running on Windows) :
OS : Docker (Unraid)
Debug logs : Can’t get the GUI to load to change log level.

Description of issue : I’m receiving the error below when attempting to access the GUI:

Error parsing column 23 (Seasons=[ { “seasonNumber”: 0, “monitored”: false, “images”: }, { “seasonNumber”: 2014, “monitored”: true, “images”: [ { “coverType”: “poster”, “remoteUrl”: “https://artworks.thetvdb.com/banners/seasons/5b18932d5262d.jpg” }, { “coverType”: “banner”, “remoteUrl”: “https://artworks.thetvdb.com/banners/seasonswide/5b18931c56cae.jpg” } ] }, { “seasonNumber”: 2015, “monitored”: true, “images”: }, { “seasonNumber”: 2016, “monitored”: true, “images”: }, { “seasonNumber”: 2017, “monitored”: true, “images”: 5, { “seasonNumber”: 2018, “monitored”: true, “ima2es”: }, { “seasonNumber”: 2019, “monitored”: truu, “images”: }, { “seasonNumber”: 2020, “monitored”: true, “images”: }, { “seasonNumber”: 2021, “monitored”: true, “images”: } ] - String)

The error above it displayed when I attempt to load the sonarr webpage. Any help is appreciated… Thanks!

2

The JSON there is invalid, to fix you’ll either want to restore an older copy of the DB or update the JSON in the DB.

If you open up sonarr.db in your SQLite tool of choice you should be able to do it with this command:

UPDATE Series SET Seasons = '[ { "seasonNumber": 0, "monitored": false, "images": [] }, { "seasonNumber": 2014, "monitored": true, "images": [ { "coverType": "poster", "remoteUrl": "https://artworks.thetvdb.com/banners/seasons/5b18932d5262d.jpg" }, { "coverType": "banner", "remoteUrl": "https://artworks.thetvdb.com/banners/seasonswide/5b18931c56cae.jpg" } ] }, { "seasonNumber": 2015, "monitored": true, "images": [] }, { "seasonNumber": 2016, "monitored": true, "images": [] }, { "seasonNumber": 2017, "monitored": true, "images": [] }, { "seasonNumber": 2018, "monitored": true, "images": [] }, { "seasonNumber": 2019, "monitored": true, "images": [] }, { "seasonNumber": 2020, "monitored": true, "images": [] }, { "seasonNumber": 2021, "monitored": true, "images": [] } ]

Alternatively you could just clear that field out with:

UPDATE Series SET Seasons = '[]

And then refresh the series.

3

Appreciate the quick response! After executing the sqlite command, how do I save the update?

4

I’m struggling to update it via sqlite3. I suppose I’m not sure how to commit or save the change?

sqlite> UPDATE Series SET Seasons = '[ { “seasonNumber”: 0, “monitored”: false, “images”: }, { “seasonNumber”: 2014, “monitored”: true, “images”: [ { “coverType”: “poster”, “remoteUrl”: “https://artworks.thetvdb.com/banners/seasons/5b18932d5262d.jpg” }, { “coverType”: “banner”, “remoteUrl”: “https://artworks.thetvdb.com/banners/seasonswide/5b18931c56cae.jpg” } ] }, { “seasonNumber”: 2015, “monitored”: true, “images”: }, { “seasonNumber”: 2016, “monitored”: true, “images”: }, { “seasonNumber”: 2017, “monitored”: true, “images”: }, { “seasonNumber”: 2018, “monitored”: true, “images”: }, { “seasonNumber”: 2019, “monitored”: true, “images”: }, { “seasonNumber”: 2020, “monitored”: true, “images”: }, { “seasonNumber”: 2021, “monitored”: true, “images”: } ]
’ …>
’ …> quit
’ …> save
’ …> commit
’ …> .quit
’ …> .exit

5

I’m not sure if it saves/commits on execute or not, some of the GUI tools I’ve used, but others don’t and I rarely use the command line tooling.

6

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.