Incorrect time in mysql db?

Hi All

My apologies if this has been discussed before. I google’d and searched the
mailing list archives and couldn’t find an answer to my problem.

I’m running RT 3.0.0. I have the Timezone setting set in RT_Config.pm to
Australia/Sydney, and all the times in the RT webUI are correct. However,
for some strange reason the times in the actual MySQL DB are totally wrong.
For example, I replied to a ticket and the RT webUI shows 13:47:09 which is
correct, but in the ‘Transactions’ table of the RT database shows
’03:47:09’. It seems to me like something in the process is set to GMT
(should be GMT+10). Any ideas?

TIA!

Regards,
Gonzalo.

All times inside RT are stored as GMT.On Tue, May 27, 2003 at 02:04:46PM +1000, Gonzalo Servat wrote:

Hi All

My apologies if this has been discussed before. I google’d and searched the
mailing list archives and couldn’t find an answer to my problem.

I’m running RT 3.0.0. I have the Timezone setting set in RT_Config.pm to
Australia/Sydney, and all the times in the RT webUI are correct. However,
for some strange reason the times in the actual MySQL DB are totally wrong.
For example, I replied to a ticket and the RT webUI shows 13:47:09 which is
correct, but in the ‘Transactions’ table of the RT database shows
’03:47:09’. It seems to me like something in the process is set to GMT
(should be GMT+10). Any ideas?

TIA!

Regards,
Gonzalo.


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

http://www.bestpractical.com/rt – Trouble Ticketing. Free.

All times inside RT are stored as GMT.

Ahh, right! That makes sense.

The reason why I started to look into this is because I’ll reply to a
ticket, then the requestor replies, then I respond again and the requestor
responds again. Now, sometimes the date is wrong on their ticket and MY
previous response is the most up-to-date as far as RT is concerned, when in
fact the requestor was the last one to respond. If you look at the history,
you can see THEIR email which was a response to my last reply and is infact
above my reply, not below.
RT wouldn’t set the time from the users email, would it? it would use it’s
own local time I would think which doesn’t make sense as to why it would
set an older time on the newest ticket.

Regards,
Gonzalo.