This happened again today, only worse:
Here’s my query:
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.)