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