Page 1 of 1
Forum

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.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.

Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!



Sonarr - Manual imp...
 
Share:
Notifications
Clear all

Sonarr - Manual import fails

1 Posts
1 Users
0 Likes
3,146 Views
 Hans
(@hans)
Famed Member Admin
Joined: 9 years ago
Posts: 2235
Topic starter  

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.


ReplyQuote
Share: