aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authortravis%sedsystems.ca <>2005-02-09 00:51:02 +0000
committertravis%sedsystems.ca <>2005-02-09 00:51:02 +0000
commitf8aeecaf8cd33d87315c5a50be9a762e142062a4 (patch)
treec92dc215a4f6780005bacf825fb6fbdc39552ae1 /sanitycheck.cgi
parentBug 276838 : Eliminate use of $::unconfirmedstate (diff)
downloadbugzilla-f8aeecaf8cd33d87315c5a50be9a762e142062a4.tar.gz
bugzilla-f8aeecaf8cd33d87315c5a50be9a762e142062a4.tar.bz2
bugzilla-f8aeecaf8cd33d87315c5a50be9a762e142062a4.zip
Bug 257315 : type of delta_ts in bugs table should not be timestamp
Patch by Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, LpSolit a=justdave
Diffstat (limited to 'sanitycheck.cgi')
-rwxr-xr-xsanitycheck.cgi7
1 files changed, 3 insertions, 4 deletions
diff --git a/sanitycheck.cgi b/sanitycheck.cgi
index d9c6af221..7bd42d22d 100755
--- a/sanitycheck.cgi
+++ b/sanitycheck.cgi
@@ -96,7 +96,7 @@ PutHeader("Bugzilla Sanity Check");
if (defined $cgi->param('rebuildvotecache')) {
Status("OK, now rebuilding vote cache.");
SendSQL("LOCK TABLES bugs WRITE, votes READ");
- SendSQL("UPDATE bugs SET votes = 0, delta_ts = delta_ts");
+ SendSQL("UPDATE bugs SET votes = 0");
SendSQL("SELECT bug_id, SUM(vote_count) FROM votes GROUP BY bug_id");
my %votes;
while (@row = FetchSQLData()) {
@@ -104,7 +104,7 @@ if (defined $cgi->param('rebuildvotecache')) {
$votes{$id} = $v;
}
foreach my $id (keys %votes) {
- SendSQL("UPDATE bugs SET votes = $votes{$id}, delta_ts = delta_ts WHERE bug_id = $id");
+ SendSQL("UPDATE bugs SET votes = $votes{$id} WHERE bug_id = $id");
}
SendSQL("UNLOCK TABLES");
Status("Vote cache has been rebuilt.");
@@ -586,8 +586,7 @@ if (@badbugs) {
if (exists($realk{$b})) {
$k = $realk{$b};
}
- SendSQL("UPDATE bugs SET delta_ts = delta_ts, keywords = " .
- SqlQuote($k) .
+ SendSQL("UPDATE bugs SET keywords = " . SqlQuote($k) .
" WHERE bug_id = $b");
}
Status("Keyword cache fixed.");