@@ -, +, @@ --- C4/Reserves.pm | 2 +- admin/smart-rules.pl | 4 ++-- installer/data/mysql/atomicupdate/bug_18887.perl | 4 ++-- koha-tmpl/intranet-tmpl/prog/en/modules/admin/smart-rules.tt | 2 +- 4 files changed, 6 insertions(+), 6 deletions(-) --- a/C4/Reserves.pm +++ a/C4/Reserves.pm @@ -416,7 +416,7 @@ sub CanItemBeReserved { rule_name => 'max_holds', } ); - if ( $rule ) { + if ( $rule && defined( $rule->rule_value ) && $rule->rule_value ne '' ) { my $total_holds_count = Koha::Holds->search( { borrowernumber => $borrower->{borrowernumber} --- a/admin/smart-rules.pl +++ a/admin/smart-rules.pl @@ -234,7 +234,7 @@ elsif ($op eq "set-branch-defaults") { $holdallowed =~ s/\s//g; $holdallowed = undef if $holdallowed !~ /^\d+/; $max_holds =~ s/\s//g; - $max_holds = undef if $max_holds !~ /^\d+/; + $max_holds = '' if $max_holds !~ /^\d+/; if ($branch eq "*") { my $sth_search = $dbh->prepare("SELECT count(*) AS total @@ -290,7 +290,7 @@ elsif ($op eq "add-branch-cat") { $maxonsiteissueqty =~ s/\s//g; $maxonsiteissueqty = undef if $maxonsiteissueqty !~ /^\d+/; $max_holds =~ s/\s//g; - $max_holds = undef if $max_holds !~ /^\d+/; + $max_holds = '' if $max_holds !~ /^\d+/; if ($branch eq "*") { if ($categorycode eq "*") { --- a/installer/data/mysql/atomicupdate/bug_18887.perl +++ a/installer/data/mysql/atomicupdate/bug_18887.perl @@ -20,12 +20,12 @@ if( CheckVersion( $DBversion ) ) { $dbh->do(q{ INSERT INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value ) - SELECT branchcode, categorycode, NULL, 'max_holds', max_holds FROM branch_borrower_circ_rules + SELECT branchcode, categorycode, NULL, 'max_holds', COALESCE( max_holds, '' ) FROM branch_borrower_circ_rules }); $dbh->do(q{ INSERT INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value ) - SELECT NULL, categorycode, NULL, 'max_holds', max_holds FROM branch_borrower_circ_rules + SELECT NULL, categorycode, NULL, 'max_holds', COALESCE( max_holds, '' ) FROM default_borrower_circ_rules }); $dbh->do(q{ --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/smart-rules.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/smart-rules.tt @@ -501,7 +501,7 @@ [% SET rule_value = CirculationRules.Get( branch_cat_rule_loo.branchcode, branch_cat_rule_loo.categorycode, branch_cat_rule_loo.itemtype, 'max_holds' ) %] - [% IF rule_value %] + [% IF rule_value.defined && rule_value != '' %] [% rule_value %] [% ELSE %] Unlimited --