Jerry Jansen
Gold Membership
Nuke Addict
Posts:71
 |
| 1/04/2006 12:54 PM |
|
| Anybody know how or where I can update the time zone for all my users as they are all getting set to UTC 00:00 even though the portal default time zone is set to UTC -06:00. This is an intranet website and only internal users are allowed so they all should be set to UTC -06:00. Thanks. |
|
Jerry J. Jansen
|
|
|
Scott McCulloch
Administrators
Nuke Master
Posts:12442
|
| 1/05/2006 4:52 AM |
|
| it is stored in aspnet_profile, you could probably run a sql update to update all at once.. |
|
Scott McCulloch
Site Administrator |
|
|
Bill Cunnien
Registered Users
Nuke Wiz
Posts:134
|
| 1/05/2006 5:54 AM |
|
| It would be interesting to see the syntax of the query that would do this. The field, PropertyNames, is an ntext type with a length of 6000. I doubt there would be much joy in manipulating that string. |
|
Linguinut
|
|
|
Scott McCulloch
Administrators
Nuke Master
Posts:12442
|
| 1/05/2006 2:28 PM |
|
| I would do a search for that specific string sequence , e.g. -04.00 and try to replace just that |
|
Scott McCulloch
Site Administrator |
|
|
Jerry Jansen
Gold Membership
Nuke Addict
Posts:71
|
| 1/05/2006 2:58 PM |
|
I tried to replace the 0 with -06:00 but it then messed up the user's name so there must be something with the binary field that has to be changed also.
I am able now to see which one's are not set correctly and then I can edit them from the portal. That helps me a lot. Thanks Scott. |
|
Jerry J. Jansen
|
|
|
GlenWin
Gold Membership
Nuke Master
Posts:711
.Glen.1/XL-animation_thumb.gif)
|
| 10/17/2006 12:20 AM |
|
I dont know how to set the time zone on my site to show correct time for Melbourne . I have set the portal server time zone to Melbourne timezone (UTC+10) but my site still show
my host sever time zone - which is (utc -8). Anyone can get me out of this missery  ??
Thanks in Advance.
Glen
|
|
|
|
|
Scott McCulloch
Administrators
Nuke Master
Posts:12442
|
| 10/17/2006 5:55 AM |
|
Hi Glen,
Have your set your portal timezone correctly? And the timezone of your logged in user (via profile)? |
|
Scott McCulloch
Site Administrator |
|
|
GlenWin
Gold Membership
Nuke Master
Posts:711
|
| 10/17/2006 2:34 PM |
|
Hi Scott, I set the Portal TimeZone to: melbourne, canberra,etc (utc+10) in the Admin Site setting. But the site still display the Websecurestores Host server time zone (utc -8) Pacific Time USA (share hosting plan). I tried to change the TimeZone value in the Host setting for Melbourne or USA but it does not reflect any imediate timezone change in the site. What else can i do ?
|
|
|
|
|
Scott McCulloch
Administrators
Nuke Master
Posts:12442
|
| 10/17/2006 5:53 PM |
|
| Users also have a timezone associated with them, what timezone does the logged in user have, or are you getting the correct value when not logged in? |
|
Scott McCulloch
Site Administrator |
|
|
GlenWin
Gold Membership
Nuke Master
Posts:711
|
| 10/17/2006 7:11 PM |
|
Most users are already set to (utc +10) Melbourne time but Its does not make any diffrence - login or not the timezone display on the site stay the same (about 12hr behind local Melbourne time). Any other ideas where i can correct the timezone?
|
|
|
|
|
Scott McCulloch
Administrators
Nuke Master
Posts:12442
|
| 10/17/2006 10:28 PM |
|
It depends on the module, what module are you using to test this? News Articles has a server time zone setting which needs to be set too (although it will default to the portal timezone)
Some modules don't adjust the time. |
|
Scott McCulloch
Site Administrator |
|
|
GlenWin
Gold Membership
Nuke Master
Posts:711
|
| 10/26/2006 7:43 AM |
|
Posted By smcculloch on 10/17/2006 10:28 PM
It depends on the module, what module are you using to test this? News Articles has a server time zone setting which needs to be set too (although it will default to the portal timezone)
Some modules don't adjust the time. Thanks Scott your continuing support . The time and date work correctly with your Article Module . The issue is the timezone display in the Skin Object - It seem to alway adhering to the WSS server time zone (UTC-8) and so the core dnn modules - Events and Forum are also running on this skin object time zone which is about 6 hrs behind Melbourne time. Is the problem becuase i use WSS (share hosting) sever which run on UTC-8 time zone ? But i thought dnn should be robust enought to allow for timezoen adjustmeny regardless of where the server is !
|
|
|
|
|
Scott McCulloch
Administrators
Nuke Master
Posts:12442
|
| 10/26/2006 4:32 PM |
|
| It depends on the module -- some modules don't adjust for time (likely the events & forum). I think Active Forums does though. |
|
Scott McCulloch
Site Administrator |
|
|