Hello community, im trying to find files that were combined in the database. i have about 1000 tv shows and 8000 movies. going 1 by 1 to look at the info is not the way i want to move forward. i installed sqllitestudio to query the database. opened database \\PlexMediaServer\AppData\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library to start to query table however it seems like every table (besides a few system tables) are empty. There are some virtual tables that i cannot open with the SQL tool. Im really looking for what im doing wrong. the main issue is I have House of Cards (the BBC version) that has been combined with something but i cannot seem to figure out what it has been combined with (no trace of it found in plex tv shows). the obvious choice was the tv show “House” but its not there (and i dont have the US version of House of Cards). Please help me (i also have tried to rename the directory including they year, the file names, etc… nothing seems to work). why cant i see data in the tables when i do a simple select * from tablename in the sql tool. (my guess is the plex DB is not where i think it is). any help would be grateful.
Plex Documentation → Your Media
→ Naming & Organizing Your TV Show Files
→ Naming & Organizing Your Movie Files
Can’t help with db queries.
However, for House of Cards, add the TMDB or TVDB ID to the show folder. The ID tells Plex exactly which show to match. For movies, use the TMDB or IMDB ID.
After renaming, Plex Dance the series (or movie). Follow all of the steps. This removes previous, incorrect matching information from the Plex database.
/TV Shows <-- folder added to TV Show library
.../House of Cards (1990) {tmdb-21720} <-- Show_Name (year) {tmdb/tvdb id}
....../Season 01
........./House of Cards (1990) s01e01.ext <-- ext=mkv/mp4/etc.
There are tools to assist with the process:
Many people use Filebot.
The free version of Tiny Media Manager works for basic renaming.
TMM Renamer Patterns:
- Show Name:
${showTitle} (${showYear}) - Season:
Season ${seasonNr2} - Episode Name:
${showTitle} (${showYear}) s${seasonNr2}e${episodeNr2} ${episode.title} - Movie Name:
${title} (${year}) {imdb-${imdb}}
PowerRenamer in Microsoft Power Tools is helpful for simple renaming with pattern matches or regular expressions. It makes quick work of tasks such as adding a year to file names, removing undesirable text from multiple files, etc
Dont use the database directly instead use:
However I can stay if you name your stuff correctly you will avoid issues. As FordGuy says above, I naming has a huge impact on matching.
still must be doing something wrong. after the dance i still dont see house of cards.
@dbirch. I am not looking to update the database through SQL however i still would like to query it to find any other potential issues.
thanks to both of you for your quick response and things to try.
any other suggestions. do you see anything incorrect with the directory structure or the names. the full title of the files are “House of cards” just got cut off on the screen shot.
season 2 and 3 look the same
Can you provide a screenshot of your library folders? (In Plex’s config)
Go to the TV Library
Filter by episode instead of show
Then filter by duplicate
For anything that shows up click the show poster and “get info”
That will show you what shows are being combined
You may also have embedded metadata overriding your naming if you have “Prefer Local Metadata” enabled in the library advanced settings
JaysPlex7 - thank you so much. im very very new to plex but like the app. this will help me out and solve my issue of not being able to query the database. @dbirch the directory tree in Plex stops at drama and everything so far in the tree resolves but thanks for making me look because you never know. @FordGuy61 thanks for your help. i think i can move forward now.
@imwa8 if the folder path is video/TV/Drama Then you have been getting lucky. Plex does not support multiple folder nesting. You need to go to video/TV/Drama/BBC Drama
The issue you have due to merging is a direct result of this.
WOW, i had no idea. i have multiple folder structures all over the place and dont seem to have an issue. guess i need to mend my evil ways.
See https://support.plex.tv/articles/naming-and-organizing-your-tv-show-files/ and specifically the line about:
Tip!: More specifically, the folder you want to specify as the content location for the library is the folder that contains each of the individual show folders. So, if you chose to categorize your children’s content separate from more “adult” content (e.g. /TV Shows/Kids/ShowName vs /TV Shows/Regular/ShowName), then you would specify /TV Shows/Kids as the source location for a “kids” TV library.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
