Incompatible with sql_mode=only_full_group_by error when searching for problems to assign. #2651
Description
Running ww_version: 2.19 in Docker environment.
Getting an error when searching for problems to assign for homework from problem database.
DBD::mysql::db selectall_arrayref failed: Expression #2 of SELECT list is not in GROUP BY clause and
contains nonaggregated column 'webwork.pgf.morelt_id' which is not functionally dependent on columns in
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at
/opt/webwork/webwork2/lib/WeBWorK/Utils/ListingDB.pm line 339.
334: dbc.DBchapter_id = dbsc.DBchapter_id AND
335: dbsc.DBsection_id = pgf.DBsection_id AND
336: p.path_id = pgf.path_id
337: $extrawhere $kw_where $group_by";
338:
339: $pg_file_ref = $dbh->selectall_arrayref($query, {}, @select_parameters, @keyword_parameters);
340: }
341:
342: return $pg_file_ref->[0][0] if $amcounter;
343:
344: my @results;