diff options
| author | jocuri%softhome.net <> | 2004-04-01 18:57:59 +0200 |
|---|---|---|
| committer | jocuri%softhome.net <> | 2004-04-01 18:57:59 +0200 |
| commit | 424b881b5bb3418848452a016e162c786ade145a (patch) | |
| tree | 09b48da79b8b502a30e3906a4b5fde503b110412 | |
| parent | 69cc412f296ca0e4c6ba805657a62597b62955c3 (diff) | |
| download | bugzilla-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.pm | 4 |
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) |