Lines 52-58
if( CheckVersion( $DBversion ) ) {
Link Here
|
52 |
}); |
52 |
}); |
53 |
} |
53 |
} |
54 |
|
54 |
|
55 |
$dbh->do( "DROP TABLE IF EXISTS fieldmapping" ); |
55 |
$dbh->do("UPDATE marc_subfield_structure JOIN fieldmapping ON tagfield = fieldcode AND subfieldcode=tagsubfield SET kohafield='biblio.subtitle' WHERE fieldmapping.frameworkcode=''"); |
|
|
56 |
$sth = $dbh->prepare("SELECT * FROM fieldmapping WHERE frameworkcode != '' OR field != 'subtitle'"); |
57 |
$sth->execute; |
58 |
print "Keyword to MARC mappings below cannot be preserved: \n" if $sth->rows; |
59 |
while ( my $value = $sth->fetchrow_hashref() ){ |
60 |
my $framework = $value->{frameworkcode} eq "" ? "Default" : $value->{frameworkcode}; |
61 |
print " keyword: " . $value->{'field'} . " to field: " . $value->{fieldcode} . "\$" . $value->{subfieldcode} . " for $framework framework\n"; |
62 |
} |
63 |
print "You will need to remap using Koha to MARC mappings in administration\n" if $sth->rows; |
64 |
|
65 |
|
66 |
# $dbh->do( "DROP TABLE IF EXISTS fieldmapping" ); |
56 |
|
67 |
|
57 |
$dbh->do( "DELETE FROM user_permissions WHERE code='manage_keywords2koha_mappings'" ); |
68 |
$dbh->do( "DELETE FROM user_permissions WHERE code='manage_keywords2koha_mappings'" ); |
58 |
|
69 |
|
59 |
- |
|
|