Sonarr version (exact version): 20180303-13
Mono version (if Sonarr is not running on Windows):5.8.0.108-11
OS: synology DSM 6
Debug logs:
(Make sure debug logging is enabled in settings and post the full log to hastebin/pastebin/dropbox/google drive or something similar, do not post them directly here. Post in .txt not .doc, .rtf or some other formatted document)
Description of issue:
I have uninstalled and then reinstalled my sonarr following this:
Backup file in sonarr to a tmp folder on my synology
Restore for Synology NAS
Re-install Sonarr
Run Sonarr once to get the AppData directory location
Stop Sonarr
Connect to the Synology NAS through SSH and log in as root
Execute the following commands:
rm -r /usr/local/nzbdrone/var/.config/NzbDrone/nzbdrone.db-*
cp -f /tmp/nzbdrone_backup/* /usr/local/nzbdrone/var/.config/NzbDrone/
Update permissions on the files:
cd /usr/local/nzbdrone/var/.config/NzbDrone/
chown -R nzbdrone:users *
chmod -R 0644 *
On some installations, the user is different: chown -R sc-nzbdrone:nzbdrone *
Start Sonarr
After that, everything works except the indexer, it is not looking. I checked the indexer config and the test is successful.
The error I get in the log when I try to do a manual search:
Episode search failed: 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 () [0x000f6] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteCommand.GetStatement (System.Int32 index) [0x00008] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteCommand.GetStatement(int)
at System.Data.SQLite.SQLiteDataReader.NextResult () [0x0011e] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteDataReader…ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x00090] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader…ctor(System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.Common.DbCommand.ExecuteReader () [0x00000] in <058e0af44f1a4bdcb3cb33b5c2d65fe0>:0
at (wrapper remoting-invoke-with-check) System.Data.Common.DbCommand.ExecuteReader()
at Marr.Data.DataMapper.Query[T] (System.String sql, System.Collections.Generic.ICollection1[T] entityList, System.Boolean useAltName) [0x00071] in <3ee08a9670e84235ba319cb34a7b7e06>:0 at Marr.Data.QGen.QueryBuilder1[T].ToList () [0x00052] in <3ee08a9670e84235ba319cb34a7b7e06>:0
at NzbDrone.Core.Datastore.BasicRepository1[TModel].All () [0x0000b] in <79aedd59b0b5420eb68244aef8f3e5b8>:0 at NzbDrone.Core.Indexers.IndexerStatusService.GetBlockedIndexers () [0x00000] in <79aedd59b0b5420eb68244aef8f3e5b8>:0 at NzbDrone.Core.Indexers.IndexerFactory+<FilterBlockedIndexers>d__7.MoveNext () [0x0001f] in <79aedd59b0b5420eb68244aef8f3e5b8>:0 at System.Collections.Generic.List1[T]…ctor (System.Collections.Generic.IEnumerable1[T] collection) [0x00077] in <cb410c64c7fa4e8d9841a0cbe4173d66>:0 at System.Linq.Enumerable.ToList[TSource] (System.Collections.Generic.IEnumerable1[T] source) [0x00018] in :0
at NzbDrone.Core.Indexers.IndexerFactory.SearchEnabled (System.Boolean filterBlockedIndexers) [0x00035] in <79aedd59b0b5420eb68244aef8f3e5b8>:0
at NzbDrone.Core.IndexerSearch.NzbSearchService.Dispatch (System.Func`2[T,TResult] searchAction, NzbDrone.Core.IndexerSearch.Definitions.SearchCriteriaBase criteriaBase) [0x0001b] in <79aedd59b0b5420eb68244aef8f3e5b8>:0
at NzbDrone.Core.IndexerSearch.NzbSearchService.SearchSingle (NzbDrone.Core.Tv.Series series, NzbDrone.Core.Tv.Episode episode, System.Boolean userInvokedSearch) [0x0009e] in <79aedd59b0b5420eb68244aef8f3e5b8>:0
at NzbDrone.Core.IndexerSearch.NzbSearchService.EpisodeSearch (NzbDrone.Core.Tv.Episode episode, System.Boolean userInvokedSearch) [0x0006d] in <79aedd59b0b5420eb68244aef8f3e5b8>:0
at NzbDrone.Core.IndexerSearch.NzbSearchService.EpisodeSearch (System.Int32 episodeId, System.Boolean userInvokedSearch) [0x0000d] in <79aedd59b0b5420eb68244aef8f3e5b8>:0
at NzbDrone.Api.Indexers.ReleaseModule.GetEpisodeReleases (System.Int32 episodeId) [0x00000] in :0
Can someone help me?
I don’t want to reinstall everything 