[Koha-bugs] [Bug 17234] New: ALTER IGNORE TABLE is invalid in mysql 5.7. This breaks updatedatabase.pl

[bugzilla-daemon at bugs.koha-community.org]

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 at gmail.com
          Reporter: philippe.blouin at inlibro.com
        QA Contact: testopia at 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.