Clean up dirty roles · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

MJCS
64.4% (Friendly)
YAF Lover Topic Starter

12 years ago

I noticed a bunch of RoleID's/GUIDS in the yaf_prov_rolemembership table that were not in the yaf_prov_role table. So I ran the following and found to my supprise 376 entries that had no real role

SELECT     dbo.yaf_prov_Membership.UserID, dbo.yaf_prov_Membership.Username, dbo.yaf_prov_Membership.IsApproved, dbo.yaf_prov_RoleMembership.RoleID, dbo.yaf_prov_Role.RoleName
FROM       dbo.yaf_prov_Membership LEFT JOIN
           dbo.yaf_prov_RoleMembership ON dbo.yaf_prov_Membership.UserID = dbo.yaf_prov_RoleMembership.UserID Left JOIN
           dbo.yaf_prov_Role ON dbo.yaf_prov_RoleMembership.RoleID = dbo.yaf_prov_Role.RoleID
WHERE RoleName IS Null

I just finished deleting a old board that was linked so I am guessing these are from that. Is there an easy way to purge this data?

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

Important Information: