From ae8d976e4e354db84f9dfcfa7938eaa8a04f90d9 Mon Sep 17 00:00:00 2001 From: Kern Sibbald Date: Mon, 1 Mar 2010 17:16:57 +0100 Subject: [PATCH] Add Warning check to SQL --- bacula/src/cats/sql_find.c | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) diff --git a/bacula/src/cats/sql_find.c b/bacula/src/cats/sql_find.c index ee3948b642..fb77dee9d5 100644 --- a/bacula/src/cats/sql_find.c +++ b/bacula/src/cats/sql_find.c @@ -1,7 +1,7 @@ /* Bacula® - The Network Backup Solution - Copyright (C) 2000-2009 Free Software Foundation Europe e.V. + Copyright (C) 2000-2010 Free Software Foundation Europe e.V. The main author of Bacula is Kern Sibbald, with contributions from many others, a complete list can be found in the file AUTHORS. @@ -34,7 +34,6 @@ * * Kern Sibbald, December 2000 * - * Version $Id: sql_find.c 8508 2009-03-07 20:59:46Z kerns $ */ @@ -211,8 +210,8 @@ db_find_failed_job_since(JCR *jcr, B_DB *mdb, JOB_DBR *jr, POOLMEM *stime, int & db_lock(mdb); /* Differential is since last Full backup */ Mmsg(mdb->cmd, -"SELECT Level FROM Job WHERE JobStatus NOT IN ('T') AND Type='%c' AND " -"Level IN ('%c','%c') AND Name='%s' AND ClientId=%s " +"SELECT Level FROM Job WHERE JobStatus NOT IN ('T','W') AND " +"Type='%c' AND Level IN ('%c','%c') AND Name='%s' AND ClientId=%s " "AND FileSetId=%s AND StartTime>'%s' " "ORDER BY StartTime DESC LIMIT 1", jr->JobType, L_FULL, L_DIFFERENTIAL, jr->Name, -- 2.39.5