From d1e0eda8fadfa1971f273308d8b754d944a76741 Mon Sep 17 00:00:00 2001
From: Paul POULAIN
Date: Tue, 9 Oct 2007 16:46:46 -0500
Subject: [PATCH] IMPORTANT : biblioitems.editionresponsibility field was
sometimes spelled with a 'a'
editionserponsability.
This commit fixes all editionresponsAbibility. However, that won't change the biblioitems
column name if you have a wrong one in your DB (if you install a new one, or try a migration from 2.2, that should be OK)
Signed-off-by: Chris Cormack
Signed-off-by: Joshua Ferraro
---
installer/data/fr/1-Obligatoire/framework_DEFAULT.sql | 2 +-
installer/kohastructure.sql | 2 +-
koha-tmpl/opac-tmpl/prog/en/opac-detail.tmpl | 2 +-
updater/update22to30.pl | 2 +-
4 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/installer/data/fr/1-Obligatoire/framework_DEFAULT.sql b/installer/data/fr/1-Obligatoire/framework_DEFAULT.sql
index cfeb5ab6bd..f1b21f591b 100644
--- a/installer/data/fr/1-Obligatoire/framework_DEFAULT.sql
+++ b/installer/data/fr/1-Obligatoire/framework_DEFAULT.sql
@@ -1346,7 +1346,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 ('225', 'a', 'titre de la collection', '', 0, 0, 'biblioitems.collectiontitle', 1, '', '', 'unimarc_field_225a.pl', 0, 0, '', NULL, '225a', '');
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 ('225', 'd', 'titre parallêle de la collection', '', 0, 0, '', -1, '', '', '', 0, 0, '', 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 ('225', 'e', 'compléments de titre de la collection', '', 0, 0, '', 1, '', '', '', 0, 0, '', 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 ('225', 'f', 'mention de responsabilité', '', 0, 0, 'biblioitems.editionresponsability', -1, '', '', '', 0, 0, '', 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 ('225', 'f', 'mention de responsabilité', '', 0, 0, 'biblioitems.editionresponsibility', -1, '', '', '', 0, 0, '', 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 ('225', 'h', 'numéro sous-coll.', '', 0, 0, '', 1, '', '', '', 0, 0, '', 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 ('225', 'i', 'titre de la sous-collection', '', 0, 0, '', 1, '', '', '', 0, 0, '', 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 ('225', 'v', 'numéro du volume', '', 0, 0, 'biblioitems.collectionvolume', 1, '', '', '', 0, 0, '', NULL, '', '');
diff --git a/installer/kohastructure.sql b/installer/kohastructure.sql
index c07a0651a3..271afdf27e 100644
--- a/installer/kohastructure.sql
+++ b/installer/kohastructure.sql
@@ -675,7 +675,7 @@ CREATE TABLE `deletedbiblioitems` (
`collectionissn` mediumtext,
`collectionvolume` mediumtext,
`editionstatement` text,
- `editionresponsability` text,
+ `editionresponsibility` text,
PRIMARY KEY (`biblioitemnumber`),
KEY `bibinoidx` (`biblioitemnumber`),
KEY `bibnoidx` (`biblionumber`)
diff --git a/koha-tmpl/opac-tmpl/prog/en/opac-detail.tmpl b/koha-tmpl/opac-tmpl/prog/en/opac-detail.tmpl
index 3d9e2b5894..bea2e84b16 100644
--- a/koha-tmpl/opac-tmpl/prog/en/opac-detail.tmpl
+++ b/koha-tmpl/opac-tmpl/prog/en/opac-detail.tmpl
@@ -77,7 +77,7 @@
- /
+ /
diff --git a/updater/update22to30.pl b/updater/update22to30.pl
index 55b65e3cd7..93bb495430 100755
--- a/updater/update22to30.pl
+++ b/updater/update22to30.pl
@@ -840,7 +840,7 @@ my $DBversion = "3.00.00.000";
extra => '',
},
{
- field => 'editionresponsability',
+ field => 'editionresponsibility',
type => 'text',
null => 'null',
default => '',
--
2.20.1