Bugzilla – Attachment 90203 Details for
Bug 22919
Authorities MARC Structure not inserted with SQL strict modes
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 22919: Fix insert of authorities_normal_marc21.sql with strict SQL modes
Bug-22919-Fix-insert-of-authoritiesnormalmarc21sql.patch (text/plain), 2.59 KB, created by
Jonathan Druart
on 2019-05-30 14:39:41 UTC
(
hide
)
Description:
Bug 22919: Fix insert of authorities_normal_marc21.sql with strict SQL modes
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2019-05-30 14:39:41 UTC
Size:
2.59 KB
patch
obsolete
>From 5b47cf5b97f147d86a29efe7bfbc9d6f231ff4a3 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Thu, 30 May 2019 09:36:31 -0500 >Subject: [PATCH] Bug 22919: Fix insert of authorities_normal_marc21.sql with > strict SQL modes > >If strict SQL modes are set, the insert of authorities_normal_marc21.sql >will fail. > >Test plan: >DELETE FROM auth_subfield_structure; >DELETE FROM auth_tag_structure; >DELETE FROM auth_types; >SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; >source /home/vagrant/kohaclone/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql > >You should not see any errors. >Without this patch you see: >ERROR 1366 (22007) at line 280 in file: >'/home/vagrant/kohaclone/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql': >Incorrect integer value: ' for column 'linkid' at row 148 >' >--- > .../mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql >index 79d00186eb..f605303a78 100644 >--- a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql >+++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql >@@ -425,7 +425,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` > ('', '055', 'd', 'Volumes/dates to which call number applies', 'Volumes/dates to which call number applies', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), > ('', '055', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), > ('', '055', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), >- ('', '055', '2', 'Number source', 'Number source', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), >+ ('', '055', '2', 'Number source', 'Number source', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), > ('', '055', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), > ('', '055', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), > ('', '055', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), >-- >2.11.0
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 22919
:
89813
|
90203
|
90346
|
90351