From a2802caa3549625ae7f4cf85177a739116839ca1 Mon Sep 17 00:00:00 2001 From: Koha instance kohadev-koha Date: Mon, 4 Sep 2017 20:36:38 +0000 Subject: [PATCH] Bug 13766 - Follow-up - use index_exists() Changes check for existing index to use index_exists. Also checks deletedbiblioitems for an existing ean index and drops it if one is found. --- installer/data/mysql/atomicupdate/bug_13766_fix_ean.perl | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_13766_fix_ean.perl b/installer/data/mysql/atomicupdate/bug_13766_fix_ean.perl index bfd7dd1..21d1fc1 100644 --- a/installer/data/mysql/atomicupdate/bug_13766_fix_ean.perl +++ b/installer/data/mysql/atomicupdate/bug_13766_fix_ean.perl @@ -1,11 +1,12 @@ $DBversion = "XXX"; if(CheckVersion($DBversion)) { # Drop index that might exist because of bug 5337 - my $temp = $dbh->selectall_arrayref(q{ - SHOW INDEXES FROM biblioitems WHERE key_name = 'ean' }); - if( @$temp > 0 ) { + if( index_exists('biblioitems', 'ean')) { $dbh->do(q{ ALTER TABLE biblioitems DROP INDEX ean }); } + if( index_exists('deletedbiblioitems', 'ean')) { + $dbh->do(q{ ALTER TABLE deletedbiblioitems DROP INDEX ean }); + } # Change data type of column $dbh->do(q{ ALTER TABLE biblioitems MODIFY COLUMN ean MEDIUMTEXT default NULL }); -- 2.1.4