Bug 28635

Summary: upgrade from Koha 20.05.06.000 to latest version failing with Row size too large
Product: Koha Reporter: Mesfin <mesfin.teshome>
Component: Installation and upgrade (command-line installer)Assignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: fridolin.somers, mtj
Version: 20.05   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Mesfin 2021-06-28 09:50:19 UTC
{UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126.
This incldues storage overhead, check the manual. You have to change some columns to TEXT or BLOBs [for Statement "
 
                ALTER TABLE `items` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `new_status`
"] at /usr/share/perl5/DBIx/Class/Schema.pm line 1118.
Comment 1 Fridolin Somers 2021-12-18 07:15:59 UTC

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