From 3f32f54d6b4704f0617b19ac7013dd7c2021a219 Mon Sep 17 00:00:00 2001 From: John Fawcett Date: Mon, 12 Oct 2020 13:06:40 +0200 Subject: [PATCH] Bug 26612: Error during web install for it-IT translation Patch changes some of the values in the sql statement that inserts 307a unimarc row into the marc_subfield_structure which created an SQL error on installation. The fields changed are: - isurl now 0 instead of NULL, - hidden now -5 instead of NULL, - seealso empty string instead of NULL, - link empty string instead of NULL. These field values are now similar to the ones inserted for 306a or 308a. The value that caused the SQL error was using NULL for hidden (due to the NOT NULL constraint in the table definition). I have tested the install with this change and found no issues. Signed-off-by: Katrin Fischer Signed-off-by: Julian Maurice --- .../it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql b/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql index b3876be482..07890ac3da 100644 --- a/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql +++ b/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql @@ -466,7 +466,7 @@ insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('304','a','Testo di nota','',0,0,'',3,'','','',0,-5,'','','',NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('305','a','Testo di nota','',0,0,'',3,'','','',0,-5,'','','',NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('306','a','Testo di nota','',0,0,'',3,'','','',0,-5,'','','',NULL); -insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('307','a','Testo di nota','',0,0,'',3,'','','',NULL,NULL,'',NULL,NULL,NULL); +insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('307','a','Testo di nota','',0,0,'',3,'','','',0,-5,'','','',NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('308','a','Testo di nota','',0,0,'',3,'','','',0,-5,'','','',NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('310','a','Testo di nota','',0,0,'',3,'','','',0,-5,'','','',NULL); insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('311','a','Testo di nota','',0,0,'',3,'','','',0,-5,'','','',NULL); -- 2.20.1