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: psepulv...@uco.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
