Unable to Load UI - Ratings are corrupt

[password]

I have the same problem. Here’s the error message from the log file. I am on OSX

[v2.0.0.4949] Marr.Data.DataMappingException: The DataMapper was unable to load the following field: 'Ratings' value: 'duled"¬
}�^B2017-10-07 18:18:02.0873'. Unexpected character encountered while parsing value: d. Path '', line 0, position 0. ---> Newtonsoft.Json.JsonReaderException: Unexpected character encountered while parsing value: d. Path '', line 0, position 0.¬
  at Newtonsoft.Json.JsonTextReader.ParseValue () [0x002b3] in <1fa899c21f554672afbc630cc93b185e>:0 ¬
  at Newtonsoft.Json.JsonTextReader.Read () [0x0004c] in <1fa899c21f554672afbc630cc93b185e>:0 ¬
  at Newtonsoft.Json.JsonReader.ReadAndMoveToContent () [0x00000] in <1fa899c21f554672afbc630cc93b185e>:0 ¬
  at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ReadForType (Newtonsoft.Json.JsonReader reader, Newtonsoft.Json.Serialization.JsonContract contract, System.Boolean hasConverter) [0x00043] in <1fa899c21f554672afbc630cc93b185e>:0 ¬
  at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize (Newtonsoft.Json.JsonReader reader, System.Type objectType, System.Boolean checkAdditionalContent) [0x00029] in <1fa899c21f554672afbc630cc93b185e>:0 ¬
   --- End of inner exception stack trace ---¬
  at Marr.Data.Mapping.MappingHelper.LoadExistingEntity (Marr.Data.Mapping.ColumnMapCollection mappings, System.Data.Common.DbDataReader reader, System.Object ent, System.Boolean useAltName) [0x000a8] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\Marr.Data\Mapping\MappingHelper.cs:79 ¬
  at Marr.Data.Mapping.MappingHelper.CreateAndLoadEntity (System.Type entityType, Marr.Data.Mapping.ColumnMapCollection mappings, System.Data.Common.DbDataReader reader, System.Boolean useAltName) [0x00012] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\Marr.Data\Mapping\MappingHelper.cs:40 ¬
  at Marr.Data.Mapping.MappingHelper.CreateAndLoadEntity[T] (Marr.Data.Mapping.ColumnMapCollection mappings, System.Data.Common.DbDataReader reader, System.Boolean useAltName) [0x00000] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\Marr.Data\Mapping\MappingHelper.cs:25 ¬
  at Marr.Data.DataMapper.Query[T] (System.String sql, System.Collections.Generic.ICollection`1[T] entityList, System.Boolean useAltName) [0x0008d] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\Marr.Data\DataMapper.cs:577 ¬
  at Marr.Data.QGen.QueryBuilder`1[T].ToList () [0x00052] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\Marr.Data\QGen\QueryBuilder.cs:279 ¬
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].All () [0x00000] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\NzbDrone.Core\Datastore\BasicRepository.cs:60 ¬
  at NzbDrone.Core.Tv.SeriesService.GetAllSeries () [0x00000] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\NzbDrone.Core\Tv\SeriesService.cs:144 ¬
  at NzbDrone.Api.Series.SeriesModule.AllSeries () [0x0000c] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\NzbDrone.Api\Series\SeriesModule.cs:106 ¬
  at NzbDrone.Api.REST.RestModule`1[TResource].<set_GetResourceAll>b__32_0 (System.Object options) [0x00000] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\NzbDrone.Api\REST\RestModule.cs:111 ¬
  at (wrapper dynamic-method) System.Object:CallSite.Target (System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,System.Func`2<object, object>,object)¬
  at Nancy.Routing.Route+<>c__DisplayClass4.<Wrap>b__3 (System.Object parameters, System.Threading.CancellationToken context) [0x00049] in <63c44d6f8d7e4f339a987bf9eb94d931>:0 ¬

[markus101]

Moved because it’s not likely the same issue.

It looks like your database is corrupt, ((restoring)) a recent backup is probably the easiest way to get back up and running. Though opening the SQLite DB in a manager of your choice and running UPDATE Series SET Ratings = '{}’ should also fix it and keep the recent history intact.

[password]

It wasn’t enough to run an update-sql, I got an error saying “database disk image is malformed”. So I restored from backup and it worked perfectly!