Sonarr version: 2.0.0.5344
OS: Windows 2008 > Windows 10
Debug Logs: 2024-01-13 11:23:19.1|Error|DownloadDecisionMaker|Couldn’t evaluate decision on Star.Trek-.Picard.S02E08.Mercy.1080p.WEBRip.10Bit.DDP5.1.HEVC-d3g
[v4.0.0.748] System.Data.DataException: Error parsing column 11 (Languages=[[
1
]] - String)
—> System.Text.Json.JsonException: The JSON value could not be converted to System.Collections.Generic.List1[NzbDrone.Core.Languages.Language]. Path: $[0] | LineNumber: 0 | BytePositionInLine: 2. ---> System.InvalidOperationException: Cannot get the value of a token type 'StartArray' as a number. at System.Text.Json.Utf8JsonReader.TryGetInt32(Int32& value) at System.Text.Json.Utf8JsonReader.GetInt32() at NzbDrone.Core.Datastore.Converters.LanguageIntConverter.Read(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options) in ./Sonarr.Core/Datastore/Converters/LanguageIntConverter.cs:line 39 at System.Text.Json.Serialization.JsonConverter1.TryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
at System.Text.Json.Serialization.JsonCollectionConverter2.OnTryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, TCollection& value) at System.Text.Json.Serialization.JsonConverter1.TryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
at System.Text.Json.Serialization.JsonConverter1.ReadCore(Utf8JsonReader& reader, JsonSerializerOptions options, ReadStack& state) --- End of inner exception stack trace --- at System.Text.Json.ThrowHelper.ReThrowWithPath(ReadStack& state, Utf8JsonReader& reader, Exception ex) at System.Text.Json.Serialization.JsonConverter1.ReadCore(Utf8JsonReader& reader, JsonSerializerOptions options, ReadStack& state)
at System.Text.Json.JsonSerializer.ReadFromSpan[TValue](ReadOnlySpan1 utf8Json, JsonTypeInfo jsonTypeInfo, Nullable1 actualByteCount)
at System.Text.Json.JsonSerializer.ReadFromSpan[TValue](ReadOnlySpan1 json, JsonTypeInfo jsonTypeInfo) at System.Text.Json.JsonSerializer.Deserialize[TValue](String json, JsonSerializerOptions options) at Dapper.SqlMapper.TypeHandler1.Dapper.SqlMapper.ITypeHandler.Parse(Type destinationType, Object value) in //Dapper/SqlMapper.TypeHandler.cs:line 42
at Dapper.SqlMapper.TypeHandlerCache1.Parse(Object value) in /_/Dapper/SqlMapper.TypeHandlerCache.cs:line 23 at Deserialize7dc13dd1-d4e8-48b4-8c50-1d3d822a6f2d(IDataReader ) --- End of inner exception stack trace --- at Dapper.SqlMapper.ThrowDataException(Exception ex, Int32 index, IDataReader reader, Object value) in /_/Dapper/SqlMapper.cs:line 3706 at Deserialize7dc13dd1-d4e8-48b4-8c50-1d3d822a6f2d(IDataReader ) at Dapper.SqlMapper.QueryImpl[T](IDbConnection cnn, CommandDefinition command, Type effectiveType)+MoveNext() in /_/Dapper/SqlMapper.cs:line 1113 at System.Collections.Generic.List1…ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)
at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable1 commandTimeout, Nullable1 commandType) in //Dapper/SqlMapper.cs:line 734
at NzbDrone.Core.Datastore.SqlMapperExtensions.Query[T](IDatabase db, String sql, Object param) in ./Sonarr.Core/Datastore/Extensions/SqlMapperExtensions.cs:line 17
at NzbDrone.Core.Datastore.ColumnMapper1.<>c__DisplayClass8_01.b__0(IDatabase db, T parent) in ./Sonarr.Core/Datastore/TableMapper.cs:line 0
at NzbDrone.Core.Datastore.LazyLoaded2.LazyLoad() in ./Sonarr.Core/Datastore/LazyLoaded.cs:line 121 at NzbDrone.Core.DecisionEngine.Specifications.UpgradeDiskSpecification.<>c.<IsSatisfiedBy>b__8_1(Episode c) in ./Sonarr.Core/DecisionEngine/Specifications/UpgradeDiskSpecification.cs:line 29 at System.Linq.Enumerable.WhereSelectListIterator2.MoveNext()
at NzbDrone.Core.DecisionEngine.Specifications.UpgradeDiskSpecification.IsSatisfiedBy(RemoteEpisode subject, SearchCriteriaBase searchCriteria) in ./Sonarr.Core/DecisionEngine/Specifications/UpgradeDiskSpecification.cs:line 29
at NzbDrone.Core.DecisionEngine.DownloadDecisionMaker.EvaluateSpec(IDecisionEngineSpecification spec, RemoteEpisode remoteEpisode, SearchCriteriaBase searchCriteriaBase) in ./Sonarr.Core/DecisionEngine/DownloadDecisionMaker.cs:line 233**:
Description: Hoping someone can help. I have an old EOL version of Sonar running on windows server 2008 R2 which I’m replacing. I made a backup of the config and imported it onto my new box running windows 10 with Sonarr v4 but I’m getting the above error in the logs. Is there a fix to this or is it best to upgrade my old instance of v2 to v3 and then to v4 to create a backup file to import onto my new win 10 box?