https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16573 --- Comment #26 from M. Tompsett <mtompset@hotmail.com> --- Comment on attachment 54658 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=54658 Bug 16573: (RM followup) Update DBIx schema and prevent upgrade issues Review of attachment 54658: --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=16573&attachment=54658) ----------------------------------------------------------------- ::: installer/data/mysql/updatedatabase.pl @@ +12789,4 @@
$DBversion = '16.06.00.012'; if ( CheckVersion($DBversion) ) { $dbh->do(q{ + ALTER IGNORE TABLE virtualshelves MODIFY COLUMN created_on DATETIME not NULL;
"As of MySQL 5.7.4, the IGNORE clause for ALTER TABLE is removed and its use produces an error." (https://dev.mysql.com/doc/refman/5.7/en/alter-table.html) I'd leave out the ignore. -- You are receiving this mail because: You are watching all bug changes.