From 82ca4f3aedceae472c5158c80bc9b910f215a12c Mon Sep 17 00:00:00 2001 From: Kern Sibbald Date: Mon, 28 Sep 2009 09:27:10 +0200 Subject: [PATCH] Attempt to fix MySQL SQL error --- bacula/src/cats/sql_cmds.c | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c index 476ba63d75..4d7956aaae 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 " @@ -336,7 +336,7 @@ const char *uar_dif = "Job.StartTime,Media.VolumeName,JobMedia.StartFile," "Job.VolSessionId,Job.VolSessionTime " "FROM Job,JobMedia,Media,FileSet " - "WHERE Job.JobTDate>%s AND Job.StartTime<'%s' " + "WHERE Job.JobTDate>%s AND Job.StartTime < '%s' " "AND Job.ClientId=%s " "AND JobMedia.JobId=Job.JobId " "AND Media.Enabled=1 " @@ -353,7 +353,7 @@ const char *uar_inc = "Job.StartTime,Media.VolumeName,JobMedia.StartFile," "Job.VolSessionId,Job.VolSessionTime " "FROM Job,JobMedia,Media,FileSet " - "WHERE Job.JobTDate>%s AND Job.StartTime<'%s' " + "WHERE Job.JobTDate>%s AND Job.StartTime < '%s' " "AND Job.ClientId=%s " "AND Media.Enabled=1 " "AND JobMedia.JobId=Job.JobId " -- 2.39.5