[Koha-bugs] [Bug 33671] Database update 22.06.00.048 breaks update process
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue May 9 10:24:23 CEST 2023
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33671
Jonathan Druart <jonathan.druart+koha at gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #150629|0 |1
is obsolete| |
Attachment #150630|0 |1
is obsolete| |
--- Comment #8 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
Created attachment 150824
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=150824&action=edit
Bug 33671: Fix for 30472 - Remove null-guarantors
These guarantors cannot be added. They are of no use.
NOTE FOR QA/RM: I do not think that it is needed to add a new
db rev for this change since it happens seldom. But if you think
that it is, just copy it to atomicupdate/change bugno.
Test plan:
[1] Check your table definition and modify it:
alter table borrower_relationships modify column `guarantor_id` int(11)
NULL;
[2] Add an empty guarantor:
insert into borrower_relationships (guarantee_id,relationship) values
(SOME_PATRON_ID,'father');
[3] Run the dbrev and verify that the inserted record has been removed.
[4] Check table definition with 'show create table borrower_relationships'.
You should see NOT NULL with guarantor_id.
Signed-off-by: Marcel de Rooy <m.de.rooy at rijksmuseum.nl>
Signed-off-by: Jonathan Druart <jonathan.druart at bugs.koha-community.org>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list