>>>>> 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users