Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Cannot delete userCannot delete user
Previous
 
Next
New Post
5/23/2007 5:00 AM
 

Hi, in a DNN 4.4.0 installation, I can not delete older users (prior to updating DNN)
I can make new users, and delete them, etc. but deleting old users is not possible.
One thing I notoced is that the old users do not have a creation date.

Is there some way I can delete the user anyway.

Perhaps manually entering a creation date or something.
Where should I do this?

 
New Post
5/23/2007 10:16 AM
 

Actually, I can delete most users from before the update, there are only some users (perhaps very, very old users) which cannot be deleted. So I think I can only not delet users which where added a couple of updates ago.

Does that sound strange?

I also found this script elsewhere on the forum.
Does anyone know if this has any sideeffects:

DECLARE @VUserID VARCHAR(512)

SELECT @VUserID = UserId FROM ASPNET_USERS WHERE UserName = 'promero'
DELETE FROM ASPNET_USERSINROLES WHERE UserId = @VUserID
DELETE FROM ASPNET_MEMBERSHIP WHERE UserId = @VUserID
DELETE FROM ASPNET_PROFILE WHERE UserId = @VUserID

DECLARE @IUserID INT

SELECT @IUserID = UserID FROM DNN4_USERS WHERE UserName = 'promero'
DELETE FROM DNN4_USERPORTALS WHERE UserId = @IUserID
DELETE FROM DNN4_USERROLES WHERE UserId = @IUserID
DELETE FROM DNN4_USERSONLINE WHERE UserId = @IUserID
DELETE FROM DNN4_PROFILE WHERE UserId = @IUserID

 

 

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Cannot delete userCannot delete user


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out