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

(-)a/installer/data/mysql/updatedatabase.pl (-4 / +3 lines)
Lines 19229-19236 if( CheckVersion( $DBversion ) ) { Link Here
19229
        });
19229
        });
19230
    }
19230
    }
19231
19231
19232
    $dbh->do("UPDATE marc_subfield_structure JOIN fieldmapping ON tagfield = fieldcode AND subfieldcode=tagsubfield SET kohafield='biblio.subtitle' WHERE fieldmapping.frameworkcode=''");
19232
#    $dbh->do(q{UPDATE marc_subfield_structure JOIN fieldmapping ON tagfield = fieldcode AND subfieldcode=tagsubfield SET kohafield='biblio.subtitle' WHERE fieldmapping.frameworkcode='' AND field = 'subtitle'});
19233
    $sth = $dbh->prepare("SELECT * FROM fieldmapping WHERE frameworkcode != '' OR field != 'subtitle'");
19233
    $sth = $dbh->prepare("SELECT * FROM fieldmapping"); # WHERE frameworkcode != '' OR field != 'subtitle'");
19234
    $sth->execute;
19234
    $sth->execute;
19235
    my @fails_11529;
19235
    my @fails_11529;
19236
    if ( $sth->rows ) {
19236
    if ( $sth->rows ) {
Lines 19259-19265 if( CheckVersion( $DBversion ) ) { Link Here
19259
    SetVersion( $DBversion );
19259
    SetVersion( $DBversion );
19260
    print "Upgrade to $DBversion done (Bug 11529: Add medium, subtitle and part information to biblio table)\n";
19260
    print "Upgrade to $DBversion done (Bug 11529: Add medium, subtitle and part information to biblio table)\n";
19261
    if ( @fails_11529 ) {
19261
    if ( @fails_11529 ) {
19262
        print "WARNING: Not all Keyword to MARC mappings could be preserved\n";
19262
        print "WARNING: Keyword to MARC Mappings:\n";
19263
        for my $fail_11529 ( @fails_11529 ) {
19263
        for my $fail_11529 ( @fails_11529 ) {
19264
            print "    keyword: "
19264
            print "    keyword: "
19265
              . $fail_11529->{field}
19265
              . $fail_11529->{field}
19266
- 

Return to bug 25707