From 0fee84690ebf2998a43a956abca275f1c90025fa Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Wed, 12 Oct 2016 15:29:01 +0200 Subject: [PATCH] Bug 8835: Drop issn_idx for completeness When dbrev 3.15.00.049 failed, the still existing issn_idx must have been the cause. This patch only adjusts the old db rev. Still thinking if we also need a new db rev to fix isbn and issn for those installs where 3.15.00.049 failed too. (In that case the fields may not have been changed to mediumtext and no indexes were added.) Test plan: Ideally, run an upgrade from something older than 3.15.00.49. But running the added sql command from the command line might convince you too. Signed-off-by: Nicolas Legrand Signed-off-by: Jonathan Druart --- installer/data/mysql/updatedatabase.pl | 1 + 1 file changed, 1 insertion(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 5aa770b8b2..fbb9a51193 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8476,6 +8476,7 @@ $DBversion = "3.15.00.049"; if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { $dbh->do("ALTER TABLE biblioitems DROP INDEX isbn"); $dbh->do("ALTER TABLE biblioitems DROP INDEX issn"); + $dbh->do("ALTER TABLE biblioitems DROP INDEX issn_idx"); $dbh->do("ALTER TABLE biblioitems CHANGE isbn isbn MEDIUMTEXT NULL DEFAULT NULL, CHANGE issn issn MEDIUMTEXT NULL DEFAULT NULL -- 2.39.2