Newly released movies do not show rating

[ali_afalahi_com]

Server Version#: 1.18.2.2058
Player Version#: Latest Apple TV

Recent movies aren’t showing IMDB/Rotten Tomatoes ratings. Tried to remove them, re-add, refresh metadata, unmatch then match again but nothing worked. Examples: code 8, Zombieland Double Tap, Ad Astra etc

[FordGuy61]

Longstanding issue. There are multiple, older threads on this.

This is on Plex to fix. Nothing you can do.

Plex caches the info on one of their servers. When your PMS queries the Plex server, it returns a null value for the ratings information. You can try switching between ratings sources, but it seems there are always a few without ratings information, even for wide release movies. If you do change ratings sources, you must refresh the metadata to pick up the information.

Note 1: Plex license information for movies put into wide release - mass distribution in theaters (Ad Astra, Zombieland, etc). Shorts, small “art-house” movies, etc may not be included.

Note 2: If you have zero information for all of your movies then that is another matter. That usually points to a problem communicating with the Plex server holding the information. If that happens, check DNS, firewall, etc settings for issues communicating with plex.tv hosts.

[ceephour]

Select “Match”, then “Search options” take the year off the name (“Ad Astra 2019” to “Ad Astra”), change the Agent to “The Movie Database”.

[techdiver]

I posted this on another thread but putting it here too.

If you want to do this manually for titles that are missing the RT ratings you can do the following.

Steps to manually add RT ratings:

1. Downlaod and install SQLiteStudio.
2. In SQLiteStudio slect Database - Add Database and browse to you plex db located in C:\Users{user}\AppData\Local\Plex Media Server\Plug-in Support\Databases on windows. File is called “com.plexapp.plugins.library.db”.
3. Run the following command “select * from metadata_items where library_section_id in (2) and audience_rating is NULL order by added_at desc;”, replacing ‘2’ with what ever library section your movie files are in. You can see this in the “library_sections” table by scrolling to it in the left hand pane. This will display the list of titles with no audience rating (i.e. no RT ratings).
4. For the movies you can see listed there that have no rating, you can can look up the score on RT for them and put the critic score into the “rating” column and the audience scroe into the “audience_rating” column.
5. Point 4 above will insert the correct RT ratings but you still need to replace the “extra_data” column with the correct data to display the RT ratings. This is as below:

For critic fresh and audience fresh insert “at%3AaudienceRatingImage=rottentomatoes%3A%2F%2Fimage%2Erating%2Eupright&at%3AratingImage=rottentomatoes%3A%2F%2Fimage%2Erating%2Eripe&ex%3AhasPremiumPrimaryExtra=1&ex%3AprimaryExtraKey=%2Flibrary%2Fmetadata%2F205406&ma%3AchapterSource=media”

For critic rotten and audience rotten insert “at%3AaudienceRatingImage=rottentomatoes%3A%2F%2Fimage%2Erating%2Espilled&at%3AratingImage=rottentomatoes%3A%2F%2Fimage%2Erating%2Erotten&ex%3AhasPremiumExtras=1&ex%3AhasPremiumPrimaryExtra=1&ex%3AprimaryExtraKey=%2Flibrary%2Fmetadata%2F205222&ma%3AchapterSource=media”

for critic rotten and audience fresh insert “at%3AaudienceRatingImage=rottentomatoes%3A%2F%2Fimage%2Erating%2Eupright&at%3AratingImage=rottentomatoes%3A%2F%2Fimage%2Erating%2Erotten&ex%3AhasPremiumExtras=1&ex%3AhasPremiumPrimaryExtra=1&ex%3AprimaryExtraKey=%2Flibrary%2Fmetadata%2F205222&ma%3AchapterSource=media”

for critic fresh and audience rotten insert “at%3AaudienceRatingImage=rottentomatoes%3A%2F%2Fimage%2Erating%2Espilled&at%3AratingImage=rottentomatoes%3A%2F%2Fimage%2Erating%2Eripe&ex%3AhasPremiumExtras=1&ex%3AhasPremiumPrimaryExtra=1&ex%3AprimaryExtraKey=%2Flibrary%2Fmetadata%2F205222&ma%3AchapterSource=media”

Just overwrite whatever is in the “extra_data” column for the entries in question. Be careful not to modify anything else as you could cause issues with you library. If you do just manually refresh the metadata for the title you have issues with to revert these changes.