联系官方销售客服

1835022288

028-61286886

POSCMS 版主:POSCMS负责人
后台,微信公众号,点击“图文素材”   数据库报错
类型:POSCMS 更新时间:2017-10-18 19:57:41 微信 微信公众号

后台,微信公众号- 点击“图文素材” 数据库报错,之前是好的,我“一键下载图文”后,就这样了


数据库错误

Error Number: 1055

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'newpage_database.djz_1_weixin_material_news.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT *, count(id) as count FROM `djz_1_weixin_material_news` GROUP BY `group_id` ORDER BY `inputtime` DESC LIMIT 8

Filename: /home/wwwroot/newpage.cc/diy/branch/fqb/D_Admin_Table.php

Line Number: 133


回帖
  • 迅睿粉丝
    #1楼    迅睿粉丝
    2017-10-18 19:06:06
    0
    与sql_mode = only_full_group_by不兼容mysql的ini配置里面 不要only_full_group_by这一句
    满意答案
  • 迅睿粉丝
    #2楼    迅睿粉丝
    2017-10-18 19:57:41
    0
    感谢大家给我解决此问题,我已经完美的解决