Question

ECShop后台商品列表无法添加新商品，提示MySQL server error。

添加新商品点击保存后出现如下提示。目测是倒数第二行的"min_buynu"应该改为min_buynum。请问一下我应该去哪个文件里面修改？

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO INSERT INTO `yhd`.`ecs_goods` (goods_name, goods_name_style, goods_sn, min_buynum, cat_id, brand_id, shop_price, market_price, is_promote, promote_price, promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, seller_note, goods_weight, goods_number, warn_number, integral, give_integral, is_best, is_new, is_hot, is_on_sale, is_alone_sale, is_shipping, goods_desc, add_time, last_update, goods_type, rank_integral, suppliers_id)VALUES ('1', '+', 'XDJ001977', '', '691', '157', '0', '0', '0','0', '0', '0', '', '', '', '', '', '', '0', '100', '1', '0', '-1', '0', '0', '0', '1', '1', 0, '', '1441820937', '1441820937', '0', '-1', '0') ) [2] => Array ( [error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `yhd`.`ecs_goods` (goods_name, goods_name_style, goods_sn, min_buynu' at line 1 ) [3] => Array ( [errno] => 1064 ) )

Answer 1

是数据库出错，ecs_goods表

Answer 2

多了一次 INSERT INTO，查看一下sql拼接处的代码

Answer 3

看看有没有把INSERT INTO上面if里面的内容注释了，或者没有内容