From d04ddb9f96f833f3c0a10b8aca6dce4d5a7ed35e Mon Sep 17 00:00:00 2001 From: Mark Tompsett Date: Tue, 20 Sep 2016 19:29:28 -0400 Subject: [PATCH] Bug 17324: Deal with branchcode NULL issue --- installer/data/mysql/updatedatabase.pl | 3 +++ 1 file changed, 3 insertions(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 6496dc9..3f1be7e 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/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{ -- 2.7.4