Hello. Yesterday I upgraded Bacula (dir, sd, fd) from 2.0.3 to 2.2.0 on FreeBSD-5.3. I use Bacula with MySQL 4.0.27. In the evening all the backups failed with error: ===== 06-Sep 00:33 mydom-sd: Job write elapsed time = 00:00:44, Transfer rate = 2.103 M bytes/second 06-Sep 00:33 mydom-dir: myser-conf.2007-09-06_00.32.49 Fatal error: Can't fill Path table Query failed: INSERT INTO Path (Path) SELECT a.Path FROM (SELECT DISTINCT Path FROM batch) AS a WHERE NOT EXISTS (SELECT Path FROM Path AS p WHERE p.Path = a.Path) : ERR=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 'SELECT DISTINCT Path FROM batch) AS a WHE =====
May the problem be in MySQL, i.e. Bacula 2.2 isn't compatible with MySQL 4.0 although 2.0 was? -- Silver ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
