求助:后台订单查看详情出现MySQL server error report:Array ( [0]

2016-07-07 15:32 来源:www.chinab4c.com 作者:ecshop专家

点订单进去后点详细就出现这个,请问怎么修改
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT o.*, g.goods_number AS storage, o.goods_attr, g.suppliers_id, IFNULL(b.brand_name, '') AS brand_name FROM `ouei`.`ecs_order_goods` AS o LEFT JOIN `ouei`.`ecs_goods` AS g ON o.goods_id = g.goods_id LEFT JOIN `ouei`.`ecs_brand` AS b ON g.brand_id = b.brand_id WHERE o.order_id = '6' ) [2] => Array ( [error] => Unknown column 'g.suppliers_id' in 'field list' ) [3] => Array ( [errno] => 1054 ) )

回答:
http://bbs.ecshop.com/thread-95341-1-1.html
70