Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Having trouble updating nfldb #290

Open
adilq93 opened this issue Nov 25, 2017 · 1 comment
Open

Having trouble updating nfldb #290

adilq93 opened this issue Nov 25, 2017 · 1 comment

Comments

@adilq93
Copy link

adilq93 commented Nov 25, 2017

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.

@ariannedee
Copy link

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');

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants