Server Version#: 1.18.3.2156
Player Version#:
for the past few weeks, new titles added to server no longer add Rotten Tomato ratings. Is there an issue with where they load from? I refresh metadata with no improvement.
2 Likes
I’m seeing the same thing.
2 Likes
Can you look up the titles on the IMDb and look if they are using a 8-figure ID number? If so, then that’s a known issue that’s being actively investigated.
Not OP, but all of the ones I’ve spot-checked have a 7-digit ID. Most of the time when refreshing metadata I get no rating at all. Sometimes I get the IMDB rating. I have not gotten a single RT rating on any piece of content I’ve checked today (refreshed about 15 titles as a test).
Plex Metadata agent in first position. RT set in config for rating. Something is definitely funky.
1 Like
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:
- Downlaod and install SQLiteStudio.
- 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”.
- 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).
- 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.
- 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.
1 Like
I checked and most are a 7 digit ID, now IMDB is pulling in more regularly but RT is still a bust. For example, a new title “Jexi” is pulling neither imdb or RT.
I have my movie libraries set to rotten tomatoes, some come through, but others come instead with IMDB ratings.
I don’t know if IMDB ratings are a fallback when RT fails, but it is very annoying to have mixed rating systems.
That’s the same for me. Seems to be progress on the previous issue whereby no rating was displayed at all, but annoying as you say when you are supposed to have RT and it reverts to IMDB.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
