From 4015bef325a73631bd244b4e0905f9f450145aae Mon Sep 17 00:00:00 2001 From: "justdave%syndicomm.com" <> Date: Tue, 2 Sep 2003 13:54:58 +0000 Subject: Bug 217422: "0" was missing in "votes: 0" (MySQL 4 compatibility) r= bbaetz, a= justdave --- Bug.pm | 2 +- Bugzilla/Bug.pm | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Bug.pm b/Bug.pm index 750fd8186..94bd628e2 100755 --- a/Bug.pm +++ b/Bug.pm @@ -140,7 +140,7 @@ sub initBug { reporter, bug_file_loc, short_desc, target_milestone, qa_contact, status_whiteboard, DATE_FORMAT(creation_ts,'%Y.%m.%d %H:%i'), - delta_ts, sum(votes.vote_count), + delta_ts, ifnull(sum(votes.vote_count),0), reporter_accessible, cclist_accessible, estimated_time, remaining_time from bugs left join votes using(bug_id), diff --git a/Bugzilla/Bug.pm b/Bugzilla/Bug.pm index 750fd8186..94bd628e2 100755 --- a/Bugzilla/Bug.pm +++ b/Bugzilla/Bug.pm @@ -140,7 +140,7 @@ sub initBug { reporter, bug_file_loc, short_desc, target_milestone, qa_contact, status_whiteboard, DATE_FORMAT(creation_ts,'%Y.%m.%d %H:%i'), - delta_ts, sum(votes.vote_count), + delta_ts, ifnull(sum(votes.vote_count),0), reporter_accessible, cclist_accessible, estimated_time, remaining_time from bugs left join votes using(bug_id), -- cgit v1.2.3-24-g4f1b