nfldb icon indicating copy to clipboard operation
nfldb copied to clipboard

Having trouble updating nfldb

Open adilq93 opened this issue 8 years ago • 1 comments

Hello, I just downloaded and installed nfldb. I can't seem to update it to have more recent statistics. I can query data from like the 2012 season but can't from the current season.

So I run nfldb-update and I run into this error,

"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"."

I have read a little bit about this from previous issues, but none of the proposed solutions are working for me.

adilq93 avatar Nov 25 '17 21:11 adilq93

insert into team values('JAX','Jacksonville', 'Jaguars'); #194

You will also run into a problem with the LA Chargers, so do this too: insert into team values ('LAC', 'Los Angeles', 'Chargers');

ariannedee avatar Nov 28 '17 18:11 ariannedee