提交訂單時, 出現 1054 錯誤

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

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `five1colorcon_shop`.`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 '2530', 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 `five1colorcon_shop`.`ecs_cart` WHERE session_id = '105d3c9fdfd158686cbba13e6bfff58c' AND rec_type = '0' ) [2] => Array ( [error] => Unknown column 'product_id' in 'field list' ) [3] => Array ( [errno] => 1054 ) )

回答:
product_id字段不存在。有问题