@@ -, +, @@ confusion --- Koha/AuthorisedValue.pm | 6 +++--- Koha/Schema/Result/AuthorisedValueLocalization.pm | 2 +- installer/data/mysql/atomicupdate/bug_20307.perl | 1 + installer/data/mysql/kohastructure.sql | 2 +- koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt | 4 ++-- 5 files changed, 8 insertions(+), 7 deletions(-) --- a/Koha/AuthorisedValue.pm +++ a/Koha/AuthorisedValue.pm @@ -162,7 +162,7 @@ sub opac_translated_description { $lang ||= C4::Languages::getlanguage; my $translated_description = Koha::Localizations->search({ code => $self->authorised_value, - entity => 'avs', + entity => 'authorised_values', lang => $lang, interface => 'opac', })->next; @@ -188,7 +188,7 @@ sub translated_description { $lang ||= C4::Languages::getlanguage; my $translated_description = Koha::Localizations->search({ code => $self->authorised_value, - entity => 'avs', + entity => 'authorised_values', lang => $lang, })->next; return $translated_description @@ -203,7 +203,7 @@ sub translated_description { sub translated_descriptions { my ( $self ) = @_; my @translated_descriptions = Koha::Localizations->search( - { entity => 'avs', + { entity => 'authorised_values', code => $self->authorised_value, } ); --- a/Koha/Schema/Result/AuthorisedValueLocalization.pm +++ a/Koha/Schema/Result/AuthorisedValueLocalization.pm @@ -9,7 +9,7 @@ __PACKAGE__->table_class('DBIx::Class::ResultSource::View'); __PACKAGE__->table('authorised_value_localizations'); __PACKAGE__->result_source_instance->is_virtual(1); __PACKAGE__->result_source_instance->view_definition( - "SELECT localization_id, code, lang, translation FROM localization WHERE entity='avs'" + "SELECT localization_id, code, lang, translation FROM localization WHERE entity='authorised_values'" ); __PACKAGE__->add_columns( --- a/installer/data/mysql/atomicupdate/bug_20307.perl +++ a/installer/data/mysql/atomicupdate/bug_20307.perl @@ -4,6 +4,7 @@ if ( CheckVersion($DBversion) ) { $dbh->do("ALTER TABLE `localization` ADD COLUMN `interface` VARCHAR(30) DEFAULT NULL AFTER `entity`"); $dbh->do("ALTER TABLE `localization` DROP FOREIGN KEY `entity_code_lang`"); $dbh->do("ALTER TABLE `localization` ADD UNIQUE KEY `entity_code_interface_lang` (entity, code, interface, lang)"); + $dbh->do("ALTER TABLE `localization` MODIFY entity VARCHAR(30) NOT NULL"); } SetVersion($DBversion); --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -3653,7 +3653,7 @@ CREATE TABLE `additional_field_values` ( DROP TABLE IF EXISTS localization; CREATE TABLE `localization` ( localization_id int(11) NOT NULL AUTO_INCREMENT, - entity varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL, + entity varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, interface varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, code varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt @@ -77,7 +77,7 @@ [% IF can_be_translated %] [% IF action_modify %] - Translate into other languages + Translate into other languages [% ELSE %] Translate into other languages [% END %] @@ -88,7 +88,7 @@ [% IF can_be_translated %] [% IF action_modify %] - Translate into other languages + Translate into other languages [% ELSE %] Translate into other languages [% END %] --