Bug 34548 - Upgrade failed on conversion of publishercode from varchar to text on biblioitems and deletedbiblioitems due to existing indexes
Summary: Upgrade failed on conversion of publishercode from varchar to text on biblioi...
Status: RESOLVED DUPLICATE of bug 34516
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: 23.05
Hardware: All All
: P5 - low major
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on: 34029
Blocks:
  Show dependency tree / graph
 
Reported: 2023-08-17 00:55 UTC by mjnkml
Modified: 2023-08-24 09:06 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 ***