We are having problems in XBMC/Kodi that the API returns additional garbage to Actors names.
http://api.tmdb.org/3/movie/3170/casts?api_key=57983e31fb435df4df77afb854740ea9
See: {"credit_id":"52fe438cc3a36847f805caf3","department":"Writing","id":148822,"job":"Storyboard","name":"Ralph Wright\t","profile_path":null},
"Ralph Wright\t"
The extra \t causes a tab being doing in the text field. We have found this case but there may be more.
Regards, Martijn Team-Kodi
.לא מצאת סרט או סדרה? היכנס כדי ליצור אותם
?רוצה לדרג או להוסיף פריט אל רשימה
?לא חבר אתר
תגובה מאת Travis Bell
ב-מאי 18, 2015 ב-3:04אחרי חצות יום
Hi Martijn,
Thanks for pointing this out. I'll make sure we're properly sanitizing these inputs. It's likely that we are now but on older records like this, we possibly weren't years ago when they were originally added.
תגובה מאת zag
ב-מאי 21, 2015 ב-3:47אחרי חצות יום
Thanks!
Is there a possibility of fixing the current data?
I just tested name: "Ralph Wright ", and it is indeed still a tab at the end.
EDIT: maybe this http://lists.mysql.com/mysql/195303
תגובה מאת Travis Bell
ב-מאי 21, 2015 ב-4:22אחרי חצות יום
We don't use MySQL, but yes, it's possible to do a bulk cleanup. It will be part of the fix for this ticket.
I'm unlikely to find time this week for this, but I have created a ticket for this and will look into it when I get some time.
תגובה מאת Martijn
ב-מאי 23, 2015 ב-11:58לפני חצות יום
thx. Let me know when you did the clean up. We'll do an additional cleanup on user's side for existing installations.