https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3777 --- Comment #13 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (In reply to Jon Knight from comment #12)

I'm just trawling through old REOPENed cases and I see that the current (17.05) borrower schema still has the inconsistencies in the addresses. As this was reopened because it was proving to be an issue for some addresses longer than 100 characters, is it worth just attacking just those fields to make them all match the address versions?

In other words make these field changes in the borrowers table schema:

B_address mediumtext NOT NULL, B_address2 text, B_city mediumtext NOT NULL,

and

altcontactaddress1 mediumtext NOT NULL, altcontactaddress2 text, altcontactaddress3 mediumtext NOT NULL,

I once tried to start a clean-up, but ended very confused. In your eample I think there is probably no reason that ...address2 should not be mediumtext not null too? One thing I encountered back then was that some types can't be using not null (iirc). -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug.