Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...

Or... now make it easy with Facebook Integration
Connect via Facebook

Top Sellers

Dynamic Registration 4.0

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery 4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

XMod Pro 2.7 - Forms and Views for Databases

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

Smith Shopping Cart v3.88

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

Event Calendar and Registration 4.0

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

DNN Modules

Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration
Deleting User
Last Post 10-01-2009 09:22 AM by Tim. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
TimUser is Offline
Posts:4
Avatar

--
09-29-2009 02:34 PM

    When I delete a user using the Manage Users tab, the UserID (or Username) does not get deleted and stays in database.  It prevents me from using the deleted username again for registration.  is there a way to fix this so I can register under a username which has been unregistered before? Thanks.
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    09-30-2009 06:32 AM
    Hi, what version of DNN are you running? It seems that in DNN 5.0 and higher, a deleted user is never really deleted in the database but rather has a field column "IsDeleted" set to 1. If you go to Host / SQL and type in:

    select * from userportals

    you will see an "IsDeleted" column for that userid. If you type in:

    select * from users

    you will see that that user is still in the database. -- David
    TimUser is Offline
    Posts:4
    Avatar

    --
    09-30-2009 06:40 AM
    I am running DNN 5.1.2. So how do I remove them from the database? Is there a SQL script I can execute to remove them completely so it looks like they never registered in the first place? Thanks for the quick reply.
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    09-30-2009 07:05 AM
    You could probably come up with an SQL script to permanently remove the user, but I'm not 100% sure what the consequences are. Here are the SQL tables to consider since they are connected through foreign key constraints:
    1) users (UserID,UserName,etc)
    2) userportals (UserID,PortalID,IsDeleted,etc)
    3) userprofile (UserID,PropertyDefinitionID,etc)
    4) userroles (UserID,RoleID,etc)
    5) aspnet_users (UserID specifically for ASPNET, UserName,etc)
    6) aspnet_Membership (UserID specifically for ASPNET,etc)

    So you will need to create a stored procedure that will delete the UserID / UserName from these tables. I hope I'm not missing any other tables. -- David
    TimUser is Offline
    Posts:4
    Avatar

    --
    10-01-2009 05:09 AM
    I have another site using DNN 5.1.2 which uses the built in DNN registration, no Dynamic Registration module installed. On that site, I can delete a user and it will let me use the deleted username again for another registration. Looks like this issue occurs when I use the Dynamic Registration module. SQL Manager won't let me delete the above table entries you mentioned due to the constraints attached to them. What would be the best way to go about this so I can register some of the deleted users again under their original usernames? Thanks.
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    10-01-2009 08:39 AM
    Tim,

    Hi. Yes this seems to be something that came about just recently with 5.1 and maybe even specifically 5.1.2. Its called a 'soft delete' and something Dynamic Registration and Dynamic User Directory have not currently caught up to (but will in the very near future).

    I will have to test this though, my understanding was that even in DNN registration if you deleted the user and then tried to register as that user again it wouldn't let you.

    This is all on the same portal (portal ID?).


    -Chad
    TimUser is Offline
    Posts:4
    Avatar

    --
    10-01-2009 09:22 AM
    Yes, same portal. I registered a user, later on deleted it, and then registered under the same username again on the same portal.

    I should also point out that I am able to register a previously deleted username on the DNN site on which I am using Dynamic Registration module IF I bypass the DR module and use DNN's registration provider as admin.

    However, my visitors can't do that since the only way to access the DNN registration is thru admin and I need my visitors to go thru the DR module for registration. Do you have an ETA for the fix? Thanks for all your help.
    You are not authorized to post a reply.

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration
     
     

    Join our mailing list...

    Get current news and events the easy way
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi