System error
error: | DBD::mysql::st execute failed: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'anime.h1.hits' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/DBIx/Abstract.pm line 379. |
||||||||||||||||||||||
context: |
|
||||||||||||||||||||||
code stack: |
/opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/DBIx/Abstract.pm:379 /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/DBIx/Abstract.pm:414 /mnt/rest/home/turner/Dropbox/perl/anime/html/linkbox/most_visited_yesterday:19 /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Request.pm:848 /mnt/rest/home/turner/Dropbox/perl/anime/html/linkbox/most_visited_yesterday:3 /mnt/rest/home/turner/Dropbox/perl/anime/html/linkbox/index.html:21 /mnt/rest/home/turner/Dropbox/perl/anime/html/autohandler:102 |
DBD::mysql::st execute failed: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'anime.h1.hits' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/DBIx/Abstract.pm line 379. Trace begun at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Exceptions.pm line 125 HTML::Mason::Exceptions::rethrow_exception('DBD::mysql::st execute failed: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column \'anime.h1.hits\' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/DBIx/Abstract.pm line 379.^J') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/DBIx/Abstract.pm line 379 DBIx::Abstract::__literal_query('DBIx::Abstract=HASH(0xb29bea0)', 'SELECT series.id,title, ^J h1.hits as label,^J IF( h2.hits IS NULL, \'\', concat(IF( h1.hits >= h2.hits, \'+\',\'\'),h1.hits-h2.hits) ) AS tip,^J IF( h2.hits IS NULL, \'\', IF( h1.hits > h2.hits, \'color: green\', \'color: red\' ) ) AS style^JFROM series ^JINNER JOIN page ON series.id=series_id^JINNER JOIN hits AS h1 ON page.id=h1.page_id AND h1.day=floor(unix_timestamp(NOW())/86400)-1^JLEFT JOIN hits AS h2 ON page.id=h2.page_id AND h2.day=floor(unix_timestamp(NOW())/86400)-2^JWHERE adult=0^JGROUP BY series.id^JORDER BY h1.hits^JDESC LIMIT 0,10;^J') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/DBIx/Abstract.pm line 414 DBIx::Abstract::query('DBIx::Abstract=HASH(0xb29bea0)', 'SELECT series.id,title, ^J h1.hits as label,^J IF( h2.hits IS NULL, \'\', concat(IF( h1.hits >= h2.hits, \'+\',\'\'),h1.hits-h2.hits) ) AS tip,^J IF( h2.hits IS NULL, \'\', IF( h1.hits > h2.hits, \'color: green\', \'color: red\' ) ) AS style^JFROM series ^JINNER JOIN page ON series.id=series_id^JINNER JOIN hits AS h1 ON page.id=h1.page_id AND h1.day=floor(unix_timestamp(NOW())/86400)-1^JLEFT JOIN hits AS h2 ON page.id=h2.page_id AND h2.day=floor(unix_timestamp(NOW())/86400)-2^JWHERE adult=0^JGROUP BY series.id^JORDER BY h1.hits^JDESC LIMIT 0,10;^J') called at /mnt/rest/home/turner/Dropbox/perl/anime/html/linkbox/most_visited_yesterday line 19 HTML::Mason::Commands::__ANON__('vars', 'HASH(0xb28e060)', 'path_info', '', 'tdir', '/themes/default') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb2bc660)', 'vars', 'HASH(0xb28e060)', 'path_info', '', 'tdir', '/themes/default') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Request.pm line 920 eval {...} at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Request.pm line 918 HTML::Mason::Request::call_self('HTML::Mason::Request::CGI=HASH(0xb545370)', 'SCALAR(0x9f91560)', 'ARRAY(0x9f91580)', 'SCALAR(0x9f915a0)', 'CACHE_SELF') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Request.pm line 848 HTML::Mason::Request::cache_self('HTML::Mason::Request::CGI=HASH(0xb545370)', 'expires_in', '1 day') called at /mnt/rest/home/turner/Dropbox/perl/anime/html/linkbox/most_visited_yesterday line 3 HTML::Mason::Commands::__ANON__('vars', 'HASH(0xb28e060)', 'path_info', '', 'tdir', '/themes/default') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb2bc660)', 'vars', 'HASH(0xb28e060)', 'path_info', '', 'tdir', '/themes/default') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Request.pm line 1302 eval {...} at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, 'vars', 'HASH(0xb28e060)', 'path_info', '', 'tdir', '/themes/default') called at /mnt/rest/home/turner/Dropbox/perl/anime/html/linkbox/index.html line 21 HTML::Mason::Commands::__ANON__('vars', 'HASH(0xb28e060)', 'tdir', '/themes/default', 'path_info', '') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb330370)', 'vars', 'HASH(0xb28e060)', 'tdir', '/themes/default', 'path_info', '') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Request.pm line 1302 eval {...} at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef, 'vars', 'HASH(0xb28e060)', 'tdir', '/themes/default', 'path_info', '') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Request.pm line 1355 HTML::Mason::Request::scomp('HTML::Mason::Request::CGI=HASH(0xb545370)', 'HTML::Mason::Component::FileBased=HASH(0xb330370)', 'vars', 'HASH(0xb28e060)', 'tdir', '/themes/default', 'path_info', '') called at /mnt/rest/home/turner/Dropbox/perl/anime/html/autohandler line 102 HTML::Mason::Commands::__ANON__ at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb28e620)') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Request.pm line 1300 eval {...} at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef) called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Request.pm line 481 eval {...} at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Request.pm line 481 eval {...} at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Request.pm line 433 HTML::Mason::Request::exec('HTML::Mason::Request::CGI=HASH(0xb545370)') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/CGIHandler.pm line 179 eval {...} at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/CGIHandler.pm line 179 HTML::Mason::Request::CGI::exec('HTML::Mason::Request::CGI=HASH(0xb545370)') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/Interp.pm line 342 HTML::Mason::Interp::exec(undef, undef) called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/CGIHandler.pm line 110 eval {...} at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTML/Mason/CGIHandler.pm line 110 HTML::Mason::CGIHandler::_handler('HTML::Mason::CGIHandler=HASH(0xb2355e0)', 'HASH(0xb32fb50)') called at /usr/local/bin/mason-http line 219 eval {...} at /usr/local/bin/mason-http line 217 HTTP::MasonServer::handle_request('HTTP::MasonServer=HASH(0xa152b30)', 'CGI=HASH(0xb298750)') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTTP/Server/Simple/CGI.pm line 154 eval {...} at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTTP/Server/Simple/CGI.pm line 154 HTTP::Server::Simple::CGI::handler('HTTP::MasonServer=HASH(0xa152b30)') called at /usr/local/bin/mason-http line 188 HTTP::MasonServer::handler('HTTP::MasonServer=HASH(0xa152b30)') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTTP/Server/Simple.pm line 402 HTTP::Server::Simple::__ANON__('HTTP::MasonServer::NetServer0=HASH(0xb2355a0)', 'Net::Server::Proto::TCP=GLOB(0xb2a2400)') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/Net/Server.pm line 74 Net::Server::run_client_connection('HTTP::MasonServer::NetServer0=HASH(0xb2355a0)') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/Net/Server/PreFork.pm line 229 eval {...} at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/Net/Server/PreFork.pm line 229 Net::Server::PreFork::run_child('HTTP::MasonServer::NetServer0=HASH(0xb2355a0)') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/Net/Server/PreFork.pm line 187 Net::Server::PreFork::run_n_children('HTTP::MasonServer::NetServer0=HASH(0xb2355a0)', 1) called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/Net/Server/PreFork.pm line 382 Net::Server::PreFork::coordinate_children('HTTP::MasonServer::NetServer0=HASH(0xb2355a0)') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/Net/Server/PreFork.pm line 331 Net::Server::PreFork::run_parent('HTTP::MasonServer::NetServer0=HASH(0xb2355a0)') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/Net/Server/PreFork.pm line 113 Net::Server::PreFork::loop('HTTP::MasonServer::NetServer0=HASH(0xb2355a0)') called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/Net/Server.pm line 60 Net::Server::run('HTTP::MasonServer::NetServer0', 'port', 8000) called at /opt/perl5/perls/perl-5.20.1/lib/site_perl/5.20.1/HTTP/Server/Simple.pm line 271 HTTP::Server::Simple::run('HTTP::MasonServer=HASH(0xa152b30)') called at /usr/local/bin/mason-http line 83 HTTP::MasonServer::run('HTTP::MasonServer=HASH(0xa152b30)') called at /usr/local/bin/mason-http line 358