summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorByron Jones <glob@mozilla.com>2014-11-06 05:59:05 +0100
committerByron Jones <glob@mozilla.com>2014-11-06 05:59:05 +0100
commitb13d809d15bf0de6ec2f56b976bab3cca3e0f8e6 (patch)
treecd7b65c1dc88e8e5e37ea9d1e78085031184d8c0
parent5afebc8e1c107caea50aa8987aabb8bcdf9bc503 (diff)
downloadbugzilla-b13d809d15bf0de6ec2f56b976bab3cca3e0f8e6.tar.gz
bugzilla-b13d809d15bf0de6ec2f56b976bab3cca3e0f8e6.tar.xz
Bug 1093479: view job queue shows incorrect value for error_count
r=dylan,a=glob
-rwxr-xr-xview_job_queue.cgi5
1 files changed, 4 insertions, 1 deletions
diff --git a/view_job_queue.cgi b/view_job_queue.cgi
index 5d0ed9530..29222725a 100755
--- a/view_job_queue.cgi
+++ b/view_job_queue.cgi
@@ -45,7 +45,10 @@ sub generate_report {
j.run_after AS run_time,
j.grabbed_until,
f.funcname AS func,
- e.jobid AS error_count,
+ (SELECT COUNT(*)
+ FROM ts_error
+ WHERE ts_error.jobid = j.jobid
+ ) AS error_count,
e.error_time AS error_time,
e.message AS error_message
FROM