From 48d56703b3ed3f08eb2fa5e62930768e95b28db5 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. --- 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 e132a6b..7be9ce2 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -12993,10 +12993,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.7.4