Podpora The Movie Database
Podpora → Podpora API
Strange bug in specific TMDb query
zveřejnil anderbytesSTAFFMOD 27.04.2016 v 10:08 ODP.
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.
Odpověď od Travis Bell
28.04.2016 v 5:22 ODP.
Hi anderbytes,
Thanks for the report. I've created a new ticket for this here. It's a weird one, no doubt.
Cheers.
Odpověď od anderbytes
02.05.2016 v 2:58 ODP.
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!
Odpověď od Travis Bell
02.05.2016 v 3:55 ODP.
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.Odpověď od anderbytes
02.05.2016 v 10:39 ODP.
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
Odpověď od Travis Bell
03.05.2016 v 10:42 DOP.
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.Odpověď od anderbytes
03.05.2016 v 10:44 DOP.
Thanks for the tip. Will pay attention to that next time before posting. :-)