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

(-)a/C4/Serials.pm (-4 / +4 lines)
Lines 483-489 sub GetSubscriptionsFromBiblionumber { Link Here
483
        $subs->{startdate}     = format_date( $subs->{startdate} );
483
        $subs->{startdate}     = format_date( $subs->{startdate} );
484
        $subs->{histstartdate} = format_date( $subs->{histstartdate} );
484
        $subs->{histstartdate} = format_date( $subs->{histstartdate} );
485
        $subs->{histenddate}   = format_date( $subs->{histenddate} );
485
        $subs->{histenddate}   = format_date( $subs->{histenddate} );
486
        $subs->{opacnote}     =~ s/\n/\<br\/\>/g;
486
        $subs->{opacnote} . q{}     =~ s/\n/\<br\/\>/g;
487
        $subs->{missinglist}  =~ s/\n/\<br\/\>/g;
487
        $subs->{missinglist}  =~ s/\n/\<br\/\>/g;
488
        $subs->{recievedlist} =~ s/\n/\<br\/\>/g;
488
        $subs->{recievedlist} =~ s/\n/\<br\/\>/g;
489
        $subs->{ "periodicity" . $subs->{periodicity} }     = 1;
489
        $subs->{ "periodicity" . $subs->{periodicity} }     = 1;
Lines 1087-1095 sub ModSubscriptionHistory { Link Here
1087
                    WHERE subscriptionid=?
1087
                    WHERE subscriptionid=?
1088
                ";
1088
                ";
1089
    my $sth = $dbh->prepare($query);
1089
    my $sth = $dbh->prepare($query);
1090
    $recievedlist =~ s/^; //;
1090
    $recievedlist   =~ s/^; //;
1091
    $missinglist  =~ s/^; //;
1091
    $missinglist    =~ s/^; //;
1092
    $opacnote     =~ s/^; //;
1092
    $opacnote . q{} =~ s/^; //;
1093
    $sth->execute( $histstartdate, $enddate, $recievedlist, $missinglist, $opacnote, $librariannote, $subscriptionid );
1093
    $sth->execute( $histstartdate, $enddate, $recievedlist, $missinglist, $opacnote, $librariannote, $subscriptionid );
1094
    return $sth->rows;
1094
    return $sth->rows;
1095
}
1095
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 2046-2053 CREATE TABLE `subscriptionhistory` ( Link Here
2046
  `histenddate` date default NULL,
2046
  `histenddate` date default NULL,
2047
  `missinglist` longtext NOT NULL,
2047
  `missinglist` longtext NOT NULL,
2048
  `recievedlist` longtext NOT NULL,
2048
  `recievedlist` longtext NOT NULL,
2049
  `opacnote` varchar(150) NOT NULL default '',
2049
  `opacnote` text NULL,
2050
  `librariannote` varchar(150) NOT NULL default '',
2050
  `librariannote` text NULL,
2051
  PRIMARY KEY  (`subscriptionid`),
2051
  PRIMARY KEY  (`subscriptionid`),
2052
  KEY `biblionumber` (`biblionumber`)
2052
  KEY `biblionumber` (`biblionumber`)
2053
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2053
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 7010-7015 CREATE TABLE IF NOT EXISTS borrower_files ( Link Here
7010
    SetVersion($DBversion);
7010
    SetVersion($DBversion);
7011
}
7011
}
7012
7012
7013
$DBversion = "3.13.00.XXX";
7014
if ( CheckVersion($DBversion) ) {
7015
    $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE opacnote opacnote TEXT NULL});
7016
    $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE librariannote librariannote TEXT NULL});
7017
    print "Upgrade to $DBversion done (Bug 10215 - Increase the size of opacnote and librariannote for table subscriptionhistory)\n";
7018
    SetVersion ($DBversion);
7019
}
7020
7013
=head1 FUNCTIONS
7021
=head1 FUNCTIONS
7014
7022
7015
=head2 TableExists($table)
7023
=head2 TableExists($table)
7016
- 

Return to bug 10215