View | Details | Raw Unified | Return to bug 11529
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_11529.perl (-2 / +12 lines)
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
- 

Return to bug 11529