# Can't delete badge if a user has it as their title badge
**URL:** https://meta.discourse.org/t/cant-delete-badge-if-a-user-has-it-as-their-title-badge/153121
**Category:** Bug
**Created:** [28 במאי, 2020, 4:59pm UTC](https://meta.discourse.org/t/cant-delete-badge-if-a-user-has-it-as-their-title-badge/153121 "2020-05-28T16:59:08Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [28 במאי, 2020, 4:59pm UTC](https://meta.discourse.org/t/cant-delete-badge-if-a-user-has-it-as-their-title-badge/153121/1 "2020-05-28T16:59:09Z")
I guess this is another corrupt table issue? Though this is on an instance where it is unlikely that the database was shut down uncleanly.
I created and deleted a badge with no members and that worked fine. I added a user to a new badge and deleted it and that worked fine.
```plaintext
Started DELETE "/admin/badges/118" for 71.89.242.121 at 2020-05-28 16:50:04 +0000
Processing by Admin::BadgesController#destroy as */*
Parameters: {"id"=>"118"}
Rendering text template
Rendered text template (Duration: 0.0ms | Allocations: 1)
Completed 500 Internal Server Error in 304ms (ActiveRecord: 0.0ms | Allocations: 114838)
ActiveRecord::InvalidForeignKey (PG::ForeignKeyViolation: ERROR: update or delete on table "badges" violates foreign key constraint "fk_rails_38ea484ed4" on table "user_profiles"
DETAIL: Key (id)=(118) is still referenced from table "user_profiles".
)
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-2.0.1/lib/patches/db/pg.rb:72:in `exec_params'
Failed to handle exception in exception app middleware : PG::ForeignKeyViolation: ERROR: update or delete on table "badges" violates foreign key constraint "fk_rails_38ea484ed4" on table "user_profiles"
DETAIL: Key (id)=(118) is still referenced from table "user_profiles".
```
But I don’t quite know where to look or what index to try to rebuild.
---
### Author:  [@RGJ](https://meta.discourse.org/u/RGJ)
#### Post date: [28 במאי, 2020, 5:32pm UTC](https://meta.discourse.org/t/cant-delete-badge-if-a-user-has-it-as-their-title-badge/153121/2 "2020-05-28T17:32:20Z")
`TABLE "user_profiles" CONSTRAINT "fk_rails_38ea484ed4" FOREIGN KEY (granted_title_badge_id) REFERENCES badges(id)`
What does `SELECT * FROM user_profiles where granted_title_badge_id = 118;` tell you?
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [28 במאי, 2020, 5:47pm UTC](https://meta.discourse.org/t/cant-delete-badge-if-a-user-has-it-as-their-title-badge/153121/3 "2020-05-28T17:47:14Z")
That gives me two users.
Then I
```
delete FROM user_profiles where granted_title_badge_id = 118;
```
and then I could delete the badge.
My problem appears to be solved, at least for this badge.
But shouldn’t deleting the badge do this? Now it seems more like a 🐛
---
### Author:  [@RGJ](https://meta.discourse.org/u/RGJ)
#### Post date: [28 במאי, 2020, 6:04pm UTC](https://meta.discourse.org/t/cant-delete-badge-if-a-user-has-it-as-their-title-badge/153121/4 "2020-05-28T18:04:45Z")
> [@pfaffman](#):
>
> `delete FROM user_profiles `
😱 you’ve just deleted the profiles of two users 😱
Next time
`UPDATE user_profiles SET granted_title_badge_id = (another id) WHERE granted_title_badge_id = 118`
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [28 במאי, 2020, 6:47pm UTC](https://meta.discourse.org/t/cant-delete-badge-if-a-user-has-it-as-their-title-badge/153121/5 "2020-05-28T18:47:25Z")
Oh. My. That does seem like a problem. This is why I tell people not to make db changes in sql.
At least it was only 2 users. Maybe I can still scroll to see who they were.
But it still seems like a bug that you can’t delete a badge if someone has it.
Recategorizing as a bug.
---
### Author:  [@RGJ](https://meta.discourse.org/u/RGJ)
#### Post date: [28 במאי, 2020, 9:32pm UTC](https://meta.discourse.org/t/cant-delete-badge-if-a-user-has-it-as-their-title-badge/153121/6 "2020-05-28T21:32:21Z")
> [@pfaffman](#):
>
> But it still seems like a bug that you can’t delete a badge if someone has it.
No. It seems like a (minor) bug that you _can initiate the deletion_ of a badge if someone has it. It would be nicer if the user interface would prevent it. It is totally correct that the database prevents deletion and preserves referential integrity.
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [28 במאי, 2020, 9:58pm UTC](https://meta.discourse.org/t/cant-delete-badge-if-a-user-has-it-as-their-title-badge/153121/7 "2020-05-28T21:58:22Z")
Agreed that it’s better to not delete the badge than leave the system in a broken state, but right now it returns a 500 error with no explanation.
A minor UX bug, sure, but it keeps someone who doesn’t know as much as you do from being able to delete a badge. 🙂
Thanks very much for your help. I’m waiting to see what happens to those users whose profiles I deleted!
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [27 ביוני, 2020, 10:01pm UTC](https://meta.discourse.org/t/cant-delete-badge-if-a-user-has-it-as-their-title-badge/153121/8 "2020-06-27T22:01:18Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.