Bug 22470: Missing the table name on misc/migration_tools/switch_marc21_series_info.pl

This patch adds the table name to the SQL update statements.

To test:

1) Apply the patch
2) Run the script. Check that there are no errors, and that the script
behaves as expected.

Signed-off-by: Andreas Roussos <a.roussos@dataly.gr>
Created a test record with values in field 440. Applied the patch, ran the
script with the -c -f flags and observed that the values were moved to field
490. Also, the relevant Koha to MARC mappings were changed accordingly.

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
(cherry picked from commit 051b0b8d2fb3dc3593147e5ac80bc394dcf48e58)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
(cherry picked from commit 0ee5a38798a170e2e996ee330b3f2101a9ae59be)

Signed-off-by: Aleisha Amohia <aleishaamohia@hotmail.com>

(cherry picked from commit bcf40fe9721eec418bf415334aeec50a67d64914)
Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net>

diff --git a/misc/migration_tools/switch_marc21_series_info.pl b/misc/migration_tools/switch_marc21_series_info.pl
index 0bad3f2..925be0c 100755 (executable)
--- a/misc/migration_tools/switch_marc21_series_info.pl
+++ b/misc/migration_tools/switch_marc21_series_info.pl
@@ -231,22 +231,26 @@ if ( $update_frameworks ) {
 
     # set new mappings for koha fields
     $dbh->do(
-"UPDATE marc_subfield_structure SET kohafield='seriestitle'
+"UPDATE marc_subfield_structure SET kohafield='biblio.seriestitle'
   WHERE tagfield='490' AND tagsubfield='a'"
     );
     $dbh->do(
-"UPDATE marc_subfield_structure SET kohafield='volume'
+"UPDATE marc_subfield_structure SET kohafield='biblioitems.volume'
   WHERE tagfield='490' AND tagsubfield='v'"
     );
 
     # empty old koha fields
     $dbh->do(
 "UPDATE marc_subfield_structure SET kohafield=''
-  WHERE kohafield='seriestitle' AND tagfield='440' AND tagsubfield='a'"
+  WHERE kohafield='biblio.seriestitle' AND tagfield='440' AND tagsubfield='a'"
         );
     $dbh->do(
 "UPDATE marc_subfield_structure SET kohafield=''
-  WHERE kohafield='volume' AND tagfield='440' AND tagsubfield='v'"
+  WHERE kohafield='biblioitems.volume' AND tagfield='440' AND tagsubfield='v'"
+        );
+    $dbh->do(
+"UPDATE marc_subfield_structure SET kohafield=''
+  WHERE kohafield='biblioitems.number' AND tagfield='440' AND tagsubfield='n'"
         );
 }