Hi, it seems Bacula 3.0.2 (using sqlite) have some problems using the JobList function of bat. The Query failed (i think because of the DISTINCT):
bat: joblist/joblist.cpp:147 Query cmd : SELECT Job.JobId AS JobId, Job.Name AS JobName, Client.Name AS Client, Job.Starttime AS JobStart, Job.Type AS JobType, Job.Level AS BackupLevel, Job.Jobfiles AS FileCount, Job.JobBytes AS Bytes, Job.JobStatus AS Status, Job.PurgedFiles AS Purged, FileSet.FileSet, Pool.Name AS Pool, (SELECT Media.VolumeName FROM JobMedia JOIN Media ON JobMedia.MediaId=Media.MediaId WHERE JobMedia.JobId=Job.JobId ORDER BY JobMediaId LIMIT 1) AS FirstVolume, (SELECT count(DISTINCT MediaId) FROM JobMedia WHERE JobMedia.JobId=Job.JobId) AS Volumes FROM Job JOIN Client ON (Client.ClientId=Job.ClientId) LEFT OUTER JOIN FileSet ON (FileSet.FileSetId=Job.FileSetId) LEFT OUTER JOIN Pool ON Job.PoolId = Pool.PoolId ORDER BY Job.JobId DESC LIMIT 150 Mit freundlichen Grüßen / Best regards Markus Kress System Technologies GLS IT-Services GmbH GLS Germany-Straße 1-7 36286 Neuenstein Germany T +49 (0) 66 77 17 426 M +49 (0) 172 1781 426 F +49 (0) 66 77 17 486 E markus.kr...@gls-itservices.com ___________________________________________________________________________________________________________________ GLS IT Services GmbH Sitz: Neuenstein, Amtsgericht Bad Hersfeld HRB 388, Geschäftsführer: Rüdiger Schmahl ___________________________________________________________________________________________________________________ ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
