what's the mysql version ? On Sunday 16 September 2007 18:19:50 Scott Barninger wrote: > 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
