[Koha-bugs] [Bug 35610] Missing FK on old_reserves.branchcode?

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35610

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Failed QA                   |Needs Signoff

--- Comment #12 from Jonathan Druart <jonathan.druart at gmail.com> ---
(In reply to Victor Grousset/tuxayo from comment #10)
> As expected, doing an upgrade when there is
> 1. a hold on a library with no data linked (for easy deletion) in sample
> data: Liberty
> 2. cancel the hold
> 3. delete the library
> 4. apply the patch
> 5. run updatedatabase
> 
> fails with:
> 
> DEV atomic update
> /kohadevbox/koha/installer/data/mysql/atomicupdate/bug_35610.pl  [01:44:28]:
> Bug 35610 - Add FK on old_reserves.branchcode
> ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot add or
> update a child row: a foreign key constraint fails
> (`koha_kohadev`.`#sql-alter-1-2f`, CONSTRAINT `old_reserves_ibfk_branchcode`
> FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE
> SET NULL ON UPDATE CASCADE) at /kohadevbox/koha/C4/Installer.pm line 741

Fixed.

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