Hi again,

I've just completed setting up the forum module in DNN 4.4.1 (forum 3.20.08) and I've noticed something funny with the timezone.  The portal is set to NZ (UTC +12), the Forums are set to NZ and the users are set to NZ timezone, but the time recorded against threads is 17 hours behind NZ time zone?  Am I missing something here?  Is there some further timezone setting somewhere I need to configure for the forum to display in NZ timezone. 

You help is of course appreciated.

Hi Alex,

I have a dedicated server hosted in the US running on NZ (UTC +12) time, HOWEVER, I noticed in the thread you linked to the post about SQL timezone, which in my case I subscribe to a dedicated SQL server box running in US time, so I'm guessing that the forum module is acutally based on the SQL server timezone rather than the hosting server timezone!  How frustrating if this is the case (as it is not possible to change the SQL server box timezone due to US customers using it)

Quote:

"This becomes a really interesting problem when you have a dedicated server in the US that is set to your own timezone, while the SQL server is set to a US timezone. Dependent upon module author and stored procedure, it becomes a nightmare to manage.

I believe that DNN should have its own mandatory timezone management that all modules must use for consistency, and this should be a requirement for the DNN Reviewed logo.

This would be consistent with most of what Alex has written above, but would have the best chance to resolve the issue in full. "

I'm interested to hear if anyone has any thoughts/work arounds to this as this is going to cause our clients real headaches....

I know timezones have been a major headache for us in the past, and saw us work with a NZ hosting supplier in an attempt to get a box setup with local TZ, but due to exceedingly poor support we've gone back to our US hosting supplier, specifically setting up a dedicated hosting box so we can set our own 'local time' on the box to get it to work with DNN!  It would be a shame if this planning was ruined due to some modules using SQL server TZ and not hosting box TZ!!

Reuben.

I don't think there are any timezone issues in the 4.4 version about to be released (its in the release process, all work is finished on it).

My question about your point is why would someone have a web server in one timezone and the database server in another? As long as both are in the same timezone (again, not sure why they wouldn't be) the forums version 4.4 will handle the timezones properly.