From a8c30efe3b1bf80b19b298f673e801ec3dc573e4 Mon Sep 17 00:00:00 2001 From: Kern Sibbald Date: Mon, 28 Sep 2009 09:22:56 +0200 Subject: [PATCH] Attempt to fix MySQL SQL error --- bacula/src/cats/sql_cmds.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c index 476ba63d75..8b28422e0a 100644 --- a/bacula/src/cats/sql_cmds.c +++ b/bacula/src/cats/sql_cmds.c @@ -310,7 +310,7 @@ const char *uar_last_full = "INSERT INTO temp1 SELECT Job.JobId,JobTdate " "FROM Client,Job,JobMedia,Media,FileSet WHERE Client.ClientId=%s " "AND Job.ClientId=%s " - "AND Job.StartTime<'%s' " + "AND Job.StartTime < '%s' " "AND Level='F' AND JobStatus IN ('T','W') AND Type='B' " "AND JobMedia.JobId=Job.JobId " "AND Media.Enabled=1 " -- 2.39.5