From 073ebc0001f2ea145a2034af2ecf080410cc3ed3 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 27 Apr 2009 07:29:05 -0500 Subject: [PATCH] bug 2559: fix search limit on Spanish language (DB rev 029) Fixes bug where searching with the language limit set to Spanish would instead retrieve Russian records. Signed-off-by: Galen Charlton --- installer/data/mysql/updatedatabase.pl | 11 +++++++++++ kohaversion.pl | 2 +- 2 files changed, 12 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index ae9af90c7d..c0af961d36 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -2378,6 +2378,17 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = '3.01.00.029'; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do(q( UPDATE language_rfc4646_to_iso639 + SET iso639_2_code = 'spa' + WHERE rfc4646_subtag = 'es' + AND iso639_2_code = 'rus' ) + ); + print "Upgrade to $DBversion done (fixed bug 2599: using Spanish search limit retrieves Russian results)\n"; + SetVersion ($DBversion); +} + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table diff --git a/kohaversion.pl b/kohaversion.pl index a5c7fd5a98..5e89ad341a 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -10,7 +10,7 @@ use strict; sub kohaversion { - our $VERSION = '3.01.00.028'; + our $VERSION = '3.01.00.029'; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.5