Yes, for example this error when clicking on JobPlot. You get similar errors for JobList and Media.
Query failed: .sql query="SELECT DISTINCT Job.Starttime AS JobStart, Job.Jobfiles AS FileCount, Job.JobBytes AS Bytes, Job.JobId AS JobId FROM Job JOIN Client ON (Client.ClientId=Job.ClientId) JOIN Status ON (Job.JobStatus=Status.JobStatus) LEFT OUTER JOIN FileSet ON (FileSet.FileSetId=Job.FileSetId) ORDER BY Job.Starttime DESC, Job.JobId DESC LIMIT 150". ERR=Query failed: SELECT DISTINCT Job.Starttime AS JobStart, Job.Jobfiles AS FileCount, Job.JobBytes AS Bytes, Job.JobId AS JobId FROM Job JOIN Client ON (Client.ClientId=Job.ClientId) JOIN Status ON (Job.JobStatus=Status.JobStatus) LEFT OUTER JOIN FileSet ON (FileSet.FileSetId=Job.FileSetId) ORDER BY Job.Starttime DESC, Job.JobId DESC LIMIT 150: ERR=You have an error in your SQL syntax near 'ON (Client.ClientId=Job.ClientId) JOIN Status ON (Job.JobStatus=Status.JobStatus' at line 1 On Sun, 2007-09-16 at 17:47 +0200, Marc Cousin wrote: > what do you means by that ? you get a nested query error ? > > On Sunday 16 September 2007 15:47:34 Scott Barninger wrote: > > FYI, > > > > The problem recently resolved in the director for disabling batch insert > > is also present it seems in bat. When connected to my 2.2.4 mysql server > > (rhel3) built with batch insert disabled, I get the same sort of SQL > > error when clicking, for instance, on JobList. > > > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by: Microsoft > > Defy all challenges. Microsoft(R) Visual Studio 2005. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > _______________________________________________ > > Bacula-devel mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/bacula-devel > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Bacula-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/bacula-devel > ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
