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

[BUG] Cannot delete team #577

Closed
scaik opened this issue Apr 4, 2024 · 3 comments
Closed

[BUG] Cannot delete team #577

scaik opened this issue Apr 4, 2024 · 3 comments
Assignees
Labels
bug Something isn't working inactive The issue has had no activity for 20 days, it will be closed in 10 days time question Further information is requested

Comments

@scaik
Copy link

scaik commented Apr 4, 2024

What is the bug?

When you try to disband a team, it will first remove player record from db, and then try to delete team row, and get an error

Expected Behaviour

To delete team row

How to Reproduce

Create a team and disband it

Error message

Something went wrong while executing SQL
[10:58:49 ERROR]: SQL: DELETE FROM BetterTeams_Team WHERE teamID LIKE '08b0afc1-ead2-4580-bed4-eab7d2453e7f';
[10:58:49 WARN]: java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (minecraft.betterteams_players, CONSTRAINT betterteams_players_ibfk_1 FOREIGN KEY (teamID) REFERENCES BetterTeams_Team (teamID) ON DELETE CASCADE)

Output of /teama version

Метод хранения данных: com.booksaw.betterTeams.team.storage.storageManager.SQLStorageManager
Версия Minecraft: git-Purpur-2157 (MC: 1.20.4)
Выбранный язык: ru
Online mode: false
Player count: 1
Текущая версия плагина: 4.9.1

Additional Information

No response

@scaik scaik added the bug Something isn't working label Apr 4, 2024
@booksaw
Copy link
Owner

booksaw commented Apr 20, 2024

What version of SQL is your server running, when I try and reproduce it on my test machine it works as expected
image

@booksaw booksaw added the question Further information is requested label Apr 20, 2024
Copy link

stale bot commented Jun 1, 2024

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

@stale stale bot added the inactive The issue has had no activity for 20 days, it will be closed in 10 days time label Jun 1, 2024
@booksaw
Copy link
Owner

booksaw commented Jun 30, 2024

This issue is being closed for inactivity. If you are still having problems feel free to open a new issue linking this one, make sure you answer any questions asked in the new issue.

@booksaw booksaw closed this as not planned Won't fix, can't repro, duplicate, stale Jun 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working inactive The issue has had no activity for 20 days, it will be closed in 10 days time question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants