Update database from Koha 22.06.00.078 to 22.11.02.000 failed
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
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
Thanks Katrin, Unfortunately I don't understand if I have to create new files, or append the code I see to existing ones. The instructions are obviously intended for developers and I'm not sure who to contact for more details. Dimitrios Dalagiorgos 3rd High School of Kozani Greece
participants (2)
-
Katrin Fischer -
Δημήτρης Δαλαγιώργος