后台添加商品提示这个错误
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 ) ) 我在属性栏下面添加了一个编辑器! 执行了这个sqlALTER TABLE `ecs_goods` ADD `goods_shuxing` VARCHAR( 32 ) NOT NULL AFTER `goods_desc` ; 编辑商品不会提示错误,就是添加的时候,请高手们帮忙看看啊 |
回答:
describe下你的goods表 |
就是这个样子,高手帮我看看谢谢!! |
你这个是字段不对。。肯定是升级没升级好造成的。 |
最近更新
常用插件
- ecshop注册推荐送现金插件
ecshop中的促销售功能还不是很完善,随着电子商务系统的发展和进步,...
- ecshop会员中心订单excel倒出
ecshop会员中心订单excel倒出...
- ecshop二次商品订购人信息
ecshop二次商品订购人信息填写插件,有时候给朋友送花,或者是送礼品的...
- ecshop2.7.2退换货申请插件
ecshop2.7.2退换货申请插件,主要是在 ecshop 现在的基础上,对ecshop的订单处...
- ecshop二次开发商品购买备
ecshop销售统计 插件介绍:ecshop二次开发订单销售统计和商品购买备注服...
ecshop热门问答
ecshop热门资料
ecshop公布
ecshop防火墙
ecshopios
ecshop河南
model实例
ecshop短信功能
ecshop部落格
ecshop2列
ecshop小结
ecshop出新
ecshop美库模板
ecmall筛选
ecshop黄钻
ecshop淘宝采集
isbusy
ecshop放大
ecshop英文文章
ecshop搜索添加“品牌名”
ecshop原来
ecshop行列
ecshop推荐代码
ecshop连结
ecshoppackage
ecshop合唱
ecshop升级问题
ecshop商品汇总
ecshop仿造
ecshopconversion
ecshop梅西百货
ecshop使用率