From 6e5072103101a94fe0e4b9ab4cf7e72da4bbfe0d Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Mon, 25 Aug 2014 13:24:03 +0200 Subject: [PATCH] Bug 7817: QA Follow-up: Print a warning when permanent location is mapped Content-Type: text/plain; charset=utf-8 Item field permanent location should not be mapped to the MARC structure. If a library did so, this dbrev will print a warning. If refers to report 12818 for help in moving the data to more_subfields_xml. Signed-off-by: Marcel de Rooy Tested by putting permanent_location in and out of the MARC structure. --- installer/data/mysql/updatedatabase.pl | 15 +++++++++++++++ 1 files changed, 15 insertions(+), 0 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index de77bf3..0a2e2aa 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8613,6 +8613,21 @@ if ( CheckVersion($DBversion) ) { SetVersion($DBversion); } + +$DBversion = '3.17.00.XXX'; +if ( CheckVersion($DBversion) ) { + my @temp= $dbh->selectrow_array(qq| + SELECT count(*) + FROM marc_subfield_structure + WHERE kohafield='permanent_location' OR kohafield='items.permanent_location' + |); + print "Upgrade to $DBversion done (Bug 7817: Check for permanent_location)\n"; + if( $temp[0] ) { + print "WARNING for Koha administrator: Your database contains one or more mappings for permanent_location to the MARC structure. This item field however is for internal use and should not be linked to a MARC (sub)field. Please correct it. See also Bugzilla reports 7817 and 12818.\n"; + } + SetVersion($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) -- 1.7.7.6