From f1eb918616666fe23f9d13aa5c0fea72a6d890d1 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 10 May 2019 12:27:40 -0500 Subject: [PATCH] Bug 22878: Do not pass layout_id on creating a layout Attempting to create a patron card layout with mysql strict mode on gives the following error: DBD::mysql::st execute failed: Incorrect integer value: '' for column 'layout_id' at row 1 Test plan: - Turn on sql_strict_modes - Create a new patron card => Must success with this patch applied Signed-off-by: Liz Rea Signed-off-by: Katrin Fischer Signed-off-by: Nick Clemens (cherry picked from commit 8d53fae9494b50c0cf2dcc98b18982b0d8fc416f) Signed-off-by: Martin Renvoize --- C4/Creators/Layout.pm | 1 + 1 file changed, 1 insertion(+) diff --git a/C4/Creators/Layout.pm b/C4/Creators/Layout.pm index f1dc20edd4..2a689e0352 100644 --- a/C4/Creators/Layout.pm +++ b/C4/Creators/Layout.pm @@ -165,6 +165,7 @@ sub save { } else { # otherwise create a new record my @params; + delete $self->{layout_id}; # Could be an empty string my $query = "INSERT INTO creator_layouts ("; foreach my $key (keys %{$self}) { push (@params, $self->{$key}); -- 2.39.5