X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fotaker_Mixin.pm;fp=FS%2FFS%2Fotaker_Mixin.pm;h=0da9aeedbf28d0f714e2644dfff1482c1d674d14;hb=24e81f4d632ebb4af2d8a68e64352c37052781b5;hp=4aa47c38d82d85384a94c518524851f92f5e1eb4;hpb=649cb6a173a4278f3c4e0c960ce5b71422329222;p=freeside.git diff --git a/FS/FS/otaker_Mixin.pm b/FS/FS/otaker_Mixin.pm index 4aa47c38d..0da9aeedb 100644 --- a/FS/FS/otaker_Mixin.pm +++ b/FS/FS/otaker_Mixin.pm @@ -40,11 +40,13 @@ sub _upgrade_otaker { my $class = shift; my $table = $class->table; + my $limit = ( $table eq 'cust_attachment' ? 10 : 1000 ); + while ( 1 ) { my @records = qsearch({ 'table' => $table, 'hashref' => {}, - 'extra_sql' => 'WHERE otaker IS NOT NULL LIMIT 1000', + 'extra_sql' => "WHERE otaker IS NOT NULL LIMIT $limit", }); last unless @records;