Hi,
I just installed brestore and started brestore.pl. When selecting a
client from the client list I get the following error:
DBD::mysql::st execute failed: 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 ')
ORDER BY 2,3 DESC ) As a' at line 37 at ./brestore.pl line 2048.
DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at
./brestore.pl line 2049.
Switching on debug mode gives the following sql-statement. Any ideas?
SELECT Path, JobId, Lstat FROM(
(
SELECT Path.Path, lower(Path.Path),
listfile.JobId, listfile.Lstat
FROM (
SELECT DISTINCT brestore_pathhierarchy.PathId
FROM brestore_pathhierarchy
JOIN Path
ON (brestore_pathhierarchy.PathId = Path.PathId)
JOIN brestore_pathvisibility
ON (brestore_pathhierarchy.PathId =
brestore_pathvisibility.PathId)
WHERE brestore_pathhierarchy.PPathId = 268387
AND brestore_pathvisibility.jobid IN (107,87,67,47,5)) AS listpath
JOIN Path ON (listpath.PathId = Path.PathId)
LEFT JOIN (
SELECT File.PathId, File.JobId, File.Lstat FROM File
WHERE File.FilenameId = 21
AND File.JobId IN (107,87,67,47,5)) AS listfile
ON (listpath.PathId = listfile.PathId)
UNION
SELECT brestore_missing_path.Path, lower(brestore_missing_path.Path),
listfile.JobId, listfile.Lstat
FROM (
SELECT DISTINCT brestore_pathhierarchy.PathId
FROM brestore_pathhierarchy
JOIN brestore_missing_path
ON (brestore_pathhierarchy.PathId =
brestore_missing_path.PathId)
JOIN brestore_pathvisibility
ON (brestore_pathhierarchy.PathId =
brestore_pathvisibility.PathId)
WHERE brestore_pathhierarchy.PPathId = 268387
AND brestore_pathvisibility.jobid IN (107,87,67,47,5)) AS listpath
JOIN brestore_missing_path ON (listpath.PathId =
brestore_missing_path.PathId)
LEFT JOIN (
SELECT File.PathId, File.JobId, File.Lstat FROM File
WHERE File.FilenameId = 21
AND File.JobId IN (107,87,67,47,5)) AS listfile
ON (listpath.PathId = listfile.PathId))
ORDER BY 2,3 DESC ) As a
--
Regards
Christoph
________________________________________________________________________
Christoph Litauer [EMAIL PROTECTED]
Uni Koblenz, Computing Center, http://www.uni-koblenz.de/~litauer
Postfach 201602, 56016 Koblenz Fon: +49 261 287-1311, Fax: -100 1311
PGP-Fingerprint: F39C E314 2650 650D 8092 9514 3A56 FBD8 79E3 27B2
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
