Bug 16858

Summary: import_borrowers.pl does not load because of mysql 5.7
Product: Koha Reporter: zefanja <npm>
Component: ToolsAssignee: Galen Charlton <gmcharlt>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: major    
Priority: P5 - low CC: jonathan.druart, mtj
Version: Main   
Hardware: All   
OS: Linux   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 17258    

Description zefanja 2016-07-06 09:42:15 UTC
The Import Patrons tool does not load on MySQL 5.7 because of the default sql_mode: only_full_group_by.

This is the error I got: http://paste.koha-community.org/16

Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.22/DBI.pm line 2083

If I change the sql_mode to a mysql 5.6 behavior the import page loads fine.
Comment 1 Jonathan Druart 2018-10-24 16:37:54 UTC
This should have been fixed by bug 21596.

*** This bug has been marked as a duplicate of bug 21596 ***