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