From f707464ac9cfea83c3f320c9adfeb871ee2c8b91 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Thu, 7 May 2009 08:00:15 +0000 Subject: [PATCH] ebl fix mysql problem with the restore query git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@8813 91ce42f0-d328-0410-95d8-f526ca767f89 --- gui/bweb/cgi/bresto.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/gui/bweb/cgi/bresto.pl b/gui/bweb/cgi/bresto.pl index fe8f3556bb..6984057439 100755 --- a/gui/bweb/cgi/bresto.pl +++ b/gui/bweb/cgi/bresto.pl @@ -868,7 +868,7 @@ sub fill_table_for_restore # for each file of btemp if ($bvfs->dbh_is_mysql()) { $bvfs->dbh_do("CREATE TEMPORARY TABLE btemp2 AS ( -SELECT max(JobId) as JobId, PathId, FilenameId +SELECT max(JobId) as JobId, PathId, FilenameId, FileIndex FROM btemp GROUP BY PathId, FilenameId HAVING FileIndex > 0 -- 2.39.5