[Koha-bugs] [Bug 19974] Marking an item as 'lost' will not actually modify the current item (cataloguing/additem.pl)

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

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

Nicolas Legrand <nicolas.legrand at bulac.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |nicolas.legrand at bulac.fr

--- Comment #43 from Nicolas Legrand <nicolas.legrand at bulac.fr> ---
It seems to me the atomic dev fails because of the quote operator with "|"
delimiters while having "|" in the delimited strings. Works better with other
delimiters:

diff --git a/installer/data/mysql/atomicupdate/bug_19974.perl
b/installer/data/mysql/atomicupdate/bug_19974.perl
index 15f39e9..deea5de 100644
--- a/installer/data/mysql/atomicupdate/bug_19974.perl
+++ b/installer/data/mysql/atomicupdate/bug_19974.perl
@@ -4,21 +4,21 @@ if( CheckVersion( $DBversion ) ) {
         SELECT value FROM systempreferences WHERE
variable="MarkLostItemsAsReturned"
     |);
     if ( $original_value and $original_value eq '1' ) {
-        $dbh->do(q|
+        $dbh->do(q/
             UPDATE systempreferences
             SET type="multiple",
                 options="batchmod|moredetail|cronjob|additem",
                 value="batchmod|moredetail|cronjob|additem"
             WHERE variable="MarkLostItemsAsReturned"
-        |);
+        /);
     } else {
-        $dbh->do(q|
+        $dbh->do(q/
             UPDATE systempreferences
             SET type="multiple",
                 options="batchmod|moredetail|cronjob|additem",
                 value=""
             WHERE variable="MarkLostItemsAsReturned"
-        |);
+        /);
     }

     SetVersion( $DBversion );

-- 
You are receiving this mail because:
You are watching all bug changes.