From 24d8b089f6781c6d12bdb896fd62d8e66ea074d3 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 6 Feb 2018 13:28:38 -0300 Subject: [PATCH] Bug 20144: [sql_modes] Set value for creator_batches.timestamp Fix for: Incorrect datetime value: 'now()' for column 'timestamp' Signed-off-by: Josef Moravec Signed-off-by: Julian Maurice --- t/db_dependent/Creators/Lib.t | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/t/db_dependent/Creators/Lib.t b/t/db_dependent/Creators/Lib.t index 248c4e76d9..858b886dad 100644 --- a/t/db_dependent/Creators/Lib.t +++ b/t/db_dependent/Creators/Lib.t @@ -238,13 +238,13 @@ $query = ' INSERT INTO creator_batches (batch_id , item_number, borrower_number, timestamp, branch_code, creator) - VALUES (?,?,?,?,?,?)'; + VALUES (?,?,?,NOW(),?,?)'; $insert_sth = $dbh->prepare($query); -$insert_sth->execute( 11, $item_number1, $borrowernumber1, 'now()', $library1->{branchcode}, 'Labels' ); +$insert_sth->execute( 11, $item_number1, $borrowernumber1, $library1->{branchcode}, 'Labels' ); -$insert_sth->execute( 12, $item_number2, $borrowernumber2, 'now()', $library2->{branchcode}, 'Labels' ); +$insert_sth->execute( 12, $item_number2, $borrowernumber2, $library2->{branchcode}, 'Labels' ); -$insert_sth->execute( 12, $item_number3, $borrowernumber3, 'now()', $library3->{branchcode}, 'Labels' ); +$insert_sth->execute( 12, $item_number3, $borrowernumber3, $library3->{branchcode}, 'Labels' ); ########################################################### # Testing Subs -- 2.14.2