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