MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT SUM(money_paid) AS sales FROM `shneyu`.`ecs_order_info` WHERE `add_time` BETWEEN 1493308800 AND 1493395199 AND supplier_id=0 AND order_status IN ('1','5','6') ) [2] => Array ( [error] => Unknown column 'supplier_id' in 'where clause' ) [3] => Array ( [errno] => 1054 ) )
请问登录ecshop后台首页报错是什么原因?
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
2条回答 默认 最新
- threenewbee 2017-04-28 11:31关注
Unknown column 'supplier_id' in 'where clause'
where子句中的列名supplier_id未知,你有这一列么解决 无用评论 打赏 举报