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

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...DotNetNuke 5.1 User Accounts Not Actually Deleted?DotNetNuke 5.1 User Accounts Not Actually Deleted?
Previous
 
Next
New Post
7/29/2009 4:16 PM
 

Hi guys... We have run into a few issues with clients running DotNetNuke 5.1 where a user is deleted under Admin, User Accounts, but within queries and so forth that user doesn't exist (in some areas but not others). As anyone seen this? Here is an example...

Test against a DNN 4.8 installation and here is what happens.

1. User is deleted under Admin, User Accounts (lets assume the UserID is 500)

2. After deleting the user if you were to try the edit icon again you get a message 'This account doesn't exist'. The edit link would be similar to this.

http://www.yoursite.com/Admin/UserAccounts/tabid/42/ctl/Edit/mid/357/UserId/500/filter/data/filterproperty/Username/currentpage/1/language/en-US/Default.aspx

Now... Testing against a DNN 5.1 clean install.

1. User is deleted under Admin, User Accounts

2. After deleting the user, the user no longer appears in the list, however the user isn't completely deleted. If you were to click on the edit icon, you would be able to pull up the deleted user.

http://www.yoursite.com/Admin/UserAccounts/tabid/42/ctl/Edit/mid/357/UserId/500/filter/data/filterproperty/Username/currentpage/1/language/en-US/Default.aspx

This affects several modules that pull in users, but the fact that the URL still works and shows all previous user info of a deleted user doesn't matter. If you from there try and update the user or delete the user it won't work but the point is what changed and I don't think those edit links should work anymore for a deleted user.

So, I think its a bug within DNN that the user edit icon's still exist. I am guessing there is a new column for users (called IsDeleted) but even if that is the case the edit links shouldn't work anymore within DNN for that deleted user.

-Chad

 

 
New Post
7/29/2009 4:33 PM
 

5.1.1 or 5.1.0? thanks,.



Alex Shirley


 
New Post
7/29/2009 4:35 PM
 

Also please note 5.1.0+ support the soft deleted users concept, so they don't go away.



Alex Shirley


 
New Post
7/30/2009 12:14 PM
 

I've noted this as a problem as well.  I have a lot of custom modules that rely on the User table for referential integrity and expect that if a user is deleted, that all related DB records will be deleted as well. 

This is also a problem in user registration.   You can delete the user using the UI, but the username is still unavailble to a new user because the record still exists in the database. 

If there is going to be soft delete functionality, then there also needs to be some way to clear them (Recycle Bin?) or an additional hard delete option in the UI.

Another interesting fact, is that deleting the User trhough the UI does not actually set the IsDelete flag on the User table, but rather the UserPortals table.  In factm I am not sure how the IsDeleted flag on User ever gets set.

So...how do we now actually hard delete users without going directly into the DB?

 
New Post
7/30/2009 12:50 PM
 

you should never do direct database access of dotnetnuke core tables in your modules, it's simply too dangerous. If we alter schema, or functionality of these, your modules may not work correctly. You should instead use the DotNetNuke API as it will always be in sync with any changes.

Cathal


Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...DotNetNuke 5.1 User Accounts Not Actually Deleted?DotNetNuke 5.1 User Accounts Not Actually Deleted?


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