[Koha-bugs] [Bug 8002] Can't add patron attribute type in newer installation

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8002

Jonathan Druart <jonathan.druart at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|In Discussion               |Needs Signoff

--- Comment #21 from Jonathan Druart <jonathan.druart at biblibre.com> ---
(In reply to comment #18)
> > Yes I have just seen that ! But why mysql breaks a constraint ??
> 
> When category_code is truncated to 1 character, it is no more possible
> to link borrower attribute types to borrower categories which are still
> 10 characters length. And if 2 attributes have been linked to 2
> distinct borrower categories like ENFANT and ETUDIANT, category_code
> will contain E after ALTER TABLE for both attributes, and the link won't
> work anymore.

Hi Frédéric,
Yes, I has understand.
I would said it is strange that MySQL does not keep integrity and raise an
error when we want to reduce data.
Besides
But it is normal MySQL does what we ask him :)

I proposed 2 patchs (same as previous). 1 for master, 1 for 3.8.x
A warning message is displayed on the updatedatabase page.
I hope it is what you wanted.

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