https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19974 Nicolas Legrand <nicolas.legrand@bulac.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nicolas.legrand@bulac.fr --- Comment #43 from Nicolas Legrand <nicolas.legrand@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.