On Mon, 2007-09-17 at 14:21 +0200, Kern Sibbald wrote:
> On Monday 17 September 2007 13:35, Dirk H Bartley wrote:
> > 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 JO
On Monday 17 September 2007 13:35, Dirk H Bartley wrote:
> 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
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 ... :)
>
> An
On Sunday 16 September 2007 20:37, Kern Sibbald wrote:
> On Sunday 16 September 2007 15:47, 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
On Sunday 16 September 2007 17:47, Marc Cousin wrote:
> what do you means by that ? you get a nested query error ?
Most likely some place it uses a select within a select.
>
> On Sunday 16 September 2007 15:47:34 Scott Barninger wrote:
> > FYI,
> >
> > The problem recently resolved in the directo
On Sunday 16 September 2007 15:47, 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 whe
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 Barning
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 confi
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
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="
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.J
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
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
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.
-
14 matches
Mail list logo
