[Koha-bugs] [Bug 24986] Maximum row size reached soon for borrowers and deletedborrowers

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24986

--- Comment #22 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
Well, my conclusion for now is: I am all for pushing this change to prevent
future problems.
But my test tells me that when you already ran into this problem, you cant
alter table anymore and resolve it like the dbrev does.

I needed to set strict mode off to alter the 140 fields to TEXT. And even then
it was not sufficient. Only when I dropped field 140, it was gone. Perhaps
another limitation? InnoDB should allow 1000 columns, but I already passed some
other limitation: Row size too large. The maximum row size for the used table
type, not counting BLOBs, is 65535.

Not sure, but it might help to combine the separate ALTERs into one statement
instead of looping.
And it might help to temporarily disable strict mode for the alter, but as I
saw in my test, the change might not be enough to recover?

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