Patch by daa@rmi.net (Dave Avery) -- newer alphas of MySQL won't let

use "when" as a column name, so let's change our usage while it's
still easy to do so.

1 files changed, 2 insertions, 2 deletions

diff --git a/buglist.cgi b/buglist.cgi
index 07e05900f..24584e6fe 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -392,13 +392,13 @@ if (defined $ref && 0 < @$ref) {
     }
     $query .= "and bugs_activity.bug_id = bugs.bug_id and (" .
         join(' or ', @list) . ") ";
-    $query .= "and bugs_activity.when >= " .
+    $query .= "and bugs_activity.bug_when >= " .
         SqlifyDate($::FORM{'chfieldfrom'}) . "\n";
     my $to = $::FORM{'chfieldto'};
     if (defined $to) {
         $to = trim($to);
         if ($to ne "" && $to !~ /^now$/i) {
-            $query .= "and bugs_activity.when <= " . SqlifyDate($to) . "\n";
+            $query .= "and bugs_activity.bug_when <= " . SqlifyDate($to) . "\n";
         }
     }
     my $value = $::FORM{'chfieldvalue'};