From 20b3bf4bb9eccf0f68f5b5d57ef3a59b58fa846e Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 5 Feb 2018 15:46:51 -0300 Subject: [PATCH] Bug 20144: [sql_modes] Set missinglist and recievedlist in subscriptionhistory Fix for: Field 'missinglist' doesn't have a default value t/db_dependent/Koha/Acquisition/Booksellers.t from mysql doc: BLOB, TEXT, GEOMETRY, and JSON columns cannot be assigned a default value. Signed-off-by: Josef Moravec Signed-off-by: Julian Maurice --- C4/Serials.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/C4/Serials.pm b/C4/Serials.pm index 45bae8c7ab..0d10b25191 100644 --- a/C4/Serials.pm +++ b/C4/Serials.pm @@ -1453,8 +1453,8 @@ sub NewSubscription { # then create the 1st expected number $query = qq( INSERT INTO subscriptionhistory - (biblionumber, subscriptionid, histstartdate) - VALUES (?,?,?) + (biblionumber, subscriptionid, histstartdate, missinglist, recievedlist) + VALUES (?,?,?, '', '') ); $sth = $dbh->prepare($query); $sth->execute( $biblionumber, $subscriptionid, $startdate); -- 2.14.2