From 413a75cafd2c8af9b520c483e85e8995c4ccca96 Mon Sep 17 00:00:00 2001 From: "bugreport%peshkin.net" <> Date: Sun, 10 Nov 2002 02:09:25 +0000 Subject: Bug 179242 Searching for comment contains string + email gives "Not unique table/alias: 'longdescs_' at globals.pl line 242" r=jake a=myk --- Bugzilla/Search.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'Bugzilla') diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index cea9294ca..73d95c524 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -202,7 +202,7 @@ sub init { } if ($params->param("emaillongdesc$id")) { if (my $list = $self->ListIDsForEmail($type, $email)) { - my $table = "longdescs_"; + my $table = "longdescs_email_$id"; push(@supptables, "LEFT JOIN longdescs $table ON bugs.bug_id = $table.bug_id AND $table.who IN($list)"); push(@clist, "$table.who",'isnotnull'); } else { -- cgit v1.2.3-24-g4f1b