最新的版本点击我的应用时报"A Database Error Occurred"

0 投票
最新提问 5月 24, 2016 分类:SDK | 用户: joyme (150 分)
最新的版本点击我的应用时报"A Database Error Occurred"

Error Number: 1055

'razor_warehouse.razorwarehouse_dim_product.product_name' isn't in GROUP BY

select ppp.product_id, ppp.product_name, ppp.platform, ifnull(allusers,0) allusers, ifnull(newusers,0) newusers, ifnull(startusers,0) startusers, ifnull(sessions,0) sessions from (select product_id, product_name, platform from razorwarehouse_dim_product group by product_id) ppp left join (select product_id, max(allusers) allusers from razorwarehouse_sum_basic_product bp, razorwarehouse_dim_date dd where dd.datevalue='2016-05-24' and bp.date_sk<=dd.date_sk group by product_id) dpp on dpp.product_id=ppp.product_id left join (select pp.product_id, newusers, startusers,sessions from razorwarehouse_dim_product p, razorwarehouse_sum_basic_product pp, razorwarehouse_dim_date d where d.datevalue='2016-05-24' and d.date_sk=pp.date_sk and product_active=1 and channel_active=1 and version_active=1 and p.product_id=pp.product_id group by pp.product_id) ff on ff.product_id=ppp.product_id group by ppp.product_id

Filename: /opt/code/razor.joyme.alpha/models/product/productmodel.php

Line Number: 717

1个回答

0 投票
最新回答 8月 9, 2016 用户: qhaizhang (2,720 分)
修改于 9月 21, 2016 用户:qhaizhang
mysql 数 据 版 本 的 问 题,修改配置文件属性
...