Bacula-users

Re: [Bacula-users] Problem with accurate backups

2009-06-15 03:52:04
Subject: Re: [Bacula-users] Problem with accurate backups
From: Robert W Hartzell <bear AT rwhartzell DOT net>
To: Falk Sauer <falk AT hb-fein DOT de>
Date: Mon, 15 Jun 2009 00:49:04 -0700
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