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

[Bug]: Foreign key violation when deleting a room #279

Closed
2 tasks done
CubicrootXYZ opened this issue Jun 9, 2024 · 0 comments · Fixed by #281
Closed
2 tasks done

[Bug]: Foreign key violation when deleting a room #279

CubicrootXYZ opened this issue Jun 9, 2024 · 0 comments · Fixed by #281
Labels
beta bug Something isn't working

Comments

@CubicrootXYZ
Copy link
Owner

Describe the bug

When deleting a room the following constraint is violated:

Failed to handle membership leave with: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`remindme`.`matrix_rooms_matrix_users`, CONSTRAINT `fk_matrix_rooms_matrix_users_matrix_room` FOREIGN KEY (`matrix_room_id`) REFERENCES `matrix_rooms` (`id`))

Reproduce the bug

  1. Invite bot to channel
  2. Remove it from the channel
  3. See application logs for error message

How sever is this bug?

MID (default)

Version

v2.0.0-beta4

Checklist

  • I was able to reproduce the bug with the newest version of the bot
  • I confirmed that there is no other issue reporting the same bug
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
beta bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Properly remove user associations when deleting rooms CubicrootXYZ/RemindMe
1 participant
@CubicrootXYZ