[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

Kyle M Hall <kyle at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |kyle at bywatersolutions.com

--- Comment #8 from Kyle M Hall <kyle at bywatersolutions.com> ---
> After re-injecting an old clean dump and replaying the updatedatabase.pl
> errors are gone, so it was probably   because of other columns coming from
> patches not yet in master.
> Maybe we should start moving some columns to other tables. An obvious
> candidate is all the address fields that can be moved in a patron_addresses
> table.

Another option would be to move some columns into a JSON column. MariaDB 10.2.7
and MySQL 5.7 both have JSON data types and functions to use JSON values in a
query.

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