From a555b683f3a0336bd2b7ad844d755b46071aa53a Mon Sep 17 00:00:00 2001
From: Davide Franco <bacula-dev@dflc.ch>
Date: Tue, 12 Jul 2011 07:10:53 +0200
Subject: [PATCH] bacula-web: Fixed typo in sql query and variable name

---
 gui/bacula-web/jobs.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/gui/bacula-web/jobs.php b/gui/bacula-web/jobs.php
index 3eeb9a575d..35bf7737e8 100644
--- a/gui/bacula-web/jobs.php
+++ b/gui/bacula-web/jobs.php
@@ -61,7 +61,7 @@
 			$query .= "WHERE Job.JobStatus = 'T' ";
 		break;
 		case STATUS_FAILED:
-			$query .= "WHERE Job.JobStatus = 'f', 'E' ";
+			$query .= "WHERE Job.JobStatus IN ('f', 'E') ";
 		break;
 		case STATUS_CANCELED:
 			$query .= "WHERE Job.JobStatus = 'A' ";
@@ -87,7 +87,7 @@
   $jobsresult = $dbSql->db_link->query( $query );
   
   if( PEAR::isError( $jobsresult ) ) {
-	  $dbSql->TriggerDBError( "Unable to get last failed jobs from catalog", $jobresult );
+	  $dbSql->TriggerDBError( "Unable to get last failed jobs from catalog", $jobsresult );
   }else {
 	  while( $job = $jobsresult->fetchRow( DB_FETCHMODE_ASSOC ) ) {
 		
-- 
2.39.5