http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8002
Jonathan Druart <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|In Discussion |Needs Signoff --- Comment #21 from Jonathan Druart <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
