From 77ea4dda126640326871be999dc14a4b9771c547 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 --- 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 4f8c374..3778caa 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -12983,10 +12983,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