[Koha-bugs] [Bug 17860] MARC records will stage, but Manage for import shows ' no data in table'

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

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

--- Comment #6 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
(In reply to niko from comment #5)
> found it:
> /etc/mysql/conf.d/mariadb.cnf
> restarted the mysq-server.
> 
> now it works.
> 
> the documentation here implies that this problem is not present with MariaDB.
> This seems to be wrong!?

Indeed, https://mariadb.com/kb/en/library/sql-mode/:
"""
Since MariaDB 10.2.4, SQL_MODE is by default set to
NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO.
In earlier versions of MariaDB 10.2, and since MariaDB 10.1.7, SQL_MODE is by
default set to NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER. For earlier versions
of MariaDB 10.1, and MariaDB 10.0 and before, no default is set.
"""

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