突然间提交不了订单,一点提交订单按钮就报错,出现乱码。

2016-07-07 14:55 来源:www.chinab4c.com 作者:ecshop专家


MySQL server error report:Array( [0] => Array([message] => MySQL Query Error) [1] => Array([sql] => SELECT g.goods_name, goods_sn,g.goods_number, c.product_id FROM `hdm0290144_db`.`hefeng_goods` AS g, `hdm0290144_db`.`hefeng_cart` AS c WHERE g.goods_id = c.goods_id AND c.rec_id = '59954') [2] => Array([error] => Column 'goods_sn' in field list is ambiguous) [3] => Array([errno] => 1052))

回答:
mysql错误消息,楼主更改mysql语句了吗?

你这升级后。连字段都不对。

SELECT g.goods_name, goods_sn

修改成:
SELECT g.goods_name, g.goods_sn