[Koha-bugs] [Bug 28977] Most-circulated items (cat_issues_top.pl) is failing with SQL Mode ONLY_FULL_GROUP_BY

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

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

Michael Hafen <michael.hafen at washk12.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |In Discussion

--- Comment #3 from Michael Hafen <michael.hafen at washk12.org> ---
(In reply to David Nind from comment #2)
> I had a go at testing with koha-testing-docker (KTD), but was unable to get
> this to work.
> 
> - KTD = started with ku
> - Strict mode already set in /etc/koha/sites/kohadev/koha-conf.xml
> 
> Error before patch applied, no change after (with a flush_memcached and
> restart_all):
> 
> CGI::Compile::ROOT::kohadevbox_koha_reports_cat_issues_top_2epl::calculate():
> DBI Exception: DBD::mysql::st execute failed: 'koha_kohadev.biblio.title'
> isn't in GROUP BY at /kohadevbox/koha/reports/cat_issues_top.pl line 64
>  at /usr/share/perl5/DBIx/Class/Exception.pm line 77
> 
> I think I will leave the testing to someone who understands how this all
> works a bit better than I do!

What options did you use to generate that error?  I'm not able to reproduce it.

I didn't test this report thoroughly, so I'm sure there is more work to be done
here.  Now that I'm playing with it a bit more the "distinct" is causing
trouble too with Mysql 8.

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