Falk Sauer wrote: > 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 >
Ok I will file a bug and see if someone can take a look at it. Thanks for your help, Bob ------------------------------------------------------------------------------ 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
