search

mynttt / UpdateTool

A tool to update the IMDB ratings for Plex libraries that contain movies/series and use the IMDB agent to receive ratings
GNU General Public License v3.0
250 stars 12 forks source link

Wrong rating? #19

Closed CasperNielsen closed 4 years ago

CasperNielsen commented 4 years ago

Having some problems with some shows, the ratings is way to low.

Eks. (There is more shows than this)

[INFO ] - 2020-03-18 13:57:30 @ ImdbTransformer.updateMetadata: Adjust rating: 7.5 -> 3.4 for Star Trek: Picard [INFO ] - 2020-03-18 13:57:30 @ ImdbTransformer.updateMetadata: Adjust rating: 8.5 -> 5.0 for Prodigal Son

Where is the tool getting these low ratings from? :)

mynttt commented 4 years ago

Do you use DVD order with your plex library?

I can look into it but you'll have to upload the following files to pastebin:

Remove the API details within the first few lines of the log if you don't want to expose your credentials.

mynttt commented 4 years ago

Also helpful would be the output of running this query on your plex database:

SELECT guid, title FROM metadata_items WHERE title = 'Star Trek: Picard';
CasperNielsen commented 4 years ago

Compressed file.zip

Here is the log files and SQL output :)

Not sure about the DVD order, have never heard of that in Plex.

mynttt commented 4 years ago

I guess DVD order will not be a problem then, Plex defaults to Aired which this tool uses to resolve TVDB id's.

My guess is that for some reason there is some mismatch or wrong involvement happening, I'll investigate it tomorrow and find the cause hopefully.

mynttt commented 4 years ago

Issue seems to that the TV series are TMDB matched which I was not aware of (my TV series are all TVDB matched).

So these TV series are probably treated as movies which would explain the wrong ratings.

I would investigate further tomorrow, it would be helpful to get your TV show database as SQL dump, so I can insert it into my development copy to reproduce your library behavior.

Another csv dump with this query would help me with that.

SELECT * FROM metadata_items WHERE library_section_id = 1;

Thanks for bringing this issue up! This definitely needs to be fixed.

mynttt commented 4 years ago

Has been fixed with f1e2bdd972e75958c6e76cd996f9341b3d71ec04.

The issue was that your Library reported being of TVDB but had some items TMDB matched. So the pipeline tried to resolve these TMDB items via TVDB which does not work at all.

TV Show matching for TMDB has been added now and the tool will now also process libraries that use the TMDB agent for TV shows.

One run should fix your mismatched ratings again.