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

答案:3 悬赏:50 手机版

解决时间 2021-02-10 11:37

提问者网友：记得曾经
2021-02-09 18:18

添加新商品点击保存后出现如下提示。目测是倒数第二行的"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 ) )

最佳答案

五星知识达人网友：野味小生
2021-02-09 18:38

g.goods_imgfrom 这里的代码没有分开

全部回答

1楼网友：洎扰庸人
2021-02-09 21:02

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

2楼网友：何以畏孤独
2021-02-09 20:04

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

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息