Error, “Unable to load episode files”

Sonarr version: 4.0.9.2244
Mono version: 6.12.0.182-20
OS: Synology/Docker
Debug logs: [v4.0.9.2244] System.Data.DataException: Error parsing column 9 (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 Deserialize6fb40495-436b-4234-863e-ca0552d32194(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 Deserialize6fb40495-436b-4234-863e-ca0552d32194(IDataReader )
at Dapper.SqlMapper.QueryImpl[T](IDbConnection cnn, CommandDefinition command, Type effectiveType)+MoveNext()
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) at NzbDrone.Core.Datastore.SqlMapperExtensions.Query[T](IDatabase db, String sql, Object param) at NzbDrone.Core.Datastore.BasicRepository1.Query(SqlBuilder builder)
at NzbDrone.Core.Download.CompletedDownloadService.Check(TrackedDownload trackedDownload)
at NzbDrone.Core.Download.TrackedDownloads.DownloadMonitoringService.ProcessClientItem(IDownloadClient downloadClient, DownloadClientItem downloadItem)`
Description of issue: Hello, since the upgrade to the latest version I cannot get the list of episodes on my tv shows. Exact same issue as in Error, "Unable to load episode files" when I try to view a series after the upgrade to 4.0.1.929

I have downloaded and checked the DB (nzbdrone.db in my case) but in the EpisodeFiles table I am missing the Languages column so I cannot update it :confused:

That’s not the only difference in the DB so I am not sure how I should proceed.

Thanks for the help.

stan

nzbdrone.db is the database from v2, for v4 the database will be named sonarr.db and will have the language column. Check System: Status for the location of the AppData folder that contains it.

thanks @markus101,
this is indeed what I thought, unfortunately in my AppData folder (/config in docker) I only have the nzbdrone.db.

/system/status info that I have:

Version: 4.0.9.2244
Package Version: 4.0.9.2244-ls252 by linuxserver.io
.NET: Yes (6.0.13)
Docker: Yes
Database: Sqlite 3.45.3
Database Migration: 211
AppData Directory: /config
Startup Directory: /app/sonarr/bin