Bugzilla – Attachment 111510 Details for
Bug 26612
Error during web install for it-IT translation
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
patch for 26612
0001-Bug-26612-Error-during-web-install-for-it-IT-transla.patch (text/plain), 3.93 KB, created by
John Fawcett
on 2020-10-12 11:46:32 UTC
(
hide
)
Description:
patch for 26612
Filename:
MIME Type:
Creator:
John Fawcett
Created:
2020-10-12 11:46:32 UTC
Size:
3.93 KB
patch
obsolete
>From 711cf7270d1e4d47372b5e1f7f743231b205d46e Mon Sep 17 00:00:00 2001 >From: John Fawcett <john@voipsupport.it> >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. >--- > .../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.25.4 >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 26612
:
111257
|
111510
|
111823
|
111832