From bbb9c02f500b84986064c6533ced4b35f7435efa Mon Sep 17 00:00:00 2001
From: "terry%mozilla.org" <>
Date: Tue, 12 Oct 1999 18:18:28 +0000
Subject: Updating the vote cache should not update the date-last-changed field
 in the bug.

---
 doeditvotes.cgi | 2 +-
 globals.pl      | 2 +-
 sanitycheck.cgi | 6 +++---
 3 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/doeditvotes.cgi b/doeditvotes.cgi
index c499af494..2584d583b 100755
--- a/doeditvotes.cgi
+++ b/doeditvotes.cgi
@@ -103,7 +103,7 @@ foreach my $id (@buglist) {
 foreach my $id (keys %affected) {
     SendSQL("select sum(count) from votes where bug_id = $id");
     my $v = FetchOneColumn();
-    SendSQL("update bugs set votes = $v where bug_id = $id");
+    SendSQL("update bugs set votes = $v, delta_ts=delta_ts where bug_id = $id");
 }
 SendSQL("unlock tables");
 
diff --git a/globals.pl b/globals.pl
index ac18305e1..2f915ca5f 100644
--- a/globals.pl
+++ b/globals.pl
@@ -535,7 +535,7 @@ sub RemoveVotes {
             close SENDMAIL;
         }
         SendSQL("delete from votes where bug_id = $id");
-        SendSQL("update bugs set votes = 0 where bug_id = $id");
+        SendSQL("update bugs set votes = 0, delta_ts=delta_ts where bug_id = $id");
     }
 }
 
diff --git a/sanitycheck.cgi b/sanitycheck.cgi
index b1b2022eb..0805f063a 100755
--- a/sanitycheck.cgi
+++ b/sanitycheck.cgi
@@ -63,7 +63,7 @@ PutHeader("Bugzilla Sanity Check");
 if (exists $::FORM{'rebuildvotecache'}) {
     Status("OK, now rebuilding vote cache.");
     SendSQL("lock tables bugs write, votes read");
-    SendSQL("update bugs set votes = 0");
+    SendSQL("update bugs set votes = 0, delta_ts=delta_ts");
     SendSQL("select bug_id, sum(count) from votes group by bug_id");
     my %votes;
     while (@row = FetchSQLData()) {
@@ -71,10 +71,10 @@ if (exists $::FORM{'rebuildvotecache'}) {
         $votes{$id} = $v;
     }
     foreach my $id (keys %votes) {
-        SendSQL("update bugs set votes = $votes{$id} where bug_id = $id");
+        SendSQL("update bugs set votes = $votes{$id}, delta_ts=delta_ts where bug_id = $id");
     }
     SendSQL("unlock tables");
-    Status("Vote cache has been rebuild.");
+    Status("Vote cache has been rebuilt.");
 }
 
 print "OK, now running sanity checks.<P>\n";
-- 
cgit v1.2.3-24-g4f1b