Bacula-users

[Bacula-users] Error in restore

2009-10-13 08:33:23
Subject: [Bacula-users] Error in restore
From: Pedro Sepúlveda <cc0semop AT uco DOT es>
To: Bacula <bacula-users AT lists.sourceforge DOT net>
Date: Thu, 24 Sep 2009 11:58:42 +0200
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

<Prev in Thread] Current Thread [Next in Thread>
  • [Bacula-users] Error in restore, Pedro Sepúlveda <=