[Koha-bugs] [Bug 28967] Patrons with no checkouts report shows patrons from other libraries with IndependentBranches

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

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

--- Comment #6 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
"CGI::Compile::ROOT::kohadevbox_koha_reports_borrowers_out_2epl::calculate():
> > DBI Exception: DBD::mysql::st execute failed:
> > 'koha_axelle.borrowers.surname' isn't in GROUP BY at
> > /kohadevbox/koha/reports/borrowers_out.pl line 60
> >  at /usr/share/perl5/DBIx/Class/Exception.pm line 77"

The isn't in GROUP BY usually is an issue if you are using Koha with the strict
SQL settings. Development installations and therefore sandboxes default to
strict, to help catch the issues from being introduced in the first place and
to make us fix them. 

Someone testing locally here might need to change their koha-conf.xml:

<strict_sql_modes>1</strict_sql_modes>

See: Bug 17258 - [OMNIBUS] MySQL 5.7

The compatibility problem with the report should best be reported separately.

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