@@ -, +, @@ --- installer/data/mysql/updatedatabase.pl | 3 +++ 1 file changed, 3 insertions(+) --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -12636,6 +12636,9 @@ SetVersion($DBversion); $DBversion = "3.23.00.063"; if ( CheckVersion($DBversion) ) { $dbh->do(q{ + UPDATE letter SET branchcode='' WHERE branchcode IS NULL; + }); + $dbh->do(q{ ALTER TABLE letter MODIFY COLUMN branchcode varchar(10) NOT NULL DEFAULT '' }); $dbh->do(q{ --