Bug 34548

Summary:	Upgrade failed on conversion of publishercode from varchar to text on biblioitems and deletedbiblioitems due to existing indexes
Product:	Koha	Reporter:	mjnkml
Component:	Database	Assignee:	Bugs List <koha-bugs>
Status:	RESOLVED DUPLICATE	QA Contact:	Testopia <testopia>
Severity:	major
Priority:	P5 - low	CC:	costalc, dcook, m.de.rooy
Version:	23.05
Hardware:	All
OS:	All
Change sponsored?:	---	Patch complexity:	---
Documentation contact:		Documentation submission:
Text to go in the release notes:		Version(s) released in:
Circulation function:
Bug Depends on:	34029
Bug Blocks:

Description mjnkml 2023-08-17 00:55:17 UTC

Changes in:
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/db_revs/230501003.pl

to convert publishercode to text on both tables resulted in an upgrade error.

Manually deleted the indexes from the tables allowed the [Try again] to proceed without incident.

Comment 1 mjnkml 2023-08-17 00:56:46 UTC

The error was something like:

"column 'publishercode' used in key specification without a key length"

Sorry I don't have the full output.

Comment 2 mjnkml 2023-08-17 00:57:29 UTC

Actions I took:

DROP INDEX `publishercode` ON `koha_instance`.`biblioitems`

DROP INDEX `publishercode` ON `koha_instance`.`deletedbiblioitems`

Comment 3 Katrin Fischer 2023-08-24 09:06:22 UTC


*** This bug has been marked as a duplicate of bug 34516 ***