From a6bb833af0b68f9c76054d3d91459d487852bdb3 Mon Sep 17 00:00:00 2001 From: Mark Tompsett Date: Mon, 19 Sep 2016 14:27:14 -0400 Subject: [PATCH] Bug 17234: Follow up to handle new problems Bug 16276 added two more ALTER IGNORES. This removes them. Signed-off-by: Mark Tompsett Signed-off-by: Kyle M Hall (cherry picked from commit 4ea484677e7049ddb835fcc6d6f24a801f2eb6ba) Signed-off-by: Katrin Fischer --- 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 b3c6417610..b4e9f40778 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -12984,10 +12984,10 @@ if ( CheckVersion($DBversion) ) { $DBversion = "16.06.00.027"; if ( CheckVersion($DBversion) ) { $dbh->do(q{ - ALTER IGNORE TABLE borrowers ADD COLUMN lastseen datetime default NULL AFTER updated_on; + ALTER TABLE borrowers ADD COLUMN lastseen datetime default NULL AFTER updated_on; }); $dbh->do(q{ - ALTER IGNORE TABLE deletedborrowers ADD COLUMN lastseen datetime default NULL AFTER updated_on; + ALTER TABLE deletedborrowers ADD COLUMN lastseen datetime default NULL AFTER updated_on; }); $dbh->do(q{ INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('TrackLastPatronActivity', '0', 'If set, the field borrowers.lastseen will be updated everytime a patron is seen', NULL, 'YesNo'); -- 2.39.5