summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorjocuri%softhome.net <>2004-04-01 18:57:59 +0200
committerjocuri%softhome.net <>2004-04-01 18:57:59 +0200
commit424b881b5bb3418848452a016e162c786ade145a (patch)
tree09b48da79b8b502a30e3906a4b5fde503b110412
parent69cc412f296ca0e4c6ba805657a62597b62955c3 (diff)
downloadbugzilla-424b881b5bb3418848452a016e162c786ade145a.tar.gz
bugzilla-424b881b5bb3418848452a016e162c786ade145a.tar.xz
Patch for bug 232554: fix SQL queries in Flag.pm in order to fix a bug that causes flags to remain set but inaccessible when product changes; patch by Max K-A <mkanat@kerio.com>; r=bbaetz,myk; a=justdave.
-rw-r--r--Bugzilla/Flag.pm4
1 files changed, 2 insertions, 2 deletions
diff --git a/Bugzilla/Flag.pm b/Bugzilla/Flag.pm
index 8c9a4befe..3272b8409 100644
--- a/Bugzilla/Flag.pm
+++ b/Bugzilla/Flag.pm
@@ -248,14 +248,14 @@ sub process {
ON (flags.type_id = i.type_id
AND (bugs.product_id = i.product_id OR i.product_id IS NULL)
AND (bugs.component_id = i.component_id OR i.component_id IS NULL))
- WHERE flags.type_id = $target->{'bug'}->{'id'}
+ WHERE bugs.bug_id = $target->{'bug'}->{'id'}
AND i.type_id IS NULL
");
clear(&::FetchOneColumn()) while &::MoreSQLData();
&::SendSQL("
SELECT flags.id
FROM flags, bugs, flagexclusions e
- WHERE flags.type_id = $target->{'bug'}->{'id'}
+ WHERE bugs.bug_id = $target->{'bug'}->{'id'}
AND flags.bug_id = bugs.bug_id
AND flags.type_id = e.type_id
AND (bugs.product_id = e.product_id OR e.product_id IS NULL)