Discuss Gangs Inc.

Item: Paper Bullets

Language: en

Type of Problem: Incorrect_content

Extra Details: The API is returning OLD values even though sufficient time has passed for reindex of the record.

Help please!

Bob

8 replies (on page 1 of 1)

Jump to last post

I think the api re-indexes every 12 hours.

I was told 24 hours by Travis Bell, and the time period for this movie's reindex is well beyond that point. It almost seems as though the API record is locked.

HI,

that will be right, had in my mind it was just 12 hour.

I checked the api string and I think it returns it exactly like it is on the movie page:

http://api.themoviedb.org/3/movie/80167/casts?api_key=###

'{"id":80167,"cast":[{"id":89746,"name":"Joan Woodbury","character":"Rita Adams","order":0,"cast_id":3,"profile_path":"/iN5cJbzUThqlwbmVsoEkNiZ1Pi4.jpg"},{"id":99347,"name":"Jack La Rue","character":"Mickey Roman","order":1,"cast_id":4,"profile_path":"/hWOwpkNevqBwp2mrjMCrLrxvPsi.jpg"},{"id":933251,"name":"Linda Ware","character":"Donna Andrews","order":2,"cast_id":5,"profile_path":"/ufeESSJfGVbWYrMdWb4IPu4ttWh.jpg"},{"id":78793,"name":"John Archer","character":"Bob Elliott","order":3,"cast_id":6,"profile_path":"/9n1O3UN7bCoILvxKdA2L3yMqPTB.jpg"},{"id":13357,"name":"Vince Barnett","character":"Scribbler, a Petty Forger","order":4,"cast_id":7,"profile_path":"/vOvZ6SSFHNKRwxGwVbp7bA2vX2l.jpg"},{"id":2927,"name":"Gavin Gordon","character":"Kurt Parrish","order":6,"cast_id":8,"profile_path":"/frAA06Fwx5tEESM0Ly50ziV4NKO.jpg"},{"id":30510,"name":"Alan Ladd","character":"Jimmy Kelly aka Bill Dugan","order":5,"cast_id":9,"profile_path":"/1DuDOljdykH8HmiKFvO05HB68UP.jpg"},{"id":2927,"name":"Gavin Gordon","character":"Kurt Parrish","order":7,"cast_id":15,"profile_path":"/frAA06Fwx5tEESM0Ly50ziV4NKO.jpg"},{"id":140412,"name":"Phillip Trent","character":"Harold DeWitt","order":8,"cast_id":16,"profile_path":null},{"id":127521,"name":"William Halligan","character":"Police Chief Flynn","order":9,"cast_id":17,"profile_path":null},{"id":89253,"name":"George Pembroke","character":"Clarence DeWitt","order":10,"cast_id":18,"profile_path":null},{"id":105810,"name":"Selmer Jackson","character":"District Attorney","order":11,"cast_id":19,"profile_path":"/uOXVCzDMWcCmzRAbJ8M23Axqg9I.jpg"},{"id":34091,"name":"Kenneth Harlan","character":"Jim Adams","order":12,"cast_id":20,"profile_path":"/tBefmAZJJboB0obrsAshOFwT06X.jpg"},{"id":52175,"name":"Bryant Washburn","character":"Attorney Bruce King","order":13,"cast_id":21,"profile_path":null},{"id":56140,"name":"Alden 'Stephen' Chase","character":"Detective Joe Kent","order":14,"cast_id":22,"profile_path":null},{"id":34036,"name":"Robert Strange","character":"Lou Wood","order":15,"cast_id":23,"profile_path":null}],"crew":[{"id":103931,"name":"Phil Rosen","department":"Directing","job":"Director","profile_path":"/bkEhiu49mM8jiGSNiiv3vXQID0p.jpg"},{"id":115449,"name":"Martin Mooney","department":"Writing","job":"Story","profile_path":null},{"id":115449,"name":"Martin Mooney","department":"Writing","job":"Screenplay","profile_path":null},{"id":1047646,"name":"Arthur Martinelli","department":"Crew","job":"Cinematography","profile_path":null},{"id":1208368,"name":"George R. Batcheller Jr.","department":"Production","job":"Executive Producer","profile_path":null},{"id":19100,"name":"Maurice King","department":"Production","job":"Producer","profile_path":null}]}'

If you check the order id's you see that the actors are in the same order like on the webpage.

For instance:

"name":"Joan Woodbury","character":"Rita Adams","order":0,"

"name":"Jack La Rue","character":"Mickey Roman","order":1,"

...

name":"Gavin Gordon","character":"Kurt Parrish","order":7,"

...

"name":"Robert Strange","character":"Lou Wood","order":15,"

What tool you are using too scrape the api?

I am using PLEX. I have deleted this movie multiple times from my database, and started fresh with this movie. Each time, values returned from TMDB are the old values with star order "Alan Ladd, Joan Woodbury, Jack La Rue" respectively and should be "Joan Woodbury, Jack La Rue, Linda Ware" respectively. Also the old Overview is returned which is a definite indication that something is wrong. The OLD or incorrect values are returned by searching for either 'Gangs, Inc.' or 'Paper Bullets'.

How do I know if the record is deleted from my database? When I build a new record for this movie, it is the last record in the database and the only record having a "title" value of "Gangs, Inc.". I have verified this each and every time. Should you be interested and / or ask, these records are stored in the PLEX table "metadata_items" in an SQLite database.

Is there documentation on how to look at the API values? The link you provided is neither self explanatory nor usable.

Regards, Bob

If I am honest, I don't know anything about plex.

But what I can say is that the api is returning the request as expected, the flaw might be the scraper that plex is using. The scraper is that one who is requesting the informations via the tmdb api and filling it in your database.

Is there documentation on how to look at the API values? The link you provided is neither self explanatory nor usable.

The full documentation you can find here: http://docs.themoviedb.apiary.io/

The link is what your scraper is supposed to do, to get the right information.

http://api.themoviedb.org/3/movie/80167/casts?api_key=###

In this case I just asked for the cast of the movie 80167 (Paper Bullets)

And what you see under the link in the post above is that what the api returns.

What is missing in the link is a proper api key (###), that one is unique and so I can not write this one down here, but if you wanna play around with the api then you can apply for it under your user profil.

Thank you very much! You have been most helpful, and this helps greatly!

In using the key that PLEX uses, the following cast info is returned from http://api.themoviedb.org/3/movie/80167/casts?api_key=### :

{"id":80167,"cast":[{"id":89746,"name":"Joan Woodbury","character":"Rita Adams","order":0,"cast_id":3,"profile_path":"/iN5cJbzUThqlwbmVsoEkNiZ1Pi4.jpg"}, {"id":99347,"name":"Jack La Rue","character":"Mickey Roman","order":1,"cast_id":4,"profile_path":"/hWOwpkNevqBwp2mrjMCrLrxvPsi.jpg"}, {"id":933251,"name":"Linda Ware","character":"Donna Andrews","order":2,"cast_id":5,"profile_path":"/ufeESSJfGVbWYrMdWb4IPu4ttWh.jpg"}, {"id":78793,"name":"John Archer","character":"Bob Elliott","order":3,"cast_id":6,"profile_path":"/9n1O3UN7bCoILvxKdA2L3yMqPTB.jpg"}, {"id":13357,"name":"Vince Barnett","character":"Scribbler, a Petty Forger","order":4,"cast_id":7,"profile_path":"/vOvZ6SSFHNKRwxGwVbp7bA2vX2l.jpg"}, {"id":2927,"name":"Gavin Gordon","character":"Kurt Parrish","order":6,"cast_id":8,"profile_path":"/frAA06Fwx5tEESM0Ly50ziV4NKO.jpg"}, {"id":30510,"name":"Alan Ladd","character":"Jimmy Kelly aka Bill Dugan","order":5,"cast_id":9,"profile_path":"/1DuDOljdykH8HmiKFvO05HB68UP.jpg"}, {"id":2927,"name":"Gavin Gordon","character":"Kurt Parrish","order":7,"cast_id":15,"profile_path":"/frAA06Fwx5tEESM0Ly50ziV4NKO.jpg"}, {"id":140412,"name":"Phillip Trent","character":"Harold DeWitt","order":8,"cast_id":16,"profile_path":null}, {"id":127521,"name":"William Halligan","character":"Police Chief Flynn","order":9,"cast_id":17,"profile_path":null}, {"id":89253,"name":"George Pembroke","character":"Clarence DeWitt","order":10,"cast_id":18,"profile_path":null}, {"id":105810,"name":"Selmer Jackson","character":"District Attorney","order":11,"cast_id":19,"profile_path":"/uOXVCzDMWcCmzRAbJ8M23Axqg9I.jpg"}, {"id":34091,"name":"Kenneth Harlan","character":"Jim Adams","order":12,"cast_id":20,"profile_path":"/tBefmAZJJboB0obrsAshOFwT06X.jpg"}, {"id":52175,"name":"Bryant Washburn","character":"Attorney Bruce King","order":13,"cast_id":21,"profile_path":null}, {"id":56140,"name":"Alden 'Stephen' Chase","character":"Detective Joe Kent","order":14,"cast_id":22,"profile_path":null}, {"id":34036,"name":"Robert Strange","character":"Lou Wood","order":15,"cast_id":23,"profile_path":null}], "crew":[{"id":103931,"name":"Phil Rosen","department":"Directing","job":"Director","profile_path":"/bkEhiu49mM8jiGSNiiv3vXQID0p.jpg"}, {"id":115449,"name":"Martin Mooney","department":"Writing","job":"Story","profile_path":null}, {"id":115449,"name":"Martin Mooney","department":"Writing","job":"Screenplay","profile_path":null}, {"id":1047646,"name":"Arthur Martinelli","department":"Crew","job":"Cinematography","profile_path":null}, {"id":1208368,"name":"George R. Batcheller Jr.","department":"Production","job":"Executive Producer","profile_path":null}, {"id":19100,"name":"Maurice King","department":"Production","job":"Producer","profile_path":null}]}

The only change I made to the data is to edit in carriage returns for each member to provide greater legibility. While this data appears to be identical to your data, I will now have to dig further to see what else may be causing the problem I am having.

Later today, I will start reading the API doc. Again, thank you for your help.

Regards, Bob

It took me awhile, but I found the problem. PLEX metatdata agents each cache data. Once I deleted the cache for TMDB, the problem was resolved. Again, thank you for your help. I have learned a great deal!

Regards, Bob

You are welcome. At least we know now as well what causes inconsistency between the databases if somebody has a similar problem in the future.

Can't find a movie or TV show? Login to create it.

Global

s focus the search bar
p open profile menu
esc close an open window
? open keyboard shortcut window

On media pages

b go back (or to parent when applicable)
e go to edit page

On TV season pages

(right arrow) go to next season
(left arrow) go to previous season

On TV episode pages

(right arrow) go to next episode
(left arrow) go to previous episode

On all image pages

a open add image window

On all edit pages

t open translation selector
ctrl+ s submit form

On discussion pages

n create new discussion
w toggle watching status
p toggle public/private
c toggle close/open
a open activity
r reply to discussion
l go to last reply
ctrl+ enter submit your message
(right arrow) next page
(left arrow) previous page

Settings

Want to rate or add this item to a list?

Login