https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28854 --- Comment #519 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- (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.