No data for the Miami and Tampa Bay Week 11 - 2017 game

[mesee298]

There is no data in any of the tables for this game except for the game table. This was supposed to be their bye week, but it was moved back to week 1.

How can I get that data?

[mesee298]

Also checked in nflgame, and there is nothing their either.

[ochawkeye]

All of the stats for this game show up for me. Try force updating your schedule?

On Nov 19, 2017 3:47 PM, "mesee298" notifications@github.com wrote:

Also checked in nflgame, and there is nothing their either.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/BurntSushi/nfldb/issues/288#issuecomment-345552464, or mute the thread https://github.com/notifications/unsubscribe-auth/AC237StxB-bfBvcf2MixMot4Ens0_jDcks5s4KHTgaJpZM4QjjbT .

[mesee298]

I’m confused on how the database can be correct, but not the Json? Any who, what is the command to update the schedule, and how often should it be ran manually?

[ochawkeye]

I’m confused on how the database can be correct, but not the Json?

Doesn't sound like your datebase is correct...

Any who, what is the command to update the schedule...

From your python scripts folder: python nflgame-update-schedule --year 2017

,,,and how often should it be ran manually?

Any time the NFL schedule changes which is surprisingly often. Normally, nfldb-update takes care of this for you by refreshing the current week by default. But your case was pretty rare with a game getting rescheduled. The NFL does allow itself to flex games into Sunday night from week 5 on, though, so it's not entirely out of the realm of possibility that the NFL would change the schedule on you and nflgame|nfldb wouldn't have any idea that it happened unless you diligently use it every week.

[ariannedee]

@mesee298 I found an issue in nflgame that was causing update_sched.py to update from the wrong url (postseason instead of regular).

You can see in my answer here, but the short answer is:

In nflgame/live.py, line 73 needs to be commented out and line 68 commented in.

Then when you run python update_sched.py --year 2017 it should be getting up-to-date game info.

[MargareeMan]

@mesee298 and @ochawkeye and @ariannedee I apologize to everyone. I did not see this issue and I opened an issue to indicate how I solved this issue (and how it occurred for me in the first place). See #308 . The data for this game (and all related tables: drive, play and play_player) is in the post. the agg_play updates automatically when you insert the data into play_player.