Page 1 of 1

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...
Clear all

Sonarr - Manual import fails

1 Posts
1 Users
Famed Member Admin
Joined: 11 years ago
Posts: 2638
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:

 GROUP_CONCAT(Id, ',') AS Ids,
    COUNT(*) RecordsPerGroup
FROM Series
GROUP BY CleanTitle

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.


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).