[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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |michael.hafen at washk12.org

--- Comment #13 from Michael Hafen <michael.hafen at washk12.org> ---
That is something else. The first line of the test plan states that there are
other problems with the script, this is the other problem.  In SQL Strict mode
the query failed the ONLY_FULL_GROUP_BY check.

I recently ran into that problem (and created a patch) on another report.

(In reply to David Nind from comment #12)
> 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.