Problem Displaying Correct Resolution

It is a nit picky little problem but I would like to know how to fix it.  The file is in fact a 1080p movie and I would like plex media server to display it as such instead of showing it as 720p.  Needless to say I like to keep my movies extremely organized an accurate so this displaying incorrect information is annoying.  I tried to go into the XML file and change resolution from 720p manually but I could not figure out how to save my changes.  Any assistance or advice would be greatly appreciated.  

 

Also my screen shot will not upload, dont know what the deal is with that but whatever.  I have uploaded it through another image host.

 

http://imgh.us/Screen_Shot_2013-08-05_at_10.41.51_PM.jpg

 

TLDR: You need to change the resolution values in the PMS sqlite file, or re-encode the video so it's at least 1920 px wide.

The reason why this happens is because your movie is not precisely 1920 pixels wide.  This has happened to me for some of my movies when HandBrake does and auto crop.  A 1918px wide movie will show up in PMS as 720p resolution. 

In the Linux version (the only version I have installed) Metadata information is stored in sqlite, not in XML.  Relevant *.db file is locate (on Ubuntu Linux) at:

/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Databases/com.plexapp.plugins.library.db

Using a program like sqlitebrowser (to install type "sudo apt-get install sqlitebrowser"), you can edit the *.db file

NOTE: You must have root priviledges and PMS must not be running because you cannot edit a file while it's being accessed.  To do this type in:

"sudo service plexmediaserver stop" then "sudo sqlitebrowser" 

Go to the "Browse Data" tab, then select the "media_parts" table from the drop down menu.  Click the magnifying glass (search function).  A "Find" window should pop up. 

Select the first drop down menu on this new window and select "file" (to search for the entry based on the file name).  For the next dropdown choose "contains" and then in the text box put a word that is unique to the movie's file name.  You should get a result returned that has the database table id number and the file name.  Double click the returned value to automatically jump to the row in the table. 

When you have the correct row for the movie file you're looking for, find the value of the "media_item_id" column.  Search for this value in the "id" column of the "media_items" table (back in the main window change the drop down box from "media_parts" to "media_items"). 

Change the value of the "width" column to 1920.  Save and exit.  Restart PMS and your movie should show "1080p" resolution!

This does work but it’s temporary. As soon as Plex rescans the data it puts the old values back.

Anyone know if it’s possible to modify the lower threshold for a title to be categorized as 1080p down to a value lower than 1920 (say 1880)? Thus, the system would apply the same rule for all titles in the library when analyzed.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.