From 42e09cf141a6c0c1666ad9630e52045f95498b11 Mon Sep 17 00:00:00 2001 From: Davide Franco Date: Wed, 19 Jan 2011 10:37:21 +0100 Subject: [PATCH] bacula-web: Fixed wrong SQL query for failed jobs - Added job status to failed filter in jobs.php and bweb.inc.php --- gui/bacula-web/bweb.inc.php | 2 +- gui/bacula-web/jobs.php | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/gui/bacula-web/bweb.inc.php b/gui/bacula-web/bweb.inc.php index c3ab7cc6af..a3b4f0a2fd 100644 --- a/gui/bacula-web/bweb.inc.php +++ b/gui/bacula-web/bweb.inc.php @@ -366,7 +366,7 @@ class Bweb extends DB { $where_status = "JobStatus = 'T' "; break; case 'failed': - $where_status = "JobStatus = 'f' "; + $where_status = "JobStatus IN ('f','E') "; break; case 'canceled': $where_status = "JobStatus = 'A' "; diff --git a/gui/bacula-web/jobs.php b/gui/bacula-web/jobs.php index 4a74a32469..5d126ec713 100644 --- a/gui/bacula-web/jobs.php +++ b/gui/bacula-web/jobs.php @@ -53,7 +53,7 @@ $query .= "WHERE Job.JobStatus = 'T' "; break; case 'failed': - $query .= "WHERE Job.JobStatus = 'f' "; + $query .= "WHERE Job.JobStatus IN ('f','E') "; break; case 'canceled': $query .= "WHERE Job.JobStatus = 'A' "; -- 2.39.5