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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Preferred Time Zone IssuePreferred Time Zone Issue
Previous
 
Next
New Post
5/3/2014 12:15 AM
 

Hello,

On my DNN 7.02.02 website, I have a custom registration form set up. Upon upgrading to DNN 7.02.02, I noticed that regardless of what new users set as their 'Preferred Time Zone' setting when registering, it would show up as '(UTC - 12:00) International Date Line West' when I looked at it in the 'Users' module.

At first, I thought it it was an issue with the DNN registration form, but today looked at the website's MSSQL database and it turns out that the user's 'Preferred Time Zone' profile setting does appear correctly in the dbo.UserProfile table, so the reigstration module is writing things correctly. However, I noticed that users who registered after the 7.02.02 upgrade have their time zone setting entered under the format of something like '(UTC-09:00) Alaska', while users tho registered before the upgrade have their time zone setting entered under the format of 'Alaskan Standard Time'.

So it appears that with the 7.02.02 upgrade, the registration module changed the format that it is writing to the database, but the 'Users' module was not updated to read both '(UTC-09:00) Alaska' and 'Alaskan Standard Time' format?

Any help would be appreciated.

Thanks,

Phil

 
New Post
5/3/2014 4:50 AM
 
Phil, I am not aware of a TZ format change, but will investigate.

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/3/2014 6:53 AM
 
Phil,
I just checked with a new DNN install, and PreferredTimeZone in UserProfile does just contain the TZ name without preceding UTC offset, therefore I fear the issue is caused by your registration form not storing the proper value. Compare with TZ being stored when editing a user profile in User Accounts module.

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/3/2014 10:01 PM
 

By custom registration form, I mean that I'm using DNN's registration form with the option for custom values added, one of which is the Preferred TimeZone value (which is a default option provided by DNN, not some option that I added on my own). So it is DNN's registration form and not some 3rd Party product.

In DNN's registration form, the code for the time zone drop down has options that are like this:

<option value="Alaskan Standard Time">(UTC-09:00) Alaska</option>

So per my original post, it looks like the registration form is writing the actual drop down text to the database, while the Users module is looking to read the 'value' tags associated with each drop down item rather than its text value.

 
New Post
5/3/2014 10:28 PM
 

I took a look at the time zone property on my registration module via the Site Settings > Profile Properties section, and the preferred time zone property was set to a type of 'TimeZoneInfo'. I changed the property type 'TimeZone', and now new user registrations do show the correct time zone.

However, when I changed this type property, all of the old users no longer have their preferred time zone recognized correctly by the Users module.

The TimeZone type property (the one that I updated to) has drop down options with code that looks like this:

<option value="-480">(UTC -08:00) Pacific Time (US & Canada); Tijuanaoption>


So in my database I now have values like '-480' stored in the tables. While the Users module is able to recognize this format when I changed the type, all of the users who registered when I had prior versions of DNN installed have values stored in the database with the format of something like 'Alaskan Standard Time', which is apparently no longer recognized by the Users module when I changed the timezone property.


So now it looks like the Users module is looking for a value that is aligned with the type value I have selected for the preferred time zone, but it's not backwards compatible to recognize both formats?

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Preferred Time Zone IssuePreferred Time Zone Issue


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.

Content Layout

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out