From 7b27ff2fdeafa0acfb34257dbe4080bacacb4147 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 5 Feb 2018 15:36:27 -0300 Subject: [PATCH] Bug 20144: [sql_modes] Set default value for aqbasket.is_standing Fix for: Column 'is_standing' cannot be null t/db_dependent/Koha/Acquisition/Booksellers.t Signed-off-by: Josef Moravec Signed-off-by: Julian Maurice Signed-off-by: Jonathan Druart --- C4/Acquisition.pm | 2 ++ 1 file changed, 2 insertions(+) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index 15a51dd81b..d7f0e25e56 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -607,6 +607,8 @@ case the AcqCreateItem syspref takes precedence). sub ModBasketHeader { my ($basketno, $basketname, $note, $booksellernote, $contractnumber, $booksellerid, $deliveryplace, $billingplace, $is_standing, $create_items) = @_; + + $is_standing ||= 0; my $query = qq{ UPDATE aqbasket SET basketname=?, note=?, booksellernote=?, booksellerid=?, deliveryplace=?, billingplace=?, is_standing=?, create_items=? -- 2.39.5