> From: h...@tbbs.net
>
> 2013/11/04 09:32 -0800, Jan Steinman
>> I noticed that I have similar queries that work as expected. The difference
>> appears to be that every query that is broken uses " WITH ROLLUP", and
>> removing this makes them behave as expected.
>>
>> Is this a known bug? Shou
Hi Jesper
I was just discussing this with the development manager now and the
following was noted.
- The query was written for mysql 4.0 originally and it seems
that in version 5.0 they had enabled some legacy support stuff ( I am
not too familiar with this as it is before my mys
Happiness, that gave me what I was looking for. Thank you Johan.
I have tested the option you gave me but my brackets was in the wrong place.
On 08/11/2013 13:23, Johan De Meersman wrote:
- Original Message -
From: "Machiel Richards"
ERROR 1064 (42000): You have an error in your S
- Original Message -
> From: "Machiel Richards"
>
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'GROUP BY t.AccountID,
I suspect your query has never been doing what you thi
Hi Machiel,
On 8/11/2013 20:04, Machiel Richards wrote:
Good day all
I am hoping someone can assist me in the following.
One of our servers were running mysql 5.0 still and as part of
a phased upgrade route we have upgraded to version 5.1.
However since the upgrade, t
Good day all
I am hoping someone can assist me in the following.
One of our servers were running mysql 5.0 still and as part of
a phased upgrade route we have upgraded to version 5.1.
However since the upgrade, the query below gives us an error
stating that the syntax
