ECShop后台商品列表无法添加新商品,提示MySQL server error。
添加新商品点击保存后出现如下提示。目测是倒数第二行的"min_buynu"应该改为min_buynum。请问一下我应该去哪个文件里面修改?MySQLservererror...
添加新商品点击保存后出现如下提示。目测是倒数第二行的"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 ) ) 展开
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 ) ) 展开
3个回答
展开全部
是数据库出错,ecs_goods表
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
多了一次 INSERT INTO,查看一下sql拼接处的代码
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
看看有没有把INSERT INTO上面if里面的内容注释了,或者没有内容
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询