https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17234 Bug ID: 17234 Summary: ALTER IGNORE TABLE is invalid in mysql 5.7. This breaks updatedatabase.pl Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: gmcharlt@gmail.com Reporter: philippe.blouin@inlibro.com QA Contact: testopia@bugs.koha-community.org Since mysql 5.7, IGNORE is invalid in ALTER statements. This breaks updatedatabase.pl with errors like BD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE suggestions ADD KEY status (STATUS)' at line 1 [for Statement " ALTER IGNORE TABLE suggestions ADD KEY status (STATUS) "] at ./installer/data/mysql/updatedatabase.pl line 10420. DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE suggestions ADD KEY biblionumber (biblionumber)' at line 1 [for Statement " The patch will simply remove the IGNORE statement 11 times in updatedatabase.pl -- You are receiving this mail because: You are watching all bug changes.