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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...04.08.02 Upgrade Issue: Missing E-Mail Addresse in User Profile04.08.02 Upgrade Issue: Missing E-Mail Addresse in User Profile
Previous
 
Next
New Post
5/21/2008 9:34 AM
 

Recently I upgraded my portal from version 03.01.11 (I think, maybe it was .12) to version 04.08.02.  Everything seemed fine, and my customer really liked all of the improvements.  Today they called and told me that they no longer are seeing the e-mail address for many of the users who have signed up for the site.  Now they are seeing "Please update", instead of the e-mail address.

The e-mail addresses are still located in the dbo.aspnet_Membership table, and I can still query all 3,417 of them using SQL.  However, many of the user accounts, although not all, that I can see in the database that have valid e-mail addresses are displaying "Please Update" in the "Admin", "User Accounts" pages in Dot Net Nuke.

Please help!!!  We can no longer contact many of our customers.

How can I synchronize what is diplayed by the "Admin", "User Accounts" pages in DNN with what is located in the dbo.aspnet_Membership database table?

Thanks!

 
New Post
6/4/2008 7:19 AM
 

I guess nobody else has seen this, which is kind of suprising. Somehow, perhaps not as part of the upgrade process, the data contained in dbo.aspnet_Membership.Email field got out of sync with the value for the same user contained in dbo.dnn_Users.  When I use the DNN UI to add or update a user's e-mail, it is done correctly in both database tables.  So I am going to write some SQL queries to fix it.

 
New Post
6/4/2008 9:06 AM
 

Did you upgrade in one step, or in multiple steps?




Joe Craig
Patapsco Research Group, Ellicott City, MD
DotNetNuke Development and Services (http://patapscorg.com)
 
New Post
6/4/2008 9:39 AM
 

 

I used multiple steps as described by Will Strohl in the link below.

http://blog.strohlsitedesign.com/DnnUpgradePath.aspx

Will did a great job documenting frequent advice from Sebastian Leupold on the correct upgrade path should be from previous versions. Thanks Will!

In hindsight, I am thinking that the problem may have been present for some time, and nobody noticed until we audited the site after the upgrade.

The problem was that our dbo.DNN_Users table did not have the e-mail addresses in it but the dbo.aspnet_Membership table did.  If anyone else has this issue, here is the query I ran to fix it.

UPDATE

dbo.dnn_Users
SET dbo.dnn_Users.Email = dbo.vw_aspnet_MembershipUsers.Email
FROM dbo.dnn_Users
    INNER JOIN dbo.vw_aspnet_MembershipUsers
        ON dbo.dnn_Users.Username = dbo.vw_aspnet_MembershipUsers.UserName
WHERE dbo.dnn_Users.Email <> dbo.vw_aspnet_MembershipUsers.Email AND dbo.dnn_Users.Email = 'Please Update'

Our entries in the DNN UI Admin screen said "Please Update" for the user accounts missing the email address in the UI.

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...04.08.02 Upgrade Issue: Missing E-Mail Addresse in User Profile04.08.02 Upgrade Issue: Missing E-Mail Addresse in User Profile


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