>>>>> 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 have an error in your SQL
> >>syntax; check the manual that corresponds to your MySQL server version for
> >>the right syntax to use near
> >>'"MinValue"=1,"MaxValue"=2147483647,CurrentValue=2,WrapCounter='' WHERE
> >>Counter='' at line 1
> >>26-Nov 12:43 sydney-dir JobId 10: Error: Count not update counter
> >>DiffFileVolumeCounter: ERR=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 to your MySQL server version for the right syntax to use
> > near
> > '"MinValue"=1,"MaxValue"=2147483647,CurrentValue=2,WrapCounter='' WHERE
> > Counter='' at line 1
> >>26-Nov 12:43 sydney-dir JobId 10: Created new Volume "DiffFile-0001" in
> >>catalog.
> > I'm getting the error message when upgrading from 5.0.3 to 5.2.1...
>
> I've done some research and found the following in GIT
> >Fix bug #1504 -- Error when creating tables in MySQL 5.5
> This seems to resolve the issue for version 5.5. RHEL, CentOS are
> running version 5.0...
>
> Any help appreciated.
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).
__Martin
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|