From a5f7be1ff6e9cd591b99c8e27e5983b3015f9c2e 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..7ec7d34 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=NULL; + }); + $dbh->do(q{ ALTER TABLE letter MODIFY COLUMN branchcode varchar(10) NOT NULL DEFAULT '' }); $dbh->do(q{ -- 2.7.4