刚安装完毕,访问appadmin后台的“控制面板->日志统计”报以下错误,是哪里没有配置好呢

安装报错 · nsy960 · 于 6年前 发布 · 2550 次阅读

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}
共收到 10 条回复 问题提问
nsy960#16年前 0 个赞

2楼 已删除.
3楼 已删除.
Fecmall#46年前 0 个赞

一个问题一贴,先分开,先把帖子整理好,否则视为废弃贴!

看截图,你的统计日志的页面都出来了,你的报错是发生在那个步骤出现的? 日志统计,我在后台查看,没有报错, 那个sql报错,你自己尝试解决下,

其他的部分,请另开帖子,至于为什么这样做,参看:http://www.fecshop.com/topic/624

nsy960#56年前 0 个赞

报错发生的步骤就是点击日志统计时弹出的错误提示框 从错误提示上看是发生在in /usr/local/var/www/fecshop/vendor/yiisoft/yii2/db/Schema.php:664

Fecmall#66年前 0 个赞

关于sql报错:Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre

http://www.fecshop.com/topic/803

nsy960#76年前 0 个赞

OK了,谢谢!

Fecmall#86年前 0 个赞

@nsy960 #7楼 如果按照上面的资料解决了,说下自己的解决方式,回馈下。

nsy960#96年前 1 个赞

解决方式参考下面的链接 http://www.ywnds.com/?p=8184

cqslxz#105年前 0 个赞

这是MySQL5.6与5.7之间的一个问题,我是去掉ONLY_FULL_GROUP_BY,在配置文件中把sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";就行了

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