Question

ecshop在提交订单时出现数据库错误，怎样解决？

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `mairisa`.`ecs_order_info` (order_sn, user_id, order_status, shipping_status, pay_status, consignee, country, province, city, district, address, zipcode, tel, mobile, email, best_time, sign_building, postscript, shipping_id, shipping_name, pay_id, pay_name, how_oos, card_message, inv_payee, inv_content, goods_amount, shipping_fee, insure_fee, pay_fee, pack_fee, card_fee, surplus, integral, integral_money, bonus, order_amount, from_ad, referer, add_time, pack_id, card_id, bonus_id, extension_code, extension_id, agency_id, inv_type, tax, parent_id, discount) VALUES ('2017021802717', '1', '0', '0', '0', '测试', '1', '2', '52', '500', '测试', '', '21434545', '', '270908900@qq.com', '', '', '', '5', '申通快递', '4', '支付宝', '等待所有商品备齐后再发', '', '', '', '160', '10', '0', '0', '0', '0', '0', '0', '0', '0', '170.00', '0', '本站', '1487372175', '0', '0', '0', '', '0', '0', '', '0', '0', '') ) [2] => Array ( [error] => Duplicate entry '2017021802717' for key 'order_sn' ) [3] => Array ( [errno] => 1062 ) )

Answer 1

我和你一样的问题，解决了吗？