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

Deleting a developer client throws (My)SQL error #2350

Closed
Strubbl opened this issue Oct 3, 2016 · 0 comments · Fixed by #2351
Closed

Deleting a developer client throws (My)SQL error #2350

Strubbl opened this issue Oct 3, 2016 · 0 comments · Fixed by #2351
Labels
Milestone

Comments

@Strubbl
Copy link
Contributor

Strubbl commented Oct 3, 2016

Issue details

i get the following error

500: Internal Server Error

An exception occurred while executing 'DELETE FROM wallabag_oauth2_clients WHERE id = ?' with params [1]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`wallabagv2`.`wallabag_oauth2_refresh_tokens`, CONSTRAINT `FK_19C9FB1245EB1234` FOREIGN KEY (`client_id`) REFERENCES `wallabag_oauth2_clients` (`id`))

instead of my developer client being deleted.

Environment

  • wallabag version (or git revision) that exhibits the issue: 2.1 and 2.0.7
  • How did you install wallabag? Via git clone or by downloading the package? git clone
  • Last wallabag version that did not exhibit the issue (if applicable): i don't know
  • php version: 5.6.24-0+deb8u1
  • OS: debian jessie
  • type of hosting (shared or dedicated): dedicated
  • which storage system you choose at install (SQLite, MySQL/MariaDB or PostgreSQL): mysql

Steps to reproduce/test case

Please provide necessary steps for reproduction of this issue, or better the
reduced test case (without any external dependencies, if possible).

  1. Go to developer menu
  2. click on an existing client to open it
  3. click the button "delete client"
  4. get redirected to /developer/client/delete/1 page showing the above mentioned error
@Strubbl Strubbl changed the title Deleting a developer client throws error Deleting a developer client throws (My)SQL error Oct 3, 2016
@nicosomb nicosomb added this to the 2.1.2 milestone Oct 3, 2016
@nicosomb nicosomb added the Bug label Oct 3, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants