https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28854
--- Comment #519 from Jonathan Druart <[email protected]> --- (In reply to Marcel de Rooy from comment #518) > Martin, should the dbrev be changed as follows: > > diff --git a/installer/data/mysql/db_revs/220600015.pl > b/installer/data/mysql/db_revs/220600015.pl > index 89dc2d628b..11298b6860 100755 > --- a/installer/data/mysql/db_revs/220600015.pl > +++ b/installer/data/mysql/db_revs/220600015.pl > @@ -26,7 +26,7 @@ return { > $lost_val++; > > $dbh->do(qq{ > - INSERT INTO authorised_values (category,authorised_value,lib) > VALUES ('LOST',$lost_val,'Missing from bundle') > + INSERT IGNORE INTO authorised_values > (category,authorised_value,lib) VALUES ('LOST',$lost_val,'Missing from > bundle') > }); > say $out "Missing from bundle LOST AV added"; > > @@ -34,7 +34,7 @@ return { > $nfl_val++; > > $dbh->do(qq{ > - INSERT INTO authorised_values (category,authorised_value,lib) > VALUES ('NOT_LOAN',$nfl_val,'Added to bundle') > + INSERT IGNORE INTO authorised_values > (category,authorised_value,lib) VALUES ('NOT_LOAN',$nfl_val,'Added to > bundle') > }); > say $out "Added to bundle NOT_LOAN AV added"; > > > The dbrev crashes on a FK constraint when run twice in the context of bug > 34683 Note that's not the problem. We should not add the AV if one exists for "Missing from bundle", the IGNORE won't work here, and we will keep add one other "Missing from bundle". -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://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/
