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 '2526', 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 ) )

回答:
cart表中的字段'product_id' 为空

'product_id'报错是不知道这个字段,你好好看看这个'product_id'是否存在问题,sql是否存在问题