From b9402d3e113b408143c7ad18f1cb798023c7d178 Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Sat, 19 Feb 2005 00:14:26 +0000 Subject: Bug 280497: Replace "LIMIT" with Bugzilla::DB function call Patch By Tomas Kopal r=mkanat,a=justdave --- sanitycheck.cgi | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'sanitycheck.cgi') diff --git a/sanitycheck.cgi b/sanitycheck.cgi index 81afe79c5..1696a3e7a 100755 --- a/sanitycheck.cgi +++ b/sanitycheck.cgi @@ -118,7 +118,7 @@ if (defined $cgi->param('rebuildvotecache')) { if (defined $cgi->param('rederivegroups')) { Status("OK, All users' inherited permissions will be rechecked when " . "they next access Bugzilla."); - SendSQL("UPDATE groups SET last_changed = NOW() LIMIT 1"); + SendSQL("UPDATE groups SET last_changed = NOW() " . $dbh->sql_limit(1)); } # rederivegroupsnow is REALLY only for testing. @@ -152,8 +152,8 @@ if (defined $cgi->param('cleangroupsnow')) { $dbh->bz_lock_tables('user_group_map WRITE', 'profiles WRITE'); SendSQL("SELECT userid FROM profiles " . "WHERE refreshed_when > 0 " . - "AND refreshed_when < " . SqlQuote($cutoff) . - " LIMIT 1000"); + "AND refreshed_when < " . SqlQuote($cutoff) . " " . + $dbh->sql_limit(1000)); my $count = 0; while ((my $id) = FetchSQLData()) { $count++; -- cgit v1.2.3-24-g4f1b