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

Jump to bottom

After upgrade to 3.0.2 deleting a user throws Integrity constraint violation: 1451 #11523

Closed
bmartinGithub opened this issue Mar 24, 2017 · 1 comment
Closed

After upgrade to 3.0.2 deleting a user throws Integrity constraint violation: 1451 #11523

bmartinGithub opened this issue Mar 24, 2017 · 1 comment
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@bmartinGithub
Copy link

After we upgraded to 3.0.2 I tried to delete a user account but I'm getting the following error:

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (db_piwik.piwik_user_dashboard, CONSTRAINT FK_login_IN_piwik_user_dashboard FOREIGN KEY (login) REFERENCES piwik_user (login))

I tried a second account thinking maybe it was just that one that somehow became corrupt but I get this error when I try to delete any account.
@mattab
Copy link
Member

mattab commented May 8, 2017

We don't use foreign keys in Piwik so it should be something added by someone on your end?

@mattab mattab closed this as completed May 8, 2017
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label May 8, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@bmartinGithub @mattab