Yes, the batch insert capability requires, I believe, MySQL 4.1 or greater (I forget the minimum postgresql version). That is why I am now building the director packages for older platforms with batch insert disabled. I suspect the bat code needs a few #IFDEF statements to turn it off per the configure statement.
On Sun, 2007-09-16 at 19:23 +0200, Marc Cousin wrote: > mmmkay ... > > I'm no mysql expert, but I think I've seen that before 4.0 or something, one > can use LEFT JOIN xxx ON, but not JOIN xxx ON ... > > It's the sort of things that's only funny when you don't have to use > mysql ... :) > > Anyone having mysql can confirm this ? > > > On Sunday 16 September 2007 18:59:29 Scott Barninger wrote: > > 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
