From 94c2df0e830ea7070436f8ade182645893ac3373 Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Fri, 25 Feb 2005 11:16:47 +0000
Subject: Bug 279910: Query crashed with Software Error: "Unknown column
 'bugs.assignee_accessible' " Patch By Frederic Buclin <LpSolit@gmail.com>
 r=myk, a=myk

---
 Bugzilla/DB.pm | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'Bugzilla')

diff --git a/Bugzilla/DB.pm b/Bugzilla/DB.pm
index 8ef05e12e..e4aa779b8 100644
--- a/Bugzilla/DB.pm
+++ b/Bugzilla/DB.pm
@@ -218,14 +218,14 @@ sub bz_get_field_defs {
 
     my $extra = "";
     if (!&::UserInGroup(Param('timetrackinggroup'))) {
-        $extra = "WHERE name NOT IN ('estimated time', 'remaining_time', " .
+        $extra = "AND name NOT IN ('estimated_time', 'remaining_time', " .
                  "'work_time', 'percentage_complete', 'deadline')";
     }
 
     my @fields;
-    my $sth = $self->prepare("SELECT name, description
-                                FROM fielddefs $extra
-                            ORDER BY sortkey");
+    my $sth = $self->prepare("SELECT name, description FROM fielddefs
+                              WHERE obsolete = 0 $extra
+                              ORDER BY sortkey");
     $sth->execute();
     while (my $field_ref = $sth->fetchrow_hashref()) {
         push(@fields, $field_ref);
-- 
cgit v1.2.3-24-g4f1b