Hi Robert, On Montag 15 Juni 2009 08:54:33 wrote: > Ok i can confirm that th query does fail when entered manualy into > mysql > > building directory tree for JobId(s) 1 ... Query failed: SELECT > Path.Path, Filename.Name, File.FileIndex, File.JobId, File.LStat > FROM ( SELECT max(FileId) > as FileId, PathId, FilenameId FROM (SELECT FileId, PathId, > FilenameId FROM File WHERE JobId IN (1)) AS F GROUP BY PathId, > FilenameId ) AS Temp JOIN Filename ON (Filename.FilenameId = > Temp.FilenameId) JOIN Path ON (Path.PathId = Temp.PathId) JOIN > File ON (File.FileId = Temp.FileId) WHERE File.FileIndex > 0 ORDER > BY JobId, FileIndex > > ASC: 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 max(FileId) as FileId, PathId, FilenameId FROM (SELECT F
if this statement is correct copied then bacula makes this error, the statement has imho really syntactical failures: SELECT Path.Path, Filename.Name, File.FileIndex, File.JobId, File.LStat FROM here is imho a tablename and the WHERE clause missing. ( SELECT max(FileId)... please make an entry in the bug database. Regards Falk ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
