小白教程刚安装的2.3.7,什么都没动。
后台点击日志统计 报数据库错误
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 < '2019-11-21' and created_at >= '2019-10-20' group by account ) as t '
in F:\fecmall\fecshop\vendor\yiisoft\yii2\db\Schema.php:674
Stack trace:
#0 F:\fecmall\fecshop\vendor\yiisoft\yii2\db\Command.php(1295): yii\db\Schema->convertException(Object(PDOException), 'select count(*)...')
#1 F:\fecmall\fecshop\vendor\yiisoft\yii2\db\Command.php(1158): yii\db\Command->internalExecute('select count(*)...')
#2 F:\fecmall\fecshop\vendor\yiisoft\yii2\db\Command.php(413): yii\db\Command->queryInternal('fetch', NULL)
#3 F:\fecmall\fecshop\vendor\fancyecommerce\fecshop\app\appadmin\modules\Fecadmin\block\logtj\Index.php(168): yii\db\Command->queryOne()
#4 F:\fecmall\fecshop\vendor\fancyecommerce\fecshop\app\appadmin\modules\Fecadmin\block\logtj\Index.php(45): fecshop\app\appadmin\modules\Fecadmin\block\logtj\Index->getTableTbody()
#5 F:\fecmall\fecshop\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 F:\fecmall\fecshop\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array)
#8 F:\fecmall\fecshop\vendor\yiisoft\yii2\base\Controller.php(157): yii\base\InlineAction->runWithParams(Array)
#9 F:\fecmall\fecshop\vendor\yiisoft\yii2\base\Module.php(528): yii\base\Controller->runAction('index', Array)
#10 F:\fecmall\fecshop\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('fecadmin/logtj/...', Array)
#11 F:\fecmall\fecshop\vendor\yiisoft\yii2\base\Application.php(386): yii\web\Application->handleRequest(Object(yii\web\Request))
#12 F:\fecmall\fecshop\appadmin\web\index.php(50): yii\base\Application->run()
#13 {main}