Page 1 of 1

Sonarr – Manual import fails

Sonarr – Manual import fails

Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!

Topics for particular software or systems: Start your topic link with the name of the application or system.
Examples: "MacOS X - Your question", "MS Word - Your Tip or Trick".

Please note that switching to another language when reading a post will not work!
Posts will not have a translated counterpart.




RSS Feed

Home Forums Video & Movies Home Theatre Sonarr – Manual import fails

This topic contains 0 replies, has 1 voice, and was last updated by  hans 2 weeks, 5 days ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • 11830

    hans
    Keymaster

    Sometimes manual import fails with a “Unable to load files for manual import. Check logs for more details.” error.

    In the Sonarr log you may find a “Request Failed. GET /api/manualimport: Sequence contains more than one element” message, indicating that at least 2 shows have the same “cleantitle” (name).

    Open the database manually, for example with SQLitebrowser, and execute the following SQL statement:

    SELECT
     CleanTitle,
     GROUP_CONCAT(Id, ',') AS Ids,
     GROUP_CONCAT(TvdbId, ',') AS TVDBIds,
        COUNT(*) RecordsPerGroup
    FROM Series
    GROUP BY CleanTitle
    HAVING COUNT(*) > 1

    If you get rows back, then this means that you have shows with duplicate (not unique) clean titles.

    Unfortunately, Sonarr uses a technique to determine this unique title, which results in “Flashforward” and “Flash Forward” having the SAME clean title. At least now you know which shows are causing the problem and you can now spend time cleaning up those shows.

Viewing 1 post (of 1 total)



You must be logged in to reply to this topic.