[Koha-bugs] [Bug 28267] Koha-common package upgrade problem from 20.05.xx to 20.11.04-1

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267

--- Comment #34 from David Cook <dcook at prosentient.com.au> ---
(In reply to Matthew Ross from comment #33)
> I'm receiving the followin error, even after manually changing the
> "borrowers" table to dynamic:
> 
> ---
> Upgrade to 22.06.00.006 [09:37:59]: Bug 21978 - Add middle_name to borrowers
> table
> ERROR: {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 includes storage overhead, check the manual. You have to change
> some columns to TEXT or BLOBs at /usr/share/koha/lib/C4/Installer.pm line 739
> ---

Looking at bug 21978, it looks like you'll need to change the
borrower_modifications and deletedborrowers tables too.

Alternatively, you could follow the steps that Liz Rea outlines at
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267#c20 to update
all tables. That would be a more future-proofed solution.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.