https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28854
--- Comment #518 from Marcel de Rooy <[email protected]> --- 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 -- 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/
