From 74e35fe774af7cd5e44d9e8b7293ed07d01a163d Mon Sep 17 00:00:00 2001 From: Davide Franco Date: Thu, 3 Feb 2011 14:59:29 +0100 Subject: [PATCH] bacula-web: Fixed SQL query bug in GetStoredBytesByJob() function - Fixed bug in SQL query for GetStoredBytesByJob() function in bweb.inc.php --- gui/bacula-web/bweb.inc.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/gui/bacula-web/bweb.inc.php b/gui/bacula-web/bweb.inc.php index 8e2c68ec5b..2c638ff76e 100644 --- a/gui/bacula-web/bweb.inc.php +++ b/gui/bacula-web/bweb.inc.php @@ -645,7 +645,7 @@ class Bweb extends DB { public function GetStoredBytesByJob( $jobname, $start_date, $end_date ) { $query = "SELECT SUM(JobBytes) as stored_bytes, EndTime FROM Job "; - $query .= "WHERE EndTime BETWEEN ( '$start_date' AND '$end_date' ) AND "; + $query .= "WHERE ( EndTime BETWEEN '$start_date' AND '$end_date' ) AND "; $query .= "Name = '$jobname'"; echo 'query ' . $query . '
'; -- 2.39.2