From bc6766eefba6380e5aa04b34a764d9216622a349 Mon Sep 17 00:00:00 2001 From: Marcin Haba Date: Tue, 15 May 2018 21:34:23 +0200 Subject: [PATCH] baculum: Fix SQL grouping error in restore wizard reported by Rasmus Linden --- gui/baculum/protected/API/Class/VolumeManager.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/gui/baculum/protected/API/Class/VolumeManager.php b/gui/baculum/protected/API/Class/VolumeManager.php index 35265beb97..48b25d74d2 100644 --- a/gui/baculum/protected/API/Class/VolumeManager.php +++ b/gui/baculum/protected/API/Class/VolumeManager.php @@ -85,7 +85,7 @@ class VolumeManager extends APIModule { $sql = sprintf('SELECT first_index, last_index, VolumeName AS volname, InChanger AS inchanger FROM ( SELECT VolumeName, InChanger, MIN(FirstIndex) as first_index, MAX(LastIndex) as last_index FROM JobMedia JOIN Media ON (JobMedia.MediaId = Media.MediaId) - WHERE JobId = %d GROUP BY (VolumeName, InChanger) + WHERE JobId = %d GROUP BY VolumeName, InChanger ) AS gv, File WHERE FileIndex >= first_index AND FileIndex <= last_index -- 2.39.2