summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorjustdave%syndicomm.com <>2003-09-02 15:54:58 +0200
committerjustdave%syndicomm.com <>2003-09-02 15:54:58 +0200
commit4015bef325a73631bd244b4e0905f9f450145aae (patch)
tree9d875fc3b7bc3b879960a4a58209983b23eb98a1
parente941bb43e05a8560f5412299216f0d3846511cb0 (diff)
downloadbugzilla-4015bef325a73631bd244b4e0905f9f450145aae.tar.gz
bugzilla-4015bef325a73631bd244b4e0905f9f450145aae.tar.xz
Bug 217422: "0" was missing in "votes: 0" (MySQL 4 compatibility)
r= bbaetz, a= justdave
-rwxr-xr-xBug.pm2
-rwxr-xr-xBugzilla/Bug.pm2
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),