https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17234
--- Comment #8 from M. Tompsett <mtomp...@hotmail.com> --- (In reply to Jonathan Druart from comment #7) > Could someone explain me why I don't get the same error: > > mysql> set sql_mode="STRICT_TRANS_TABLES"; > Query OK, 0 rows affected (0.00 sec) > > mysql> ALTER IGNORE TABLE suggestions ADD KEY biblionumber (biblionumber); > ERROR 1061 (42000): Duplicate key name 'biblionumber' > > And so I don't understand the IGNORE keyword :) > > Server version: 5.6.30-1 (Debian) # And not 5.7 "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. This affects Ubuntu 16.04 LTS currently, and will affect Debian in the future. This is a pre-emptive patch. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/