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 
)
– 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
The rt-users Archives
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 
)
– Jac