I don't think there is any link between batch inserts and the problem you're facing. It's a common cause (bat and batch insert are both using "advanced" statements, not that advanced but still too much it seems) but both problems are separated.
On Sunday 16 September 2007 19:41:25 Scott Barninger wrote: > 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
