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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
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.
_______________________________________________
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/
