From f5a7c7d2472f5a4940343785ab9619247f8895a5 Mon Sep 17 00:00:00 2001 From: Dylan William Hardison Date: Tue, 30 Sep 2014 18:01:38 -0400 Subject: Bug 1070317 - Bugzilla::Flag's attribute modification_date is affected by the user's timezone and differs from the database copy after a call to $flag->update() r=dkl, a=justdave --- Bugzilla/Flag.pm | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'Bugzilla') diff --git a/Bugzilla/Flag.pm b/Bugzilla/Flag.pm index 6e2096729..772a39325 100644 --- a/Bugzilla/Flag.pm +++ b/Bugzilla/Flag.pm @@ -454,14 +454,15 @@ sub create { sub update { my $self = shift; my $dbh = Bugzilla->dbh; - my $timestamp = shift || $dbh->selectrow_array('SELECT NOW()'); + my $timestamp = shift || $dbh->selectrow_array('SELECT LOCALTIMESTAMP(0)'); my $changes = $self->SUPER::update(@_); if (scalar(keys %$changes)) { $dbh->do('UPDATE flags SET modification_date = ? WHERE id = ?', undef, ($timestamp, $self->id)); - $self->{'modification_date'} = format_time($timestamp, '%Y.%m.%d %T'); + $self->{'modification_date'} = + format_time($timestamp, '%Y.%m.%d %T', Bugzilla->local_timezone); Bugzilla->memcached->clear({ table => 'flags', id => $self->id }); } return $changes; -- cgit v1.2.3-24-g4f1b