https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17234 --- Comment #8 from M. Tompsett <mtompset@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.