[Koha-bugs] [Bug 23805] Add a dedicated credit_types table

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Oct 28 10:15:17 CET 2019


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23805

Julian Maurice <julian.maurice at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |julian.maurice at biblibre.com

--- Comment #41 from Julian Maurice <julian.maurice at biblibre.com> ---
I think there's still a problem with the DB update:

DBD::mysql::db do failed: You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right syntax to
use near 'CHECK
            `accountlines_check_type`' at line 1 [for Statement "     
          ALTER TABLE                                                    
            accountlines
          DROP CHECK
            `accountlines_check_type`
        "] at installer/data/mysql/updatedatabase.pl line 20015.

"DROP CHECK" seems to have been added in MySQL 8.0 and is not available in
MariaDB

https://mariadb.com/kb/en/library/alter-table/
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list