JaScoMa
  • Posts: 15
  • Joined: 06/10/2017
Hello..
When visiting the forum's home page (not logged in), it's showing the current time as being an hour behind current and it's showing "(UTC)" after the time; which isn't true. We're EDT and haven't switched yet EST yet; November 5th.

I haven't been able to see anywhere in the forum settings to change this.

Thank you for your time and attention..

Server time and time zone is configured correctly. DNN Site Settings has the proper Time Zone configuration as well.
Sponsor
tha_watcha
  • Posts: 4081
  • Joined: 06/03/2010
Originally Posted by: JaScoMa

Hello..
When visiting the forum's home page (not logged in), it's showing the current time as being an hour behind current and it's showing "(UTC)" after the time; which isn't true. We're EDT and haven't switched yet EST yet; November 5th.

I haven't been able to see anywhere in the forum settings to change this.

Thank you for your time and attention..

Server time and time zone is configured correctly. DNN Site Settings has the proper Time Zone configuration as well.



This is a bit complicated, for that setting you need to set the Timzeone for the Guest User. So go to Admin > User and Roles > Edit the "Guest" user and set the Timezone setting in the user profile


UserPostedImage
JaScoMa
  • Posts: 15
  • Joined: 06/10/2017
Great! Thank you very much for your assistance.

I see in the DB tables that IsDST is determined by the settings with the Flags column. I'd like to quickly set the Flags so that everyone has "Automatically adjust clock for Daylight Saving Time?" enabled.

How are the flags determined? I wish to change this, but I also don't want to possibly give someone access to do something which they shouldn't.

Thank you for your time and attention..
tha_watcha
  • Posts: 4081
  • Joined: 06/03/2010
Go to Admin (YAF) > Database > Run SQL Query and run

UPDATE [{databaseOwner}].[{objectQualifier}User] SET [Flags] = ([Flags] | 32) WHERE   IsDST = 0

UserPostedImage
JaScoMa
  • Posts: 15
  • Joined: 06/10/2017
Great! Thank you very much that worked.

Suggestion, maybe see if something can be put into the DNN Event logs when YAF SQL scripts are run. After running this, checked the DNN event logs and Admin -> Maintenance -> Event log, and theres nothing listed in either. The later log, maybe I don't have something turned on to log this event, but maybe some kind of notification would be beneficial.

For example, some other YAF Admin (which doesn't have DNN event log access) runs a SQL script, a Portal Admin of the DNN site, which has access to can view the DNN event logs, can see what they did, etc.

Thanks again..
tha_watcha
  • Posts: 4081
  • Joined: 06/03/2010
Good idea, i save it in my to do list.

But just for your info by default the yaf admins don't have access by default to all the admin pages you can specify what each admin has access to or not.
UserPostedImage
Forum Jump  
  • You cannot post new topics in this forum.
  • You cannot reply to topics in this forum.
  • You cannot delete your posts in this forum.
  • You cannot edit your posts in this forum.
  • You cannot create polls in this forum.
  • You cannot vote in polls in this forum.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved