[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

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

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

--- Comment #12 from David Nind <david at davidnind.com> ---
Currently getting this error when running Patrons with the most checkouts
report (using KTD started with ku and on master) - is the this the same issue
or something else?

CGI::Compile::ROOT::kohadevbox_koha_reports_bor_issues_top_2epl::calculate():
DBI Exception: DBD::mysql::st execute failed: 'koha_kohadev.borrowers.surname'
isn't in GROUP BY at /kohadevbox/koha/reports/bor_issues_top.pl line 63
 at /usr/share/perl5/DBIx/Class/Exception.pm line 77

    in DBIx::Class::Exception::throw at
/usr/share/perl5/DBIx/Class/Exception.pm line 77

       74:     my $self = { msg => $msg };
       75:     bless $self => $class;
       76: 
       77:     die $self;
       78: }
       79: 
       80: =head2 rethrow

    Show function arguments
    in DBIx::Class::Schema::throw_exception at
/usr/share/perl5/DBIx/Class/Schema.pm line 1118

     1115:     };
     1116:   }
     1117: 
     1118:   DBIx::Class::Exception->throw($args[0], $self->stacktrace);
     1119: }
     1120: 
     1121: =head2 deploy

    Show function arguments
    in DBIx::Class::Storage::throw_exception at
/usr/share/perl5/DBIx/Class/Storage.pm line 113

      110:   my $self = shift;
      111: 
      112:   if (ref $self and $self->schema) {
      113:     $self->schema->throw_exception(@_);
      114:   }
      115:   else {
      116:     DBIx::Class::Exception->throw(@_);

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