From 9fbacdd94123159f9d4c5abe08702216a031a0e7 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 5 Aug 2019 11:29:53 -0500 Subject: [PATCH] Bug 23309: Fix insert of new subfields with SQL strict modes DBD::mysql::st execute failed: Incorrect integer value: '' for column 'hidden' at row 1 [for Statement " Test plan: - Turn the config strict_sql_modes ON - Add a new subfield to a field --- admin/marc_subfields_structure.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/admin/marc_subfields_structure.pl b/admin/marc_subfields_structure.pl index 25196491b1..b0ecdcbd6e 100755 --- a/admin/marc_subfields_structure.pl +++ b/admin/marc_subfields_structure.pl @@ -273,7 +273,7 @@ elsif ( $op eq 'add_validate' ) { my $authorised_value = $authorised_values[$i]; my $authtypecode = $authtypecodes[$i]; my $value_builder = $value_builder[$i]; - my $hidden = $hidden[$i]; #input->param("hidden$i"); + my $hidden = $hidden[$i] || 0; my $isurl = $input->param("isurl$i") ? 1 : 0; my $link = $link[$i]; my $defaultvalue = $defaultvalue[$i]; -- 2.11.0