summaryrefslogtreecommitdiffstats
path: root/sanitycheck.cgi
diff options
context:
space:
mode:
authortravis%sedsystems.ca <>2005-01-29 04:01:27 +0100
committertravis%sedsystems.ca <>2005-01-29 04:01:27 +0100
commited20d719e2df695ed2c9127f364886b902d82a24 (patch)
tree78e3a5205b856822753ff44d7e49f6b967b1d86d /sanitycheck.cgi
parentfc649d472490ea13b935eccf1ecd692dd7112fd4 (diff)
downloadbugzilla-ed20d719e2df695ed2c9127f364886b902d82a24.tar.gz
bugzilla-ed20d719e2df695ed2c9127f364886b902d82a24.tar.xz
Bug 257315 : type of delta_ts in bugs table should not be timestamp
Patch by Tomas Kopal <Tomas.Kopal@altap.cz> r=vladd, 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 4db4e0192..7de0d92ae 100755
--- a/sanitycheck.cgi
+++ b/sanitycheck.cgi
@@ -98,7 +98,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()) {
@@ -106,7 +106,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.");
@@ -588,8 +588,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.");