[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 #18 from David Cook <dcook at prosentient.com.au> ---
(In reply to Mason James from comment #15)
> (In reply to skaman.tx from comment #14)
> > 
> > Any further thoughts?
> 
> hi skaman
> 
> running this SQL before the upgrade might fix the error...
>  ALTER TABLE `items` ROW_FORMAT=DYNAMIC;
> 
> more info... 
>  https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-
> innodb/

Cheers, Mason!

When I ran some SQL from that troubleshooting page, I noticed that all the Koha
tables were using "Compact" row format. 

The database I was using was set up a long time ago, and it did in-place
upgrades that retained the legacy settings it seems.

>From 10.2.x, the default has been Dynamic. 

I think this bug report could probably be closed, although perhaps we could
have an audit script for double-checking some MySQL settings before upgrading I
guess... that's a bit fraught though.

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