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

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 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.

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,

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.

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

Deleted users still showing in directory?
Last Post 08-29-2010 10:22 PM by Richard. 10 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ChrisUser is Offline
skipping stones
skipping stones
Posts:10
Avatar

--
08-10-2009 08:21 AM

    After deleting a user using the "User Accounts" admin screen, that user still shows in the user directory.

     

    I am using DNN 5.1.1 and DUD 2.50.22 (I installed what looks to be 2.5.30 (according to the *.dnn file), but the version number did not change).

     

    Any ideas?

     

    Thanks,

    Chris

    ChrisUser is Offline
    skipping stones
    skipping stones
    Posts:10
    Avatar

    --
    08-11-2009 06:35 AM

    Any ideas here?  I'm really stuck with this, as we have a LOT of test users in a system that needs to go live quickly.

     

    The users have been deleted from DNN, but still show up in the user directory.

     

    Thanks,

    Chris

    ChrisUser is Offline
    skipping stones
    skipping stones
    Posts:10
    Avatar

    --
    08-11-2009 10:43 AM

    After being pointed in the right direction (thanks Chad!), I believe I have a "fix" for the problem described above.  The [DataSprings_RetrieveDNNUserProfileData3] stored procedure needs to be modified slightly...here is the complete SQL for my new version:

     

    set ANSI_NULLS ON
    set QUOTED_IDENTIFIER ON
    go

    ALTER Procedure [dbo].[DataSprings_RetrieveDNNUserProfileData3]

    @PortalID int,
    @RoleFilter nvarchar(1000),
    @LimitResults nvarchar(1000),
    @Authonly int

    AS

    Declare curDS Cursor
    FOR
    SELECT PropertyName, PropertyDefinitionID
    FROM dbo.[ProfilePropertyDefinition]
    where Visible=1
    AND PortalID = @PortalID
    AND Deleted=0
    AND PRopertyName <> 'FirstName'
    AND PropertyName <> 'LastName'
    AND PRopertyNAme <> 'E-Mail'
    AND PRopertyNAme <> 'Email'
    AND PRopertyNAme <> 'Username'
    AND PropertyNAme Not Like '%.%'
    AND PropertyNAme Not Like '%-%'
    --AND PropertyNAme Not Like '%/%'
    AND PropertyNAme Not Like '%#%'

    ORDER BY PropertyCategory, Vieworder
    FOR READ ONLY;

    Declare @PropertyName VarChar(500);
    Declare @PropertyDefinitionID Integer;
    Declare @SQLToUse VarChar(8000);
    Declare @SQLToUseJoin VarChar(8000);
    Declare @SQLToExecute nVarChar(Max);
    Declare @Alias       VarChar(10);


    set @PropertyName = '';
    set @SQLToUse = '';
    set @SQLToUseJoin = '';


    OPEN curDS;
    FETCH NEXT FROM CurDS INTO @PropertyName, @PropertyDefinitionID;

    WHILE @@FETCH_STATUS = 0
    BEGIN
        if DataLength(@SQLToUse) = 0
        BEGIN
            set @SQLToUse = 'select ' + @LimitResults + ' U.UserID,U.Username,FirstName, LastName, U.Email, '
            set @SQLToUseJoin = 'dbo.DSGetProfileElementByID(U.userID,''' +  Convert(varchar(4), @PropertyDefinitionID) + ''') as [' + REPLACE(@PropertyName, '/', '') + ']'
        END
        ELSE
        BEGIN
           
           set @SQLToUseJoin = @SQLToUseJoin + ',dbo.DSGetProfileElementByID(U.userID,''' +  Convert(varchar(4), @PropertyDefinitionID) + ''') as [' + REPLACE(@PropertyName, '/', '') + ']'
        END;   

           FETCH NEXT FROM CurDS INTO @PropertyName, @PropertyDefinitionID;
    END

    CLOSE CurDS;
    DEALLOCATE CurDS;

     set @SQLToUseJoin =  @SQLToUseJoin + ' from dbo.[Users] U
        INNER JOIN dbo.[UserPortals] AS up ON up.UserId = U.UserId
      Inner Join dbo.[aspnet_users] as au on au.Username = U.UserName
      Inner Join dbo.[aspnet_membership] am on au.UserID = am.UserID
      WHERE up.IsDeleted = 0 AND (am.IsApproved =1 OR ' +  Convert(varchar(2), @AuthOnly) + ' = 0)
      AND U.UserID In (Select UserID from dbo.[UserPortals] where PortalID = ' +  Convert(varchar(2), @PortalID) + ')' 
     

    Set @SQLToExecute = 'Select * from (' + Convert(varchar(8000), @SQLToUse) + Convert(varchar(8000), @SQLToUseJoin) + ') AS A ' + Convert(varchar(8000), @RoleFilter)
    --print @SQLToExecute
    --EXEC(@SQLToExecute);
    --print @SQLToExecute;
    exec sp_executesql @SQLToExecute


    For those playing along at home, the change involves adding another INNER JOIN (to reference the UserPortals table) and the corresponding WHERE clause to the final SQL statement to be executed.

     

    Hopefully this fix is all it takes, and will help someone else!

     

    Thanks,

    Chris

    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    08-11-2009 10:46 AM
    HI Chris, I believe you talked to Chad about this issue. It seems that in 5.1.0 of DNN, if you delete a user, it still exists in the database but the "isdeleted" column in the userportals table is set to true for that particular user and under Admin / User Accounts, will filter that user out. However, DUD uses a stored procedure and doesn't filter this out. So you can try modifying the stored procedure to join to the userportals table where isdeleted = true to filter out the list in DUD. I believe Chad relayed you the name of the stored procedure. If you modified the code and it works, please post it in this forum. -- David
    ChrisUser is Offline
    skipping stones
    skipping stones
    Posts:10
    Avatar

    --
    08-11-2009 11:03 AM
    ...already done, see above ;-)
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    08-21-2009 10:52 AM
    Chris,

    Thanks so much for posting this. We will be adding this inner join for future releases, not yet sure exactly how we will do this because its only for the latest versions of DNN. We might check via code the DNN version and then use either the standard query or this updated one based on what version of DNN they are on.

    Thanks again,

    Chad
    RichardUser is Offline
    skipping stones
    skipping stones
    Posts:13
    Avatar

    --
    08-20-2010 04:32 AM
    Hi,

    I am having the same issue. I have updated the stored proc but this hasn't fixed it. Anything else I can try?

    Regards,

    Lyndon
    CandaceUser is Offline
    river guide
    river guide
    Posts:2431
    Avatar

    --
    08-20-2010 12:44 PM
    Hi Richard,

    After updating the stored procedure, please run the scheduler in Host, Schedule.  Let us know if it clears it up for you. Thanks!

    Candace
    RichardUser is Offline
    skipping stones
    skipping stones
    Posts:13
    Avatar

    --
    08-27-2010 03:28 AM
    Hi Candace,

    I am not sure what you need me to do here. Could you please give me more details.

    Regards,

    Richard
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    08-27-2010 05:40 AM
    Hi Richard - Please go to Host, Scheduler and find the 'UserImport' scheduler option. I would click 'Edit' and then 'Run Now' to kick off the scheduler. After kicking off the scheduler do the deleted users still appear?

    -Chad
    RichardUser is Offline
    skipping stones
    skipping stones
    Posts:13
    Avatar

    --
    08-29-2010 10:22 PM
    Hi,

    i have checked the Schedule but I cannot find UserIpmort. It is not showing up in the History either. Any idea why that could be??

    Regards,

    Richard
    You are not authorized to post a reply.


     
     

    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