后台界面 日志统计进不去,报错

bug问题 · wayenliu · 于 3年前 发布 · 1143 次阅读

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}

共收到 1 条回复
添加回复 (需要登录)
需要 登录 后方可回复, 如果你还没有账号请点击这里 注册
Your Site Analytics