frozen helm
Taking a look at a specific series (American Idol 2002), it does not show all available seasons to be requested. Looking at the linked TVDB listing I can see 24 seasons but Seerr is only showing up to Season 15.
Looking through the logs it looks like Series searches use TMDB while Sonarr uses TVDB. TMDB has the Series split into two Series, one from 2002 and a second that started in 2018. Any ideas how to reconcile this?
Seerr v3.0.1
I just found that this can be changed in the settings. Thanks!
frozen helm
Yess
I noticed that after switching to TVDB the Media Availability sync still uses TMDB and as a result the series in question wont mark the available seasons. Is this intended or would this be worth a github ticket?
2026-02-15T23:46:33.905Z [info][AvailabilitySync]: The non-4K show [TMDB ID 25347] still exists. Preventing removal.
2026-02-15T23:46:33.927Z [info][AvailabilitySync]: The non-4K show [TMDB ID 157744] still exists. Preventing removal.
2026-02-15T23:46:33.940Z [info][AvailabilitySync]: The non-4K show [TMDB ID 4493] still exists. Preventing removal.
Media availability sync job is NOT
For available marking
Its for removing availability
frozen helm
What controls that?
novel onyx
Marking it available is done by full scan and recently added
And i can confirm its properly marking according to tvdb structure. I have tvdb setip
For series
frozen helm
Hmm ok. I tried that too but it didn't pick up those seasons. I'll try again and check the logs
novel onyx
Hmm ok. I tried that too but it didn't pick up those seasons. I'll try again and...
Send logs after running them
frozen helm
Send logs after running them
Found this
2026-02-16T00:08:56.021Z [error][Plex Scan]: Failed to process Plex media {"errorMessage":"SQLITE_CONSTRAINT: UNIQUE constraint failed: media.tvdbId","title":"American Idol"}
Uploading full logs now, one sec
Here are the logs from the start of the scan to the end:
https://logs.notifiarr.com/?54480521d73b0a38#APJsRMM9sgGZCzeJbggt5prsSYkkgSwSNAmcMBScuFhw
novel onyx
Found this
```
2026-02-16T00:08:56.021Z [error][Plex Scan]: Failed to process P...
Ah you have a broken record
Youll need to delete it
Are you comfortable with edittijg db?
novel onyx
Can you run the query
SELECT id, title, mediaType, tvdbId, tmdbId, plexId, plexGuid
FROM media
WHERE title LIKE '%American Idol%';
Oh wait
Wrong one
Give me a sec
SELECT id, mediaType, tmdbId, tvdbId, ratingKey, ratingKey4k, createdAt, updatedAt
FROM media
WHERE tvdbId = 70814;
Okay good
BEGIN;
DELETE FROM media_request WHERE mediaId = 2500;
DELETE FROM season WHERE mediaId = 2500;
DELETE FROM issue WHERE mediaId = 2500;
DELETE FROM watchlist WHERE mediaId = 2500;
DELETE FROM blocklist WHERE mediaId = 2500;
DELETE FROM media WHERE id = <MEDIA_ID>;
COMMIT;
Im guessing you took a db backup?
If not takae now
Then run the above
frozen helm
Will do. I also see SQL errors in the logs for three other items. Should I do this for those items as well?
2026-02-16T00:09:30.785Z [error][Plex Scan]: Failed to process Plex media {"errorMessage":"SQLITE_CONSTRAINT: UNIQUE constraint failed: media.tvdbId","title":"Hard Knocks"}
2026-02-16T00:09:50.364Z [error][Plex Scan]: Failed to process Plex media {"errorMessage":"SQLITE_CONSTRAINT: UNIQUE constraint failed: media.tvdbId","title":"Nobody Asked"}
2026-02-16T00:10:20.045Z [error][Plex Scan]: Failed to process Plex media {"errorMessage":"SQLITE_CONSTRAINT: UNIQUE constraint failed: media.tvdbId","title":"Will & Grace"}
Oh remove the begin
frozen helm
DELETE FROM media_request WHERE mediaId = 2500;
DELETE FROM season WHERE mediaId = 2500;
DELETE FROM issue WHERE mediaId = 2500;
DELETE FROM watchlist WHERE mediaId = 2500;
DELETE FROM blocklist WHERE mediaId = 2500;
DELETE FROM media WHERE id = 2500;
COMMIT;
Correct?
Looks good:
Just uploaded the updated DB and restarted the container. Running a full scan now.
OK, so that particular SQL error is no longer there. I now see:
2026-02-16T01:15:35.000Z [debug][Plex Scan]: Saved American Idol
But the show still doesnt show any seasons as available
Full logs of the scan: https://logs.notifiarr.com/?59600ee72b66d50b#Ew9M1b5Pjk8uTnYNuN4Mey6YsTTd6TFqKP466PSToPkc
These are some of the seasons I should have available
novel onyx
Full logs of the scan: https://logs.notifiarr.com/?59600ee72b66d50b#Ew9M1b5Pjk8u...
Will check after I wake up
Try running sonarr scan as well
frozen helm
Try running sonarr scan as well
No luck
frozen helm
I did a little more digging and I still think that TMDB is being used for this series. Taking a look at the DB after we did the purge the new media id for this series is 3456. Searching for Seasons associated with that media ID I get 1-9 which matches what TMDB has split out in the second version of the series.
Is there any way to validate this?
novel onyx
I did a little more digging and I still think that TMDB is being used for this s...
No you're right btw. Scanner is ignoring tvdb. Its requesting as tvdb but scanner is not checking to see via tvdb
Dont worry I was able to reproduce
I guess it was not implemented
So it will come as 3.1.0 hopefully
frozen helm
Would it be helpful to put in a Github ticket for this?
novel onyx
Ill push a pr soon. Was gonna do tonight but its 3am and im exhausted 😔
novel onyx
Would it be helpful to put in a Github ticket for this?
Yes. Just create a feature request saying sth about scanner to use tvdb for availability
And I'll assign it to myself and look into it
Hopefully tomorrow or this weekend
frozen helm
