From 4ea484677e7049ddb835fcc6d6f24a801f2eb6ba 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 --- 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 2a139126e0..47b18d8ce1 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