Hi all:
I have bacula 3.0.2 with mysql databaes. When I need to do a restore,
bacula show this message:
-- Building directory tree for JobId(s) 14 ... 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 (14)) 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
So I can't view the tree of mi bacula backup.
Could someone help me?
Tanks a lot
Pedro Sepúlveda
Servicio de Informática (Area de Gestión - Sistemas)
Universidad de Córdoba
+-----------------------------^------------------------+
| email: psepulveda AT uco DOT es ^ Pedro Sepúlveda |
| http://www.uco.es/~cc0semop ^ Cordoba (SPAIN) |
+-----------------------------^------------------------+
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) 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/devconference
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|