Time ticket creation incorrect

Hi,

Today I noticed the ticket creation time is between 25 and 28 minutes
earlier than the time the ticket actually got created. After submitting a
ticket through email the ‘last updated’ time is correct but the creation
time is wrong. Now, given the fact that we are close to half an hour off, I
concluded it is not a time zone issue. It is also not the server time, as I
checked that that is correct. So my question: Would anybody have an idea on
what causes the creation time to end up wrong in the database!?

Looking forward to your replies!

Jac Gubbels
Istanbul, Turkey.
Jac

Hi,

Today I noticed the ticket creation time is between 25 and 28 minutes
earlier than the time the ticket actually got created. After submitting a
ticket through email the ‘last updated’ time is correct but the creation
time is wrong. Now, given the fact that we are close to half an hour off, I
concluded it is not a time zone issue. It is also not the server time, as I
checked that that is correct. So my question: Would anybody have an idea on
what causes the creation time to end up wrong in the database!?

That’s very wrong. Maybe your database got started at a time when
your clock was badly off? I’ve got no idea, though.

hmmm, but both the server time and ‘Select NOW()’ give the correct time …
Where else should I be looking? (a mysql forum probably :slight_smile: )
– JacOn Sun, Jan 3, 2010 at 11:44 PM, Jesse Vincent jesse@bestpractical.comwrote:

On Thu, Dec 31, 2009 at 05:07:44PM +0200, Jac Gubbels wrote:

Hi,

Today I noticed the ticket creation time is between 25 and 28 minutes
earlier than the time the ticket actually got created. After submitting a
ticket through email the ‘last updated’ time is correct but the creation
time is wrong. Now, given the fact that we are close to half an hour off,
I
concluded it is not a time zone issue. It is also not the server time, as
I
checked that that is correct. So my question: Would anybody have an idea
on
what causes the creation time to end up wrong in the database!?

That’s very wrong. Maybe your database got started at a time when
your clock was badly off? I’ve got no idea, though.

Looking forward to your replies!

Jac Gubbels
Istanbul, Turkey.
Jac


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Also found out that after the creation, the ‘last updated’ time of the
ticket in fact is correct. Only the creation time is off. Any idea?
– JacOn Mon, Jan 4, 2010 at 8:38 AM, Jac Gubbels jhj.gubbels@gmail.com wrote:

hmmm, but both the server time and ‘Select NOW()’ give the correct time …
Where else should I be looking? (a mysql forum probably :slight_smile: )
– Jac