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 most likely no translated for the post!




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

Sonarr - Manual import fails


 Hans
(@hans)
Noble Member Admin
Joined: 8 years ago
Posts: 1840
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

Like what you see and you'd like to help out? 

The best way to help is of course by assisting others with their questions here in the forum, but you can also help us out in other ways:

- Do your shopping at Amazon, it will not cost you anything extra but may generate a small commission for us,
- send a cup of coffee through PayPal ($5, $10, $20, or custom amount),
- become a Patreon,
- donate BitCoin (BTC), or BitCoinCash (BCH).

Share: