2016 Data Not Showing

[goobs-746]

I am not great with code so might have been something on my end when installing/setting up, but is there any reason why I would have data for all years but 2016 available? I have tried running nfldb-update a few times but the problem persists. It has the schedule for all games, but scores and play data don't have anything there.

[gatortim]

Seeing similar behaviour. Also, update continuously fails:
psycopg2.IntegrityError: insert or update on table "play" violates foreign key constraint "play_pos_team_fkey"
DETAIL: Key (pos_team)=(JAX) is not present in table "team".

JAC is present in the table, but JAX is not.

Is there a newer version of nfldb.sql that is required? I tried downloading the latest nfldb.sql but to no avail.
Reinstalling from scratch did not seem to resolve.

[gatortim]

As postgresql nfldb user:
INSERT INTO team(team_id, city, name) VALUES('JAX', 'Jacksonville', 'Jaguars');

Then run update (again). It took me two runs of update.

Still need to alter any other constants for Jacksonville after the update.

[matthewcampbell10]

Did you find a solution to this? I am having the same issue. I am relatively knew to all of this stuff so not sure how i would run INSERT INTO team(team_id, city, name) VALUES('JAX', 'Jacksonville', 'Jaguars');
Is that done from the command prompt or postgresql?