# Topic deletion should clear assignment

**URL:** https://meta.discourse.org/t/topic-deletion-should-clear-assignment/271996
**Category:** Bug
**Tags:** assign, fixed
**Created:** [July 18, 2023, 2:43pm UTC](https://meta.discourse.org/t/topic-deletion-should-clear-assignment/271996 "2023-07-18T14:43:33Z")
**Posts on this page:** 1
**Showing post:** 5

<div class="post-metadata">

### Author: ![ganncamp](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ganncamp/32/106199_2.png) [@ganncamp](https://meta.discourse.org/u/ganncamp)
#### Post date: [August 24, 2023, 12:08pm UTC](https://meta.discourse.org/t/topic-deletion-should-clear-assignment/271996/5 "2023-08-24T12:08:48Z")

</div>

This happened again today, only worse:

 ![Selection_1296](https://global.discourse-cdn.com/meta/original/4X/4/4/0/44018e0deb4da7b3b7990f88bd039fc940c3c42b.png)

 ![Selection_1297](https://global.discourse-cdn.com/meta/original/4X/9/1/e/91ecc4f87b9481d90fc1374d3f75796b1c73076e.png)

Here’s my query:

```plaintext
SELECT a.* 
FROM assignments a
JOIN groups g on g.id=a.assigned_to_id
WHERE a.assigned_to_type='Group'
AND g.name='xxx'

```

In one of ‘deleted by author’ posts, my attempts to unassign it don’t “take”. I unassign, the action _does not_ show up in the thread, and a page refresh shows it’s still assigned to the group.

Edit: I had to undelete the topic before I could unassign it and get it removed from the group’s total assignment count. (Then re-deleted it.)

---

_[View the full topic](https://meta.discourse.org/t/topic-deletion-should-clear-assignment/271996)._