Question

ecshop提交订单错误提示MySQL server error report:？

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => update `ecshop_1008`.`ecs_goods` AS a, `ecshop_1008`.`ecs_cart` AS b set a.saleqt= a.saleqt + b.goods_number WHERE a.goods_id=b.goods_id AND b.session_id = 'b94d73e83b331d104cc30e94c9e85cd4' AND b.rec_type = '0' ) [2] => Array ( [error] => Unknown column 'a.saleqt' in 'field list' ) [3] => Array ( [errno] => 1054 ) )

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励30（财富值+成长值）

Answer 1

数据库中'a.saleqt' 这个列不存在.所以造成读取不成功.

追问

请问，怎么修改才OK？