The problem started in the repository module.  The display name was blank.  After looking into it I discovered that the repository module uses the first and last name stored in the UserProfile table.  It looks like the AD authentication new user functionality doesn’t setup any profile information.  Do you think this could be a problem with my AD configuration?  When a new user account is created is the AD authentication supposed to create user profile entries?

I have same problem on our DNN4.3.4 site, we need to assign some window auto-login user to different roles, but user account page crash when we try to manage the window auto-login users, I believe it is because null user profile data in database,

anyone could provide a stored procedure to add user profile data? This way, we could user profile page after Window auto-login user created,

thanks

Hi Everyone, i'm a little suprised that this one hasn't been fixed by the 4.3.4 upgrade but I guess they can only squeeze so much stuff into it.

The problem you are experiencing is due an omission in the Stored Proceedure called dbo.AddUser. To apply this fix you need to access and modify this procedure. To do it you will need SQL Server Management Studio Express edition or similar. Download it here http://msdn.microsoft.com/vstudio/express/sql/

In SQL Server Management Express: Open your intanet database. My db is called Intranet, yours could be DNN or DotNetNuke. Click "Programmability", Click "Stored Procedures", find dbo.AddUser right click and select "Modify".

If you are not 100% confident in working with SQL please copy all of the code in this procedure to a .txt file and save it just in case.

Copy this piece of code:

IF ( @DisplayName is null OR @DisplayName = '' )
BEGIN
   SET @DisplayName = @FirstName + ' ' + @LastName
END

And paste it just above the IF @UserID is null code. For this code to work it must be placed before update has taken place.

Refer to this screenshot if you need to: http://www.essentialwebdesign.com.au/dnn/adduser.gif

Once you have pasted this code into your stored Procedure click the "!Execute" button to apply the changes.

Your new users should now automatically generate a DisplayName based on their FirstName + LastName. Make sure your AD has both a first and last name, sounds stupid  but I have seen one user on our domain that only had a first name (due to a slack IT administrator) and that generated errors.

You will need to manually add DisplayNames to those users that tried to log on prior to this fix. To manually modify previous users DisplayNames expand "Tables", open the "dbo.Users" table and change the fields.

Tip: If you ever are having errors trying to view your users in your DNN site. At the bottom of the users page, click "User Settings" and change the "Users Per Page" field to 1. Then you can skip through the users one at a time until you find the user account thats causing the error.

Hope this helps everyone, let me know if you need more help.

Regards,
Darren Stahlhut
Web Developer (ASP.Net & SQL)