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