Hi Dimitrios, the discussion and patch on this bug might help: *Bug 28267* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267> - Older databases fail to upgrade due to having a row format other than "DYNAMIC Katrin On 02.02.23 15:47, Δημήτρης Δαλαγιώργος wrote:

I upgraded my Debian system from 9 to 11.

When I tried to log in to koha admin I was welcomed by the web installer. Trying to run the web installer I got the following error:

Web installer › Update database We are upgrading from Koha 22.06.00.078 to 22.11.02.000

Updating database structure Update errors :

Upgrade to 22.06.00.079 [14:46:54]: Bug 32030 - Add an ERM module 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 Added new system preference 'ERMModule' 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 Added new permission 'erm' 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

I have no idea what they mean and how to fix them.

Dimitrios Dalagiorgos 3rd High School of Kozani Greece _______________________________________________

Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha