summaryrefslogtreecommitdiffstats
path: root/collectstats.pl
diff options
context:
space:
mode:
authormkanat%bugzilla.org <>2008-06-29 00:51:38 +0200
committermkanat%bugzilla.org <>2008-06-29 00:51:38 +0200
commite370d1f52f927045250295c9b0b327145112f0c7 (patch)
treeec138a6af11c9c35e140b73dfacb7b5238b570ea /collectstats.pl
parent62788f041f6df7178e19f11731d1b37245d263bb (diff)
downloadbugzilla-e370d1f52f927045250295c9b0b327145112f0c7.tar.gz
bugzilla-e370d1f52f927045250295c9b0b327145112f0c7.tar.xz
Bug 442175: [Oracle] cron script collectstats.pl doesn't work (ORA error)
Patch By Xiaoou Wu <xiaoou.wu@oracle.com> r=mkanat, a=mkanat
Diffstat (limited to 'collectstats.pl')
-rwxr-xr-xcollectstats.pl2
1 files changed, 1 insertions, 1 deletions
diff --git a/collectstats.pl b/collectstats.pl
index 4c66810a0..160b566c3 100755
--- a/collectstats.pl
+++ b/collectstats.pl
@@ -539,7 +539,7 @@ sub CollectSeriesData {
my $serieses = $dbh->selectall_hashref("SELECT series_id, query, creator " .
"FROM series " .
"WHERE frequency != 0 AND " .
- "($days_since_epoch + series_id) % frequency = 0",
+ "MOD(($days_since_epoch + series_id), frequency) = 0",
"series_id");
# We prepare the insertion into the data table, for efficiency.