Http status: 500 Internal Server Error
ajaxOptions: error
thrownError: Internal Server Error
Exception (Database Exception) 'yii\db\Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fecshop.admin_visit_log.person' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
The SQL being executed was: select count(*) as count from (select account,person,menu ,count(*) as click_count
from `admin_visit_log` where created_at < '2018-04-02' and created_at >= '2018-03-01' group by account ) as t '
in /usr/local/var/www/fecshop/vendor/yiisoft/yii2/db/Schema.php:664
Stack trace:
#0 /usr/local/var/www/fecshop/vendor/yiisoft/yii2/db/Command.php(1263): yii\db\Schema->convertException(Object(PDOException), 'select count(*)...')
#1 /usr/local/var/www/fecshop/vendor/yiisoft/yii2/db/Command.php(1148): yii\db\Command->internalExecute('select count(*)...')
#2 /usr/local/var/www/fecshop/vendor/yiisoft/yii2/db/Command.php(413): yii\db\Command->queryInternal('fetch', NULL)
#3 /usr/local/var/www/fecshop/vendor/fancyecommerce/fec_admin/block/logtj/Index.php(234): yii\db\Command->queryOne()
#4 /usr/local/var/www/fecshop/vendor/fancyecommerce/fec_admin/block/logtj/Index.php(65): fecadmin\block\logtj\Index->getTableTbody()
#5 /usr/local/var/www/fecshop/vendor/fancyecommerce/fec_admin/controllers/LogtjController.php(23): fecadmin\block\logtj\Index->getLastData()
#6 [internal function]: fecadmin\controllers\LogtjController->actionIndex()
#7 /usr/local/var/www/fecshop/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#8 /usr/local/var/www/fecshop/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
#9 /usr/local/var/www/fecshop/vendor/yiisoft/yii2/base/Module.php(528): yii\base\Controller->runAction('index', Array)
#10 /usr/local/var/www/fecshop/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction('fecadmin/logtj/...', Array)
#11 /usr/local/var/www/fecshop/vendor/yiisoft/yii2/base/Application.php(386): yii\web\Application->handleRequest(Object(yii\web\Request))
#12 /usr/local/var/www/fecshop/appadmin/web/index.php(76): yii\base\Application->run()
#13 {main}