后台添加商品提示这个错误

2016-07-07 15:13 来源:www.chinab4c.com 作者:ecshop专家

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `l039811`.`ecs_goods` (goods_name, goods_name_style, goods_sn, 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, goods_shuxing, add_time, last_update, goods_type, rank_integral, suppliers_id)VALUES ('啊大三的', '+', 'ECS000034', '6', '1', '0', '0', '0','0', '0', '0', '', '', '', '', '', '',', '0', '1', '1', '0', ', '-1', '0', '0', '0', '1', '1', 0, '', '1347668790', '1347668790', '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 '0', '1', '1', '0', ', '-1', '0', '0', '0', '1', '1', 0, '', '1347668790', '1347' at line 1 ) [3] => Array ( [errno] => 1064 ) )
我在属性栏下面添加了一个编辑器! QQ截图20120915163338.png



执行了这个sqlALTER TABLE `ecs_goods` ADD `goods_shuxing` VARCHAR( 32 ) NOT NULL AFTER `goods_desc` ;

编辑商品不会提示错误,就是添加的时候,请高手们帮忙看看啊

回答:
describe下你的goods表

QQ截图20120915224033.png 就是这个样子,高手帮我看看谢谢!!

你这个是字段不对。。肯定是升级没升级好造成的。