https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16573
--- Comment #26 from M. Tompsett <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
