Sprijin Bază de date filme (The Movie Database)
Sprijin → Sprijin API
Strange bug in specific TMDb query
postat de către anderbytesSTAFFMOD pe data de 27 aprilie 2016 la ora 10:08PM
I'm not sure how... but in the URL below, some parameters are breaking the query.
-- DOESN't WORKS (returns no overview)
http://api.themoviedb.org/3/movie/5994?api_key=###API_KEY_HERE###&language=pt-BR&include_image_language=pt-BR,null,en
-- WORKS (returns correctly)
http://api.themoviedb.org/3/movie/5994?api_key=###API_KEY_HERE###&language=pt-BR&include_image_language=pt-BR,en
http://api.themoviedb.org/3/movie/5994?api_key=###API_KEY_HERE###&language=pt-BR&include_image_language=pt-BR,null
http://api.themoviedb.org/3/movie/5994?api_key=###API_KEY_HERE###&language=pt-BR&include_image_language=pt-BR,en,null
http://api.themoviedb.org/3/movie/5994?api_key=###API_KEY_HERE###&language=pt-BR&include_image_language=pt-BR,null,fr
for some reason... when is asked to include images and the exact pt-BR.null,en order is specified... it returns English metadata, even there's pt-BR data in TMDB.
Răspuns de Travis Bell
pe data de 28 aprilie 2016 la ora 5:22PM
Hi anderbytes,
Thanks for the report. I've created a new ticket for this here. It's a weird one, no doubt.
Cheers.
Răspuns de anderbytes
pe data de 2 mai 2016 la ora 2:58PM
Don't know if something has been done.... but now the original query above works normaly.
I'd like to complement this thread with another strange issue that I just found today concerning collections:
http://api.themoviedb.org/3/collection/121938?api_key=###API_KEY_HERE####&append_to_response=images&language=pt-BR&include_image_language=pt-br,null,en --> field "Overview" returns "" (correct, empty string)
http://api.themoviedb.org/3/collection/119?api_key=###API_KEY_HERE####&append_to_response=images&language=pt-BR&include_image_language=pt-br,null,en --> field "Overview" returns NULL (incorrect... can cause errors in clients)
Can you please investigate why the 2nd one brings nulls ?? Empty is expected. From TheMovieDB website I can't tell what is causing this, they seem both correctly filled with data.
Thanks!
Răspuns de Travis Bell
pe data de 2 mai 2016 la ora 3:55PM
Ohhhhhh, so your first one was probably just the cache. I didn't even look to see if you had updated the data on the 27th (and you did). The API will cache data for 6-8 hours so after making changes on the website and the item is already in cache, you'll have to wait for the item to be purged.
Re: null overviews, all of the movie and collection responses will return null if the translation doesn't exist... this is something I can look at updating later.
nullis a perfectly valid JSON data type like a string or an integer. It shouldn't cause any problems.Răspuns de anderbytes
pe data de 2 mai 2016 la ora 10:39PM
Strange... I recall translating those collections yesterday.... and now they don't seem to have in my language. Well... I'll just translate them again, and check back tomorrow morning.
About the "empty vs null". The thing is.... the query returned lot of pt-BR data (title, parts, that existed yesterday... I swear) , but NULL in overview.
Maybe some type of row corruption in DB? Next time I'll have the care of copying the result JSON
Răspuns de Travis Bell
pe data de 3 mai 2016 la ora 10:42AM
Different params will force a new item into the cache so depending when an original request was made and then when the data was edited AND if you are playing around with different params you will get different versions of the assets. So the long and short of it is you can't really dig too much into anything until you know the data has been refreshed which is always just best to wait the ~6 hours after an edit.
You can also check the
X-Memc-Expiresheader to see when exactly the cached item will expire in seconds.Răspuns de anderbytes
pe data de 3 mai 2016 la ora 10:44AM
Thanks for the tip. Will pay attention to that next time before posting. :-)