@@ -, +, @@ --- installer/data/mysql/updatedatabase.pl | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -23388,19 +23388,19 @@ if( CheckVersion( $DBversion ) ) { $DBversion = '20.06.00.069'; if( CheckVersion( $DBversion ) ) { -# my ($count) = $dbh->selectrow_array( -# q| -# SELECT COUNT(*) -# FROM circulation_rules -# WHERE rule_name = 'unseen_renewals_allowed' -# | -# ); -# if ($count == 0) { + my ($count) = $dbh->selectrow_array( + q| + SELECT COUNT(*) + FROM circulation_rules + WHERE rule_name = 'unseen_renewals_allowed' + | + ); + if ($count == 0) { $dbh->do( q| INSERT INTO circulation_rules (rule_name, rule_value) VALUES ('unseen_renewals_allowed', '') | ); -# } + } if( !column_exists( 'issues', 'unseen_renewals' ) ) { $dbh->do( q| ALTER TABLE issues ADD unseen_renewals TINYINT(4) DEFAULT 0 NOT NULL AFTER renewals | ); --