I just added 3 episodes of a new serie which was not yet on the Plex Server. Once scanned, everything has been added correctly but these 3 episodes. They simply are not available on PLEX (using the browser on the server machine).
I imagine these episodes were matched to an existing serie in the database but I can’t figure which one…
I would query the database but can’t figure out where (table/column) the file path should be searched to figure out how to
Step 1: Filter the library for Duplicates to identify episodes that have multiple files associated to them
Step 2: Sort the library by Date added and check if the last episodes don’t seem to belong there
Look at the episode details to confirm if they contain the newly added files (e.g. using > Info or ⋮ > Get Info).
If that doesn’t provide any details you could use some 3rd party tools like WebTools-NG to export data from your library and reverse-engineer where those files of yours ended up.
However… generally sticking to the naming schema will prevent such mishaps.
Thank you very much for your time.
Unfortunately, this did no fix my problem since )1) there were like 2600 false duplicates present there since I had to move the whole content of a big HD and (2) Because there were finally, after checking out carefully, no mismatched episodes (my error in assumption). Additionally, the filename scheme is respected carefully for everything I add…
Forunately, by moving and renaming the files (adding the year with parenthesis) made so the episodes finally appeared.
I’d still like to know how to query the database directly, if I could get a chart of what info is in which table, that’d be way more productive…