ebl fix segfault with debug mode

[bacula/bacula] / bacula / src / dird / query.sql

diff --git a/bacula/src/dird/query.sql b/bacula/src/dird/query.sql
index a287e4e884ff31244efdedb12a9e4e7b5c46073f..b18f10fd65df9c66b545ae9f74de9bdf56e50c0d 100644 (file)
--- a/bacula/src/dird/query.sql
+++ b/bacula/src/dird/query.sql
@@ -56,8 +56,8 @@ SELECT DISTINCT Job.JobId as JobId,Client.Name as Client,
    JobFiles,JobBytes,VolumeName
  FROM Client,Job,JobMedia,Media,FileSet
  WHERE Client.Name='%1'
- AND Client.ClientId=Job.ClientId
- AND JobStatus='T' AND Job.FileSetId=FileSet.FileSetId
+ AND Client.ClientId=Job.ClientId AND Job.Type='B'
+ AND Job.JobStatus='T' AND Job.FileSetId=FileSet.FileSetId
  AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
  ORDER BY Job.StartTime;
 # 6
@@ -150,7 +150,7 @@ SELECT Path.Path,Filename.Name FROM File,Filename,Path WHERE File.JobId=%1
  AND Path.PathId=File.PathId ORDER BY
  Path.Path,Filename.Name;
 # 13
-:List Jobs stored in a selected MediaId
+:List Jobs stored on a selected MediaId
 *Enter MediaId:
 SELECT DISTINCT Job.JobId,Job.Name,Job.StartTime,Job.Type,
   Job.Level,Job.JobFiles,Job.JobBytes,Job.JobStatus