Hi, 06.09.2007 08:23,, Silver Salonen wrote:: > 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?
Yes... as far as I know, subqueries or nested selects are available ony with MySQL 4.1 and up. Arno -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de ------------------------------------------------------------------------- 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
