UI no longer working

All of a sudden my Sonarr UI stopped working. It appears to still be doing its thing for the most part from looking at the logs, but I cannot open the UI. The only error that pops up in the browser is “require.js: 138 Uncaught #”. Restarting the service ends with the same result when opening the UI.

In the logs I see:

14-12-30 15:02:09.6|Debug|Parser|Parsing string 'Major.Crimes.S03E16.720p.HDTV.X264-DIMENSION’
14-12-30 15:02:09.6|Debug|Parser|Episode Parsed. majorcrimes - S03E16
14-12-30 15:02:09.6|Debug|Parser|Language parsed: English
14-12-30 15:02:09.6|Debug|NzbDrone.Core.Parser.QualityParser|Trying to parse quality for Major.Crimes.S03E16.720p.HDTV.X264-DIMENSION
14-12-30 15:02:09.6|Debug|Parser|Quality parsed: HDTV-720p v1
14-12-30 15:02:09.6|Debug|Parser|Release Group parsed: DIMENSION
14-12-30 15:02:09.6|Debug|TrackedDownloadService|Failed to find episode for Major.Crimes.S03E16.720p.HDTV.X264-DIMENSION

Marr.Data.DataMappingException: The DataMapper was unable to load the following field: ‘Ratings’ value: ‘{
“percentage”: 79.0,
“votes”: 409,
“loved”: 370,
“hated”: 39
}’. Input string ‘79.0’ is not a valid integer. Path ‘percentage’, line 2, position 21. —> Newtonsoft.Json.JsonReaderException: Input string ‘79.0’ is not a valid integer. Path ‘percentage’, line 2, position 21.
at Newtonsoft.Json.JsonTextReader.ParseNumber()
at Newtonsoft.Json.JsonTextReader.ParseValue()
at Newtonsoft.Json.JsonTextReader.ReadInternal()
at Newtonsoft.Json.JsonReader.ReadAsInt32Internal()
at Newtonsoft.Json.JsonTextReader.ReadAsInt32()
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ReadForType(JsonReader reader, JsonContract contract, Boolean hasConverter)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.PopulateObject(Object newObject, JsonReader reader, JsonObjectContract contract, JsonProperty member, String id)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)
at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)
at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)
at NzbDrone.Core.Datastore.Converters.EmbeddedDocumentConverter.FromDB(ConverterContext context) in m:\BuildAgent\work\328d72309b633a8\src\NzbDrone.Core\Datastore\Converters\EmbeddedDocumentConverter.cs:line 36
at Marr.Data.Mapping.MappingHelper.LoadExistingEntity(ColumnMapCollection mappings, DbDataReader reader, Object ent, Boolean useAltName) in m:\BuildAgent\work\328d72309b633a8\src\Marr.Data\Mapping\MappingHelper.cs:line 58
— End of inner exception stack trace —
at Marr.Data.Mapping.MappingHelper.LoadExistingEntity(ColumnMapCollection mappings, DbDataReader reader, Object ent, Boolean useAltName) in m:\BuildAgent\work\328d72309b633a8\src\Marr.Data\Mapping\MappingHelper.cs:line 79
at Marr.Data.Mapping.MappingHelper.CreateAndLoadEntity[T](ColumnMapCollection mappings, DbDataReader reader, Boolean useAltName) in m:\BuildAgent\work\328d72309b633a8\src\Marr.Data\Mapping\MappingHelper.cs:line 25
at Marr.Data.DataMapper.Query[T](String sql, ICollection1 entityList, Boolean useAltName) in m:\BuildAgent\work\328d72309b633a8\src\Marr.Data\DataMapper.cs:line 577 at Marr.Data.QGen.QueryBuilder1.ToList() in m:\BuildAgent\work\328d72309b633a8\src\Marr.Data\QGen\QueryBuilder.cs:line 279
at Marr.Data.QGen.SortBuilder1.ToList() in m:\BuildAgent\work\328d72309b633a8\src\Marr.Data\QGen\SortBuilder.cs:line 176 at Marr.Data.QGen.SortBuilder1.GetEnumerator() in m:\BuildAgent\work\328d72309b633a8\src\Marr.Data\QGen\SortBuilder.cs:line 247
at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source)
at NzbDrone.Core.Tv.SeriesRepository.FindByTitle(String cleanTitle) in m:\BuildAgent\work\328d72309b633a8\src\NzbDrone.Core\Tv\SeriesRepository.cs:line 33
at NzbDrone.Core.Tv.SeriesService.FindByTitle(String title) in m:\BuildAgent\work\328d72309b633a8\src\NzbDrone.Core\Tv\SeriesService.cs:line 103
at NzbDrone.Core.Parser.ParsingService.GetSeries(ParsedEpisodeInfo parsedEpisodeInfo, Int32 tvRageId) in m:\BuildAgent\work\328d72309b633a8\src\NzbDrone.Core\Parser\ParsingService.cs:line 354
at NzbDrone.Core.Parser.ParsingService.Map(ParsedEpisodeInfo parsedEpisodeInfo, Int32 tvRageId, SearchCriteriaBase searchCriteria) in m:\BuildAgent\work\328d72309b633a8\src\NzbDrone.Core\Parser\ParsingService.cs:line 107
at NzbDrone.Core.Download.TrackedDownloads.TrackedDownloadService.TrackDownload(DownloadClientDefinition downloadClient, DownloadClientItem downloadItem) in m:\BuildAgent\work\328d72309b633a8\src\NzbDrone.Core\Download\TrackedDownloads\TrackedDownloadService.cs:line 61

The file referenced was a recent download, so my guess is something went wrong with processing that. This is on Windows, running the develop branch. Is my database toast or is there anything I can try to recover?

Thanks- Jim.

I am having the same issue, logs look the same or very similar.

This is due to an upgrade in an attempt to fix our integration with the Trakt API and subsequent removal of it after it caused issues.

I have pushed a fix for it to develop already (2.0.0.2550). Are you able to navigate to anything in the UI or is it completely down (I think the later)?

If you want to manually update you can be back in business immediately, otherwise the update will trickle yo you within about 6 hours.

Sorry about the issues we caused here.

The UI is down, I could do a manual but can wait 6 hrs :smile:
Thanks a lot for the prompt reply

good luck with all the fixes.

Thanks! Hoping to have things back to normal as quickly as we can.

How can I do the manual update? the console.exe /? doesn’t seem to have an option, only to install as service.

Windows? Download the installer again from https://sonarr.tv or the tar.gz for OS X/Linux

Well that was a bad move. I downloaded the windows installer again, ran it, now when I go to the UI I get the require.js error AND another one… “[GET] Internal Server Error: /api/profile”. I hope I haven’t lost all my settings and DB :frowning: Restarted service… same thing. Any other ideas on getting back into the UI?

I’m sorry, thats my fault completely… you need this one https://update.sonarr.tv/v2/develop/latest/NzbDrone.develop.exe - which is for develop.

Your DB is still there, I just had you install the master version that doesn’t have the changes to profiles (or the fix for series).

Let me know if you still have issues.

Worked like a treat! Thank you again for all your efforts!

Success! Thanks for confirming.

I used the link to the develop version you posted as I as well had the same issue, and now my entire library is screwed up. I have all sorts of shows listed that I never downloaded it’s really messed up. How can I go back to an earlier version of the app and my db, it’s downloading all sorts of old eps automatically I didn’t ask for and really just not working properly at all…

Update: This was due to whatever changes were made during the updates, it seems there was more than 1 and I found the backups but 2 of the 3 backups from today were bad, they had all sorts of series I never added and missing stuff from series I do have, it was a total mess. I updated to the 2550 version manually and restored the first db backup from today and I am back in business. Just scared me as I never had to do such a restore before, but you’ve made it really easy and now I know for next time.

Thats due to trakt returning random series instead of the one that was requested. Sonarr would request 79488 (30 Rock) and get Law & Order back (or something to that extent).

Glad you’re back in business!