[Koha-devel] Fail to migrate issuingrules from 19.05 to 20.05

Jonathan Druart jonathan.druart at bugs.koha-community.org
Wed Nov 4 08:28:25 CET 2020


See bug 26911
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26911
Please confirm it works for you.

Le mar. 3 nov. 2020 à 21:48, Philippe Blouin
<philippe.blouin at inlibro.com> a écrit :
>
> Hello all,
>
> Simple question: am I interpreting right that '*' itemtypes in issuingrules fail to migrate to circulation_rules because of the constraint?
>
> DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha_vingt`.`circulation_rules `, CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE) [for Statement "
>                 INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
>                 SELECT IF(categorycode='*', NULL, categorycode), IF(branchcode='*', NULL, branchcode), IF(itemtype='*', NULL, itemtype) , 'finedays', COALESCE( finedays, '' )
>                 FROM issuingrules
>             "] at ./installer/data/mysql/updatedatabase.pl line 20712.
>
> Migrating that DB can be long, so rather than re-test extensively, I figured I'd raise my hand and ask the community what I'm getting wrong.  Migration goes from 19.05.04 to 20.05.04.
>
> Thanks in advance,
>
> --
> Philippe Blouin,
> Directeur de la technologie
>
> Tél.  : (833) 465-4276, poste 230
> philippe.blouin at inLibro.com
>
> inLibro | pour esprit libre | www.inLibro.com
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/


More information about the Koha-devel mailing list