Re-fixing bug 30694. part of the original patch got left out.

2 files changed, 3 insertions, 6 deletions

diff --git a/bug_form.pl b/bug_form.pl
index fcd33a7a1..a9daf8932 100644
--- a/bug_form.pl
+++ b/bug_form.pl
@@ -321,11 +321,8 @@ sub EmitDependList {
     my ($desc, $myfield, $targetfield) = (@_);
     print "<th align=right>$desc:</th><td>";
     my @list;
-    SendSQL("select dependencies.$targetfield
- from dependencies, bugs
- where dependencies.$myfield = $id
-   and bugs.bug_id = dependencies.$targetfield
- order by dependencies.$targetfield");
+    SendSQL("select $targetfield from dependencies where  
+             $myfield = $id order by $targetfield");
     while (MoreSQLData()) {
         my ($i) = (FetchSQLData());
         push(@list, $i);
diff --git a/processmail b/processmail
index f3dfdebdb..15b0c6366 100755
--- a/processmail
+++ b/processmail
@@ -141,7 +141,7 @@ sub DescDependencies {
                 my ($bug_status, $resolution) = (FetchSQLData());
                 my $desc;
                 if ($bug_status eq "NEW" || $bug_status eq "ASSIGNED" ||
-                    $bug_status eq "REOPENED") {
+                    $bug_status eq "REOPENED" || $bug_status eq "UNCONFIRMED") {
                     $desc = "";
                 } else {
                     $desc = "[$resolution]";