[Bacula-users] Query failed: bat, sqlite and JobList

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.kress AT gls-itservices DOT com


___________________________________________________________________________________________________________________

GLS IT Services GmbH
Sitz: Neuenstein, Amtsgericht Bad Hersfeld HRB 388, Geschäftsführer: Rüdiger 
Schmahl
___________________________________________________________________________________________________________________

------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; 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&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users