Hello Martin,
Friday, December 2, 2011, 12:47:53 PM, you wrote:
> Check the sql_mode of mysqld. The most likely cause of this error is non-ANSI
> mode (see
> http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_ansi).
Put MySQL in ANSI mode and it works. This solved my issue.
> On Fri, 2 Dec 2011 10:08:49 +0100, Armin Tueting said:
>
> >>26-Nov 12:43 sydney-dir JobId 10: Error: sql_update.c:255 sql_update.c:255
> >>update UPDATE Counters SET
> >>"MinValue"=1,"MaxValue"=2147483647,CurrentValue=2,WrapCounter='' WHERE
> >>Counter='DiffFileVolumeCounter' failed: You
>>26-Nov 12:43 sydney-dir JobId 10: Error: sql_update.c:255 sql_update.c:255
>>update UPDATE Counters SET
>>"MinValue"=1,"MaxValue"=2147483647,CurrentValue=2,WrapCounter='' WHERE
>>Counter='DiffFileVolumeCounter' failed: You have an error in your SQL syntax;
>>check the manual that corresponds
