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 ...Errors with User roles after upgrading from 4.6 to 4.7Errors with User roles after upgrading from 4.6 to 4.7
Previous
 
Next
New Post
1/24/2008 8:12 PM
 

As a follow on (sheesh, I'm way to invested in this...),

If anyone has the same use case described in #2 above, feel free to ask for a fix. I just successfully ran some queries against thousands of users to upgrade the userprofile table and fix the error for good. Moving forward, it also involves an adjustment to the Dynamic Registration form to account for inserting the Preferred Locale into the DNN profile record.


Eric Swanzey
www.swanzey.com
 
New Post
1/26/2008 7:27 PM
 

Just wanted to close this out by saying all in all, I think v4.8.0 is pretty tight and stable. It's hard to argue with tighter integration of preferred locale information, probably as a leadup to getting some probably awesome native multilingual capability. And also hard to fault DNN core for not playing well with some other modules I had on the site.

When I look at the core and core upgrades, I am very appreciative and usually in awe at what has/is/and will be accomplished.


Eric Swanzey
www.swanzey.com
 
New Post
1/27/2008 8:36 PM
 

I would appreciate the "fix".

thanks for your efforts on this issue!

 
New Post
1/27/2008 11:00 PM
 

Penny Rand,
Before answering, I looked at your posts and it looks like you have db access and are tsql aware.

It's easy if you are only dealing with one locale, in the following case, I'll reference "en-US". If more than 1 locale, I'd be more than happy to help you further if you need it. Am also asuming that you are referencing a portal that used DataSprings Dynamic Registration? Although to be fair, it 's not at all a fault of DataSprings - they write great stuff.

  1. the problem exhibits itself in this case when the userprofile table is missing preffered locale information for user(s) in the particular portal - the missing locale info will cause the error
  2. if you're only using a single locale, it's easy - look in the ProfilePropertyDefinition table for the PortalID in question and the PropertyName caled PreferredLocale to find the PropertyDefinitionID.
  3. look in the userprofile table for a profile in the same portal in question that has a userprofile defined and make note of the settings, especially the propertydefinitionid
  4. first, clear the old data - delete from userprofile where propertydefinitionid = x
  5. next, insert the new data to get everything back on track. in my case, I used
    "insert into userprofile
    (propertydefinitionid, userid, propertyvalue, visibility, lastupdateddate)
    select [your propertydefinitionid here ], userid, 'en-US', '2', getdate() from Users

Any questions, please ask.


Eric Swanzey
www.swanzey.com
 
New Post
1/29/2008 12:48 AM
 

I'm stuck on #3. When I look in the userprofile table, I see many profile ids that have the propertydefinitionid  but none are identified as pertaining to a specific portal id

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Errors with User roles after upgrading from 4.6 to 4.7Errors with User roles after upgrading from 4.6 to 4.7


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