From 474f43a90af1d19f6323b8fe8bccd0fa9dbbc1d9 Mon Sep 17 00:00:00 2001 From: "mkanat%bugzilla.org" <> Date: Sat, 28 Jun 2008 22:53:25 +0000 Subject: [PATCH] Bug 442175: [Oracle] cron script collectstats.pl doesn't work (ORA error) Patch By Xiaoou Wu r=mkanat, a=mkanat --- collectstats.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/collectstats.pl b/collectstats.pl index 4515b424c4..5c65f2c6ac 100755 --- a/collectstats.pl +++ b/collectstats.pl @@ -565,7 +565,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. -- 2.47.2