From 1cf113943daff6bfcd27a37f8dee6ae906400ef3 Mon Sep 17 00:00:00 2001 From: Andrew Isherwood Date: Thu, 12 Nov 2020 13:45:50 +0000 Subject: [PATCH] Bug 24083: (QA follow-up) Fix for previous It helps if you don't commit commented out code... --- installer/data/mysql/updatedatabase.pl | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 3bbfc677d2..2cd4b47fb3 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/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 | ); -- 2.20.1