summaryrefslogtreecommitdiffstats
path: root/Bugzilla
diff options
context:
space:
mode:
authorlpsolit%gmail.com <>2005-11-14 03:16:24 +0100
committerlpsolit%gmail.com <>2005-11-14 03:16:24 +0100
commit7c0a44b743db440fee8a63a71f1742fd8c92df03 (patch)
tree6ec2cbf98b83e4cbc89339aa9f1a726567b9c138 /Bugzilla
parent03352ccf9bdb6b816e0650f8f76e008a17df87c0 (diff)
downloadbugzilla-7c0a44b743db440fee8a63a71f1742fd8c92df03.tar.gz
bugzilla-7c0a44b743db440fee8a63a71f1742fd8c92df03.tar.xz
Bug 314547: [PostgreSQL] cannot check/uncheck the "Private" checkbox for comments in show_bug.cgi - Patch by Frédéric Buclin <LpSolit@gmail.com> r=mkanat a=justdave
Diffstat (limited to 'Bugzilla')
-rwxr-xr-xBugzilla/Bug.pm10
1 files changed, 2 insertions, 8 deletions
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'};