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

[Philippe Blouin]

it does.  Thanks!

Philippe Blouin,
Directeur de la technologie

Tél.  : (833) 465-4276, poste 230
philippe.blouin at inLibro.com <mailto:philippe.blouin at inLibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
On 2020-11-04 2:28 a.m., Jonathan Druart wrote:
> 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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20201104/a4f85d90/attachment.htm>