查看订单详情时提示１０５４错误，请管理帮我看一下

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

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT o.*, IF(o.product_id > 0, p.product_number, g.goods_number) AS storage, o.goods_attr, g.suppliers_id, IFNULL(b.brand_name, '') AS brand_name, p.product_sn FROM `272ecshop`.`ecs_order_goods` AS o LEFT JOIN `272ecshop`.`ecs_products` AS p ON p.product_id = o.product_id LEFT JOIN `272ecshop`.`ecs_goods` AS g ON o.goods_id = g.goods_id LEFT JOIN `272ecshop`.`ecs_brand` AS b ON g.brand_id = b.brand_id WHERE o.order_id = '1496' ) [2] => Array ( [error] => Unknown column 'o.goods_attr' in 'field list' ) [3] => Array ( [errno] => 1054 ) )

回答：
高手呢。指点一下。下单也提示出错。

ySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `272ecshop`.`ecs_order_goods`( order_id, goods_id, goods_name, goods_sn, product_id, goods_number, market_price, goods_price, goods_attr, is_real, extension_code, parent_id, is_gift, goods_attr_id) SELECT '1501', goods_id, goods_name, goods_sn, product_id, goods_number, market_price, goods_price, goods_attr, is_real, extension_code, parent_id, is_gift, goods_attr_id FROM `272ecshop`.`ecs_cart` WHERE session_id = 'f3ae0d01fe9eca169f99a8ce2ced04f4' AND rec_type = '0' ) [2] => Array ( [error] => Unknown column 'goods_attr' in 'field list' ) [3] => Array ( [errno] => 1054 ) )

goods_attr存在该字段.肯定是升级造成的