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 'fecmall.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 < '2020-07-06' and created_at >= '2020-06-05' group by account ) as t '
in /var/www/fecmall/vendor/yiisoft/yii2/db/Schema.php:674
Stack trace:
#0 /var/www/fecmall/vendor/yiisoft/yii2/db/Command.php(1298): yii\db\Schema->convertException(Object(PDOException), 'select count()...')
#1 /var/www/fecmall/vendor/yiisoft/yii2/db/Command.php(1159): yii\db\Command->internalExecute('select count()...')
#2 /var/www/fecmall/vendor/yiisoft/yii2/db/Command.php(415): yii\db\Command->queryInternal('fetch', NULL)
#3 /var/www/fecmall/vendor/fancyecommerce/fecshop/app/appadmin/modules/Fecadmin/block/logtj/Index.php(168): yii\db\Command->queryOne()
#4 /var/www/fecmall/vendor/fancyecommerce/fecshop/app/appadmin/modules/Fecadmin/block/logtj/Index.php(45): fecshop\app\appadmin\modules\Fecadmin\block\logtj\Index->getTableTbody()
#5 /var/www/fecmall/vendor/fancyecommerce/fecshop/app/appadmin/modules/Fecadmin/controllers/LogtjController.php(25): fecshop\app\appadmin\modules\Fecadmin\block\logtj\Index->getLastData()
#6 [internal function]: fecshop\app\appadmin\modules\Fecadmin\controllers\LogtjController->actionIndex()
#7 /var/www/fecmall/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#8 /var/www/fecmall/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
#9 /var/www/fecmall/vendor/yiisoft/yii2/base/Module.php(528): yii\base\Controller->runAction('index', Array)
#10 /var/www/fecmall/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction('fecadmin/logtj/...', Array)
#11 /var/www/fecmall/vendor/yiisoft/yii2/base/Application.php(386): yii\web\Application->handleRequest(Object(yii\web\Request))
#12 /var/www/fecmall/appadmin/web/index.php(50): yii\base\Application->run()
#13 {main}