[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 #519 from Jonathan Druart <jonathan.druart+koha at 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.