vanillaforums/Garden — Issue #1287: Role deletion - replacement role fails if any members have that role
Author: lincolnwebs
Created: 2012-01-03 21:08:12+00:00
State: open
Labels: Bug

Deleting a role requires you to choose a replacement role.

If any members are in both the role to be deleted and the replacement role, it fails with a duplicate key SQL error.

update GDN_UserRole UserRole
join GDN_UserRole urs on UserRole.UserID = urs.UserID set
UserRole.RoleID = :UserRoleRoleID
where UserRole.RoleID = :UserRoleRoleID0