Page 1 of 1

MD5 Mismatches

Posted: Tue Jun 03, 2014 8:19 pm
by achuk
Hello,

I'm retrieving schedules and attempting to cache the programs. Unfortunately some of the MD5s don't match between the schedules and programs api calls.

For example:

from 20131021/schedules/:

{"programID":"SH007507550000","md5":"p52EZei2niDJ4zFwoq7usw","airDateTime":"2014-06-02T03:00:00Z","duration":1800,"new":true,"audioProperties":["cc","stereo"]}

from 20131021/programs/:

{"programID":"SH007507550000","titles":{"title120":"CTV News"},"originalAirDate":"2005-05-09","genres":["News"],"showType":"Series","md5":"nnKyGdbKDXP+TrpqWtmsUA"}

I save the program result to my database cache but since the MD5s don't match it gets requested again on subsequent calls. I have ~244 episodes/shows with this issue. Is there something I'm missing in processing the MD5s from schedules and programs?

Thanks in advance.

Adrian

Re: MD5 Mismatches

Posted: Wed Jun 04, 2014 8:19 am
by rkulagow
I'll have to dig into the code and see what's what; the MD5 in the program should match what's in the schedule, so something is going wrong in the generation of the JSON.

Which stationID had the mismatch?

Re: MD5 Mismatches

Posted: Thu Jun 05, 2014 4:39 am
by achuk
In this instance it was from stationID 10106. Oddly today it seems to have fixed itself. When I re-run my app that show is returning the proper md5 from the schedules endpoint.

There is a second issue I'm seeing where the MD5s are returned simply as "1" from the schedules endpoint. Getting the same show from programs gets (what appears to be) the proper MD5.

For example from schedules (from stationID 10106)

POST https://json.schedulesdirect.org/20131021/schedules
Data: {"request": ["46245", "44792", "77774", "10133", "44784", "10106", "72720", "60123", "72614", "70583", "10119", "73018", "10125", "73269", "78597", "60344", "73152"]}

...
{"programID":"EP004613250151","md5":"1","airDateTime":"2014-06-04T23:00:00Z","duration":1800,"contentRating":[{"body":"USA Parental Rating","code":"TV14"}],"audioProperties":["cc","stereo"]}
...


and from the programs endpoint:

{"programID":"EP004613250151","titles":{"title120":"Degrassi: The Next Generation"},"descriptions":{"description1000":[{"descriptionLanguage":"en","description":"Ashley becomes very controlling while she and Jimmy work toward their music career."}]},"originalAirDate":"2007-10-19","genres":["Drama"],"episodeTitle150":"It's Tricky","metadata":[{"Tribune":{"season":7,"episode":4}}],"images":[{"uri":"assets\/p185793_b_v5_aa.jpg","dimension":"w=240px|h=360px"}],"cast":[{"personId":"309891","nameId":"314696","name":"Miriam McDonald","role":"Actor","billingOrder":"01"},{"personId":"278237","nameId":"281916","name":"Cassie Steele","role":"Actor","billingOrder":"02"},{"personId":"297787","nameId":"301711","name":"Jake Goldsbie","role":"Actor","billingOrder":"03"},{"personId":"371287","nameId":"380162","name":"Aubrey Graham","role":"Actor","billingOrder":"04"},{"personId":"385364","nameId":"394239","name":"Shane Kippel","role":"Actor","billingOrder":"05"},{"personId":"173761","nameId":"175254","name":"Lauren Collins","role":"Actor","billingOrder":"06"},{"personId":"338928","nameId":"347802","name":"Sarah Barrable-Tishauer","role":"Actor","billingOrder":"07"},{"personId":"228536","nameId":"231567","name":"Stefan Brogren","role":"Actor","billingOrder":"08"},{"personId":"427811","nameId":"436686","name":"Amanda Stepto","role":"Actor","billingOrder":"09"},{"personId":"398659","nameId":"407534","name":"Melissa McIntyre","role":"Actor","billingOrder":"10"},{"personId":"491047","nameId":"504646","name":"Stacey Farber","role":"Actor","billingOrder":"11"},{"personId":"520819","nameId":"539346","name":"Adamo Ruggiero","role":"Actor","billingOrder":"12"},{"personId":"392203","nameId":"401078","name":"Mike Lobel","role":"Actor","billingOrder":"13"},{"personId":"507001","nameId":"521612","name":"Deanna Casaluce","role":"Actor","billingOrder":"14"},{"personId":"486097","nameId":"496222","name":"Shenae Grimes","role":"Actor","billingOrder":"15"},{"personId":"524569","nameId":"545140","name":"Dalmar Abuzeid","role":"Actor","billingOrder":"16"},{"personId":"287397","nameId":"291171","name":"Jamie Johnston","role":"Actor","billingOrder":"17"},{"personId":"158329","nameId":"158682","name":"Marc Donato","role":"Actor","billingOrder":"18"},{"personId":"505342","nameId":"519779","name":"Nina Dobrev","role":"Actor","billingOrder":"19"},{"personId":"362098","nameId":"370973","name":"Mazin Elsadig","role":"Actor","billingOrder":"20"},{"personId":"524572","nameId":"545143","name":"Steve Belford","role":"Actor","billingOrder":"21"},{"personId":"185477","nameId":"187076","name":"Charlotte Arnold","role":"Actor","billingOrder":"22"},{"personId":"524573","nameId":"545144","name":"Raymond Ablack","role":"Actor","billingOrder":"23"},{"personId":"524574","nameId":"545145","name":"Samantha Munro","role":"Actor","billingOrder":"24"},{"personId":"524575","nameId":"545146","name":"Scott Paterson","role":"Actor","billingOrder":"25"},{"personId":"524576","nameId":"545147","name":"Nathaniel Stephenson","role":"Actor","billingOrder":"26"}],"showType":"Series","md5":"Pp\/flx78T6+OVVfvfKSspw"}

Thanks again for your help.

Adrian

Re: MD5 Mismatches

Posted: Thu Jun 05, 2014 5:24 am
by rkulagow
There are some temporary tables that are used; it looks like some of that is leaking through into the actual data. I will investigate.

Re: MD5 Mismatches

Posted: Thu Jun 05, 2014 11:40 am
by rkulagow
I'm regenerating the program data; everything should be refreshed shortly. At that point I'll check to see if there are still issues with the MD5.

Re: MD5 Mismatches

Posted: Thu Jun 05, 2014 1:46 pm
by rkulagow
The refresh was done a while ago; please let me know if you're still having issues with the data.

Re: MD5 Mismatches

Posted: Thu Jun 05, 2014 3:13 pm
by achuk
That did it. Everything is lining up now.

Thanks!