From 2f3084922bfe7cb8759fe4064c46311385fa23f0 Mon Sep 17 00:00:00 2001 From: "lpsolit%gmail.com" <> Date: Fri, 16 Sep 2005 21:57:00 +0000 Subject: Bug 308653: The error 'relation "map_products" does not exist' is returned using PostgreSQL when the classification column is displayed - Patch by Frédéric Buclin r=mkanat a=justdave MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- Bugzilla/Search.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'Bugzilla') diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index 55113f641..fc66d7f24 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -139,11 +139,11 @@ sub init { } if (lsearch($fieldsref, 'map_classifications.name') >= 0) { + push @supptables, "INNER JOIN products AS map_products " . + "ON bugs.product_id = map_products.id"; push @supptables, "INNER JOIN classifications AS map_classifications " . "ON map_products.classification_id = map_classifications.id"; - push @supptables, "INNER JOIN products AS map_products " . - "ON bugs.product_id = map_products.id"; } if (lsearch($fieldsref, 'map_components.name') >= 0) { -- cgit v1.2.3-24-g4f1b