[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

Matthew Ross <mwross at napavineschools.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mwross at napavineschools.org

--- Comment #33 from Matthew Ross <mwross at napavineschools.org> ---
Greetings.

I'm having this issue. I decided to finially update my Koha server, since I had
left it alone for some time now. I was running Debian 9, but I had successfully
updated to Debian 11. Previous version of Koha was 22.05, and now I'm trying to
upgrade to Koha Stable (22.11).

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
---

My limited understanding is that the newer versions of MariaDB (and defaults)
to the DYNAMIC table/row type, which is much more flexible. But my older
install must be using the older type(s).

My SQL knowledge is limited, so I may have to revert to a backup of this server
to get it back and running. Any help would be appreciated.

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