0

Possible Bug Discovered

After validating user credentials, I attempt to query for each team's rosters in the league. 2 of the 16 rosters do not load.

The following rosters will NOT load:
CODE
select * from fantasysports.teams.roster where team_key='238.l.142667.t.8' and date='2010-06-22'

CODE
select * from fantasysports.teams.roster where team_key='238.l.142667.t.14' and date='2010-06-22'


Obviously no one here can test this without the user validating his credentials, but I hope that a Yahoo! developer can take a look and figure out why it returns result as "blank".


CODE
select * from fantasysports.teams.roster where team_key='238.l.142667.t.8' and date='2010-06-22'

Array
(
[0] => Array
(
[url] => http://query.yahooapis.com/v1/yql?callback=cbfunc&format=xml&q=select%20%2A%20from%20fantasysports.teams.roster%20where%20team_key%3D%27238.l.142667.t.8%27%20and%20date%3D%272010-06-22%27
[content_type] => text/javascript;charset=utf-8
[http_code] => 200
[header_size] => 488
[request_size] => 1272
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0.20554
[namelookup_time] => 3.3E-5
[connect_time] => 0.004798
[pretransfer_time] => 0.004804
[size_upload] => 0
[size_download] => 93
[speed_download] => 452
[speed_upload] => 0
[download_content_length] => -1
[upload_content_length] => -1
[starttransfer_time] => 0.205496
[redirect_time] => 0
)

[1] => HTTP/1.1 200 OK
Date: Tue, 22 Jun 2010 20:14:46 GMT
P3P: policyref="http://info.yahoo.com/w3c/p3p.xml", CP="CAO DSP COR CUR ADM DEV TAI PSA PSD IVAi IVDi CONi TELo OTPi OUR DELi SAMi OTRi UNRi PUBi IND PHY ONL UNI PUR FIN COM NAV INT DEM CNT STA POL HEA PRE LOC GOV"
Access-Control-Allow-Origin: *

Cache-Control: public, max-age=59
Vary: Accept-Encoding
Content-Type: text/javascript;charset=utf-8
Age: 0
Transfer-Encoding: chunked
Connection: keep-alive
Server: YTS/1.17.21


[2] => cbfunc({"query":{"count":"0","created":"2010-06-22T08:14:46Z","lang":"en-US"},"results":[]});
)

by
4 Replies
  • Seems as though I screwed up the formating in my original post. Hopefully this wraps all of the code.

    CODE
    select * from fantasysports.teams.roster where team_key='238.l.142667.t.8' and date='2010-06-22'

    Array
    (
    [0] => Array
    (
    [url] => http://query.yahooapis.com/v1/yql?callback=cbfunc&format=xml&q=select%20%2A%20from%20fantasysports.teams.roster%20where%20team_key%3D%27238.l.142667.t.8%27%20and%20date%3D%272010-06-22%27
    [content_type] => text/javascript;charset=utf-8
    [http_code] => 200
    [header_size] => 488
    [request_size] => 1272
    [filetime] => -1
    [ssl_verify_result] => 0
    [redirect_count] => 0
    [total_time] => 0.20554
    [namelookup_time] => 3.3E-5
    [connect_time] => 0.004798
    [pretransfer_time] => 0.004804
    [size_upload] => 0
    [size_download] => 93
    [speed_download] => 452
    [speed_upload] => 0
    [download_content_length] => -1
    [upload_content_length] => -1
    [starttransfer_time] => 0.205496
    [redirect_time] => 0
    )

    [1] => HTTP/1.1 200 OK
    Date: Tue, 22 Jun 2010 20:14:46 GMT
    P3P: policyref="http://info.yahoo.com/w3c/p3p.xml", CP="CAO DSP COR CUR ADM DEV TAI PSA PSD IVAi IVDi CONi TELo OTPi OUR DELi SAMi OTRi UNRi PUBi IND PHY ONL UNI PUR FIN COM NAV INT DEM CNT STA POL HEA PRE LOC GOV"
    Access-Control-Allow-Origin: *
    Cache-Control: public, max-age=59
    Vary: Accept-Encoding
    Content-Type: text/javascript;charset=utf-8
    Age: 0
    Transfer-Encoding: chunked
    Connection: keep-alive
    Server: YTS/1.17.21


    [2] => cbfunc({"query":{"count":"0","created":"2010-06-22T08:14:46Z","lang":"en-US"},"results":[]});
    )
    0
  • what happens with the following query ?

    select * from fantasysports.teams.roster where league_key='238.l.142667'

    do you get team 2 and team 16 in the xml ?
    0
  • There are 16 teams in that league, numbered 1 through 18, and teams 2 and 14 simply don't exist. The team numbers aren't always going to be sequential.
    0
  • QUOTE (Pickemfirst Dev @ Jun 22 2010, 06:23 PM) <{POST_SNAPBACK}>
    what happens with the following query ?

    select * from fantasysports.teams.roster where league_key='238.l.142667'

    do you get team 2 and team 16 in the xml ?



    QUOTE (Shane K @ Jun 22 2010, 06:38 PM) <{POST_SNAPBACK}>
    There are 16 teams in that league, numbered 1 through 18, and teams 2 and 14 simply don't exist. The team numbers aren't always going to be sequential.


    Thanks guys. I was assuming it was sequential. It's fixed now :)
    0

Recent Posts

in Fantasy Sports API