From a0474f9b9a4583edc5c557c04ee5e6f3843d7b15 Mon Sep 17 00:00:00 2001
From: Eric Bollengier <eric@eb.homelinux.org>
Date: Thu, 17 Aug 2006 21:33:36 +0000
Subject: [PATCH] ebl  fix media_zoom query

git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@3302 91ce42f0-d328-0410-95d8-f526ca767f89
---
 gui/bweb/lib/Bweb.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/gui/bweb/lib/Bweb.pm b/gui/bweb/lib/Bweb.pm
index f7974b2745..883b08ce8a 100644
--- a/gui/bweb/lib/Bweb.pm
+++ b/gui/bweb/lib/Bweb.pm
@@ -1978,7 +1978,7 @@ SELECT InChanger     AS online,
           $self->{sql}->{UNIX_TIMESTAMP}(Media.LastWritten) 
         + $self->{sql}->{TO_SEC}(Media.VolRetention)
        ) AS expire
- FROM Job,Pool,
+ FROM Pool,
       Media LEFT JOIN Location ON (Media.LocationId = Location.LocationId)
  WHERE Pool.PoolId = Media.PoolId
  AND VolumeName IN ($medias->{jmedias})
-- 
2.39.5