System error

error:  DBD::mysql::db selectall_arrayref failed: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'portraits.t2.tree_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /www/pp.bushong.net/htdocs/m/getFolder line 37.
context: 
... 
33: 
34:  my $where = $showAll ? '' : ' AND t1.img_cnt > 0';
35: 
36:  ## get the contents
37:  $dirs = $dbh->selectall_arrayref(qq{
38:  SELECT t1.tree_id tid, t1.hits, string name, t1.img_cnt,
39:  t2.tree_id leaf
40:  FROM tree t1 INNER JOIN
41:  strings ON t1.dir_id = id LEFT JOIN
... 
code stack:  /www/pp.bushong.net/htdocs/m/getFolder:37
/www/pp.bushong.net/htdocs/gallery/items.html:50
/www/pp.bushong.net/htdocs/autohandler:4
raw error






























DBD::mysql::db selectall_arrayref failed: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'portraits.t2.tree_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /www/pp.bushong.net/htdocs/m/getFolder line 37.


Trace begun at /usr/share/perl5/HTML/Mason/Exceptions.pm line 125
HTML::Mason::Exceptions::rethrow_exception('DBD::mysql::db selectall_arrayref failed: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column \'portraits.t2.tree_id\' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /www/pp.bushong.net/htdocs/m/getFolder line 37.^J') called at /www/pp.bushong.net/htdocs/m/getFolder line 37
HTML::Mason::Commands::__ANON__(20) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x557f790917b8)', 20) called at /usr/share/perl5/HTML/Mason/Request.pm line 1300
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, 20) called at /www/pp.bushong.net/htdocs/gallery/items.html line 50
HTML::Mason::Commands::__ANON__('tid', 20) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x557f7907cb90)', 'tid', 20) called at /usr/share/perl5/HTML/Mason/Request.pm line 1302
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'tid', 20) called at /usr/share/perl5/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x557f79080f18)') called at /www/pp.bushong.net/htdocs/autohandler line 4
HTML::Mason::Commands::__ANON__('tid', 20) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x557f79082158)', 'tid', 20) called at /usr/share/perl5/HTML/Mason/Request.pm line 1300
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'tid', 20) called at /usr/share/perl5/HTML/Mason/Request.pm line 481
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 481
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x557f79080f18)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 165
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x557f79080f18)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 831
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x557f79079718)', 'Apache2::RequestRec=SCALAR(0x557f79080648)') called at /etc/apache2/HTML/Mason/Bushong.pm line 99
HTML::Mason::Bushong::handler('Apache2::RequestRec=SCALAR(0x557f79080648)') called at -e line 0
eval {...} at -e line 0