[Koha-bugs] [Bug 28854] Add ability to create bundles of items for circulation

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28854

--- Comment #518 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
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.