Bug 33853

Summary: Error upgrading database schema
Product: Koha Reporter: Afrane Daniel <afrane55>
Component: bugs.koha-community.orgAssignee: Bugs List <koha-bugs>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low    
Version: 22.11   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on: 33489    
Bug Blocks:    

Description Afrane Daniel 2023-05-29 13:44:27 UTC
I tried Upgrading to 20.11.05.010 and database schema fails to upgrade with :

Upgrade to 22.11.05.010  [12:59:19]: Bug 33489 - Add indices to default patron search fields
ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT column 'middle_name' used in key specification without a key length at /usr/share/koha/lib/C4/Installer.pm line 743
Comment 1 Katrin Fischer 2023-05-29 13:48:34 UTC
Hi, this has been fixed by new Debian packages a little time ago. Please try to update again.