@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_10215.perl | 3 +++ 1 file changed, 3 insertions(+) --- a/installer/data/mysql/atomicupdate/bug_10215.perl +++ a/installer/data/mysql/atomicupdate/bug_10215.perl @@ -4,6 +4,9 @@ if ( CheckVersion($DBversion) ) { $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE opacnote opacnote LONGTEXT NULL}); $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE librariannote librariannote LONGTEXT NULL}); + $dbh->do(q{UPDATE subscriptionhistory SET opacnote = NULL WHERE opacnote = ''}); + $dbh->do(q{UPDATE subscriptionhistory SET librariannote = NULL WHERE librariannote = ''}); + SetVersion ($DBversion); print "Upgrade to $DBversion done (Bug 10215 - Increase the size of opacnote and librariannote for table subscriptionhistory)\n"; } --