>>>>> 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