[Koha] Update database from Koha 22.06.00.078 to 22.11.02.000 failed

[Katrin Fischer]

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 at lists.katipo.co.nz
> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha