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.

Sign up for GitHub

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

Deletion of lists fails with mysql exception #321

Open
vjrj opened this issue Nov 26, 2024 · 0 comments · Fixed by #322
Open

Deletion of lists fails with mysql exception #321

vjrj opened this issue Nov 26, 2024 · 0 comments · Fixed by #322

Comments

@vjrj
Copy link
Collaborator

vjrj commented Nov 26, 2024

Trying to delete a just created species lists fails with a mysql exception:

"java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`specieslists`.`species_list_item`, CONSTRAINT `FKflnlmsjs4mhw75g6ovtaebor8` FOREIGN KEY (`matched_species_id`) REFERENCES `matched_species` (`id`))"

This happens using 5.2.3.
vjrj added a commit that referenced this issue Nov 26, 2024
@vjrj
Fix for #321
409e2fc
@vjrj vjrj mentioned this issue Nov 26, 2024
Merged
@nickdos nickdos reopened this Nov 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Delete lists without mysql exceptions AtlasOfLivingAustralia/specieslist-webapp
2 participants
@vjrj @nickdos