From b13d809d15bf0de6ec2f56b976bab3cca3e0f8e6 Mon Sep 17 00:00:00 2001
From: Byron Jones <glob@mozilla.com>
Date: Thu, 6 Nov 2014 12:59:05 +0800
Subject: Bug 1093479: view job queue shows incorrect value for error_count
 r=dylan,a=glob

---
 view_job_queue.cgi | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'view_job_queue.cgi')

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
-- 
cgit v1.2.3-24-g4f1b