DNN 3.3.5

I'm trying to delete users. On the User Accounts page when I click on the red X for the user I want to delete I get an message "Error Deleting User" and the user remains. There is no entry made in the log file and no more detail provided.

If I have a list of unauthorized users and I try to delete those using the "Delete Unauthorized Users" menu selection I do not get any message and the users I wanted to delete are not deleted.

Anyone have any suggestions or ideas?

Thanks

John

I have the same problem, but i have a  solution maybe this could help you.  You can alter the existing stored procedure[DeleteUser].

 

ALTER procedure [dbo].[DeleteUser]
 
@UserId   int
 
as
declare @username as nvarchar(50)
declare @unique_userid as uniqueidentifier

delete from dbo.userroles where userid=@UserId
delete from dbo.ModulePermission  where userid=@UserId
delete from dbo.TabPermission where userid=@UserId


--remove orphan user
select @username=username from Users  where UserId = @UserId
select @unique_userid=userid from  dbo.aspnet_Users where userName=@username
delete from  dbo.aspnet_Membership  where userid=@unique_userid
delete from  dbo.aspnet_Users  where userid=@unique_userid


delete  from dbo.Users  where  UserId = @UserId 

you might be using non-default database owner or object qualifier. Please execute the following script inside Host > SQL with "run as script" checked:

ALTER PROCEDURE {databaseOwner}[{objectQualifier}DeleteUser] 
 @UserId   int
AS
BEGIN
 DECLARE @username as nvarchar(50)
 DECLARE @aspnet_userid as uniqueidentifier

 DELETE FROM {databaseOwner}[{objectQualifier}userroles]     WHERE UserID = @UserId
 DELETE FROM {databaseOwner}[{objectQualifier}ModulePermission]    WHERE UserID = @UserId
 DELETE FROM {databaseOwner}[{objectQualifier}TabPermission]    WHERE UserID = @UserId
 DELETE FROM {databaseOwner}[{objectQualifier}DesktopModulePermission]  WHERE UserID = @UserId

 --remove orphan user
 SELECT @username      = UserName FROM {databaseOwner}[{objectQualifier}Users] WHERE UserID = @UserId
 SELECT @aspnet_userid = userid   FROM  {databaseOwner}aspnet_Users      WHERE userName = @username
 DELETE FROM {databaseOwner}aspnet_Membership   WHERE userid = @aspnet_userid
 DELETE FROM {databaseOwner}aspnet_Users        WHERE userid = @aspnet_userid
 DELETE FROM {databaseOwner}[{objectQualifier}Users] WHERE UserId = @UserId 
END

GO

IF this doesn't help, there might be 3rd party modules, which placed a foreign key on users table and contain records with userid  (e.g. for owner or lastEditedBy)