From 1a8de78c20ef05d7b11c5d97724643bc98c4354e Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 8 Nov 2019 08:06:10 +0000 Subject: [PATCH] Bug 23049: (RM follow-up) remove 'IGNORE' from ALTER TABLE We have updated the update to use our column_exists method, but had forgotten to remove the corresponding IGNORE keyword from the SQL itself. Signed-off-by: Martin Renvoize --- installer/data/mysql/updatedatabase.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 0e0a6ed2e5..232e180275 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -19887,7 +19887,7 @@ if ( CheckVersion($DBversion) ) { unless ( column_exists('accountlines', 'debit_type_code') ) { $dbh->do( qq{ - ALTER IGNORE TABLE accountlines + ALTER TABLE accountlines ADD debit_type_code varchar(80) DEFAULT NULL AFTER @@ -19991,7 +19991,7 @@ if ( CheckVersion($DBversion) ) { unless ( column_exists('accountlines', 'credit_type_code') ) { $dbh->do( qq{ - ALTER IGNORE TABLE accountlines + ALTER TABLE accountlines ADD credit_type_code varchar(80) DEFAULT NULL AFTER -- 2.39.5