From 7c0a44b743db440fee8a63a71f1742fd8c92df03 Mon Sep 17 00:00:00 2001 From: "lpsolit%gmail.com" <> Date: Mon, 14 Nov 2005 02:16:24 +0000 Subject: Bug 314547: [PostgreSQL] cannot check/uncheck the "Private" checkbox for comments in show_bug.cgi - Patch by Frédéric Buclin r=mkanat a=justdave MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- Bugzilla/Bug.pm | 10 ++-------- 1 file changed, 2 insertions(+), 8 deletions(-) (limited to 'Bugzilla/Bug.pm') diff --git a/Bugzilla/Bug.pm b/Bugzilla/Bug.pm index d094b8eae..6a6c87d37 100755 --- a/Bugzilla/Bug.pm +++ b/Bugzilla/Bug.pm @@ -786,11 +786,9 @@ sub GetComments { my @comments; my $sth = $dbh->prepare( "SELECT profiles.realname AS name, profiles.login_name AS email, - " . $dbh->sql_date_format('longdescs.bug_when', '%Y.%m.%d %H:%i') . " + " . $dbh->sql_date_format('longdescs.bug_when', '%Y.%m.%d %H:%i:%s') . " AS time, longdescs.thetext AS body, longdescs.work_time, - isprivate, already_wrapped, - " . $dbh->sql_date_format('longdescs.bug_when', '%Y%m%d%H%i%s') . " - AS bug_when + isprivate, already_wrapped FROM longdescs, profiles WHERE profiles.userid = longdescs.who AND longdescs.bug_id = ? @@ -800,10 +798,6 @@ sub GetComments { while (my $comment_ref = $sth->fetchrow_hashref()) { my %comment = %$comment_ref; - # Can't use "when" as a field name in MySQL - $comment{'when'} = $comment{'bug_when'}; - delete($comment{'bug_when'}); - $comment{'email'} .= Param('emailsuffix'); $comment{'name'} = $comment{'name'} || $comment{'email'}; -- cgit v1.2.3-24-g4f1b