Database logging timestamp problem

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
1/8/2013 4:55:24 AM
john_scvo
Gravatar
Total Posts 133
View Posts
J

Database logging timestamp problem

Hi Joe

Not sure if this is a bug or a configuration setting I have wrong either in mojo or somewhere else.

The site runs in GMT. Using databse logging. In the database the mp_systemlog.logdate displays correctly in query results but in the system log display all logdates seem to be out by -12 hours exactly. e.g. 2013-01-08 10:26:07.257 from the database is rendering in  the admin log page as 2013-01-07 22:26:07.257

What caught my eye was a number of htmledit.aspx entries and their related Index Writer tasks happening at a time when no one was working but close examination shows this 12 hour negative offset is consistent.

Any ideas?

Cheers

John

1/8/2013 8:28:20 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Database logging timestamp problem

Hi John,

The LogDate is stored in the database as UTC aka GMT, but in the UI it is adjusted to the user's preferred time zone from the user profile. This is true of most dates rendered anywhere in the UI in mojoPortal, they are stored as UTC and displayed according to the user time zone or for unauthenticated users it uses the default time zone from site settings.

Hope that helps,

Joe

1/8/2013 8:41:12 AM
john_scvo
Gravatar
Total Posts 133
View Posts
J

Re: Database logging timestamp problem

Great - thanks Joe - my admin login was set to DateLineWest - I knew it had to be something simple I had missed.

JC

You must sign in to post in the forums. This thread is closed to new posts.