https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28977 Michael Hafen <michael.hafen@washk12.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |In Discussion --- Comment #3 from Michael Hafen <michael.hafen@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.