RSS Sync Fails with SQL Error

Help & Support
#1

I am running the latest version of Sonarr on my Synology. It was working fine until I had to reboot the Synology last night. After the reboot, Sonarr would not start. So, I reinstalled and restored from a backup. Now, when Sonarr starts I get this…

Task Error: SQL logic error or missing database
no such column: t0.IndexerId
System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
no such column: t0.IndexerId
at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, System.UInt32 timeoutMS, System.String& strRemain) [0x0033c] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00068] in <61a20cde294d4a3eb43b9d9f6284613b>:0

And when I try to initiate an episode search, I get this…

Error occurred while executing task EpisodeSearch: SQL logic error or missing database
no such column: t0.IndexerId
System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
no such column: t0.IndexerId
at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, System.UInt32 timeoutMS, System.String& strRemain) [0x0033c] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00068] in <61a20cde294d4a3eb43b9d9f6284613b>:0

I uninstalled and reinstalled Sonarr and Mono but still the same issue.

Please advise.

#2

Sounds like you’re running an old version of Sonarr with a more recent DB version.

If you’re not running Sonarr 2.0.0.4949, upgrade to that versiob via the web UI.

#3

Sorry for the late reply. Before I got your response, I erased my DB and configured/re-added everything manually and everything is good now.

Thanks!

1 Like
#4

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