From edb9e442f3c77b8138aecb12fdb3d89d0a68ad46 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Thu, 3 Feb 2011 13:00:37 +0100 Subject: [PATCH] Fix bvfs for mysql --- bacula/src/cats/sql_cmds.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c index c35701a301..26ff05276c 100644 --- a/bacula/src/cats/sql_cmds.c +++ b/bacula/src/cats/sql_cmds.c @@ -840,8 +840,8 @@ const char *sql_bvfs_select[] = { }; const char *sql_bvfs_list_files_default = -"SELECT 'F', PathId, T1.FilenameId, Filename.Name, " - "File.JobId, LStat, FileId " +"SELECT 'F', T1.PathId, T1.FilenameId, Filename.Name, " + "File.JobId, File.LStat, File.FileId " "FROM Job, File, ( " "SELECT MAX(JobTDate) AS JobTDate, PathId, FilenameId " "FROM ( " -- 2.39.5