https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23022
Bug ID: 23022
Summary: Koha is not compatible with MySQL >= 8.0.11 because of
NO_AUTO_CREATE_USER mode
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Database
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
Target Milestone: ---
The NO_AUTO_CREATE_USER mode was removed in MySQL 8.0.11 - see
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html
But Koha attempts to set this mode here:
https://github.com/Koha-Community/Koha/blob/3a150b5d7519c2969de6d966193af242e1e787e0/Koha/Database.pm#L79-L82
This results in the following exception when using MySQL 8.0.11 or higher:
DBD::mysql::db do failed: Variable 'sql_mode' can't be set to the value of
'NO_AUTO_CREATE_USER' [for Statement "SET sql_mode =
'IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'"]
at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1440.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
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/
