3.23.58 On Sun, 2007-09-16 at 18:45 +0200, Marc Cousin wrote: > 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
