bweb: Fix #1915 about bad SQL in View Jobs

diff --git a/gui/bweb/lib/Bweb.pm b/gui/bweb/lib/Bweb.pm
index b1b09908f6c73c0c80fd2ef94db802a06e7e8793..5b6a189f76bdcf149863101ff56f8980145e3c05 100644 (file)
--- a/gui/bweb/lib/Bweb.pm
+++ b/gui/bweb/lib/Bweb.pm
@@ -2509,7 +2509,7 @@ JOIN client_group USING (client_group_id)
 ";
     }
     my $filter = $self->get_client_filter();
-    my $comment = $self->get_db_field('Comment');
+    my $comment = $self->get_db_field('Job.Comment');
     my $rb = $self->get_db_field('ReadBytes');
     my $query="
 SELECT  Job.JobId       AS jobid,
@@ -2557,8 +2557,8 @@ sub get_db_field
 {
     my ($self, $what) = @_ ;
 
-    my %feature = ('Comment' => 4, 'ReadBytes' => 4);
-    my %replacement = ('Comment' => "''", 'ReadBytes' => 'JobBytes');
+    my %feature = ('Job.Comment' => 4, 'ReadBytes' => 4);
+    my %replacement = ('Job.Comment' => "''", 'ReadBytes' => 'JobBytes');
 
     if (!$self->{info}->{dir_ver} or 
         $self->{info}->{dir_ver} >= $feature{$what})
@@ -2579,7 +2579,7 @@ sub display_job_zoom
 
     # get security filter
     my $filter = $self->get_client_filter();
-    my $comment = $self->get_db_field('Comment');
+    my $comment = $self->get_db_field('Job.Comment');
     my $rb = $self->get_db_field('ReadBytes');
     my $query="
 SELECT DISTINCT Job.JobId       AS jobid,