From 827fcaa6c989f3bc78b4efa5ca9d8b4f7ea2277b Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Thu, 6 Aug 2009 14:48:07 +0200 Subject: [PATCH] fix mysql case problem in bweb/bresto --- gui/bweb/cgi/bresto.pl | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/gui/bweb/cgi/bresto.pl b/gui/bweb/cgi/bresto.pl index 53de360a1f..51c2bb0893 100755 --- a/gui/bweb/cgi/bresto.pl +++ b/gui/bweb/cgi/bresto.pl @@ -398,9 +398,9 @@ UNION (SELECT $pathid AS PathId, '.' AS Path))"; my $sq2 = " -SELECT tmp.PathId, tmp.Path, Lstat, JobId +SELECT tmp.PathId, tmp.Path, LStat, JobId FROM $sq1 AS tmp LEFT JOIN ( -- get attributes if any - SELECT File1.PathId, File1.JobId, File1.Lstat FROM File AS File1 + SELECT File1.PathId, File1.JobId, File1.LStat FROM File AS File1 WHERE File1.FilenameId = $dir_filenameid AND File1.JobId IN ($jobclause)) AS listfile1 ON (tmp.PathId = listfile1.PathId) @@ -466,10 +466,10 @@ sub ls_dirs # Then we get all the dir entries from File ... my $query = " -SELECT PathId, Path, JobId, Lstat FROM ( +SELECT PathId, Path, JobId, LStat FROM ( SELECT Path1.PathId, Path1.Path, lower(Path1.Path), - listfile1.JobId, listfile1.Lstat + listfile1.JobId, listfile1.LStat FROM ( SELECT DISTINCT brestore_pathhierarchy1.PathId FROM brestore_pathhierarchy AS brestore_pathhierarchy1 @@ -484,7 +484,7 @@ SELECT PathId, Path, JobId, Lstat FROM ( JOIN Path AS Path1 ON (listpath1.PathId = Path1.PathId) LEFT JOIN ( -- get attributes if any - SELECT File1.PathId, File1.JobId, File1.Lstat FROM File AS File1 + SELECT File1.PathId, File1.JobId, File1.LStat FROM File AS File1 WHERE File1.FilenameId = $dir_filenameid AND File1.JobId IN ($jobclause)) AS listfile1 ON (listpath1.PathId = listfile1.PathId) @@ -615,7 +615,7 @@ sub get_all_file_versions my @versions; my $query; $query = -"SELECT File.JobId, File.FileId, File.Lstat, +"SELECT File.JobId, File.FileId, File.LStat, File.Md5, Media.VolumeName, Media.InChanger FROM File, Job, Client, JobMedia, Media WHERE File.FilenameId = $fileid -- 2.39.5