后台发布不了新闻

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

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `test`.`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, goods_desc, add_time, last_update, goods_type, rank_integral)VALUES ('123', '+', '120', '12', '8', '12', '14.39', '0','0', '0', '0', '', '', '', '', '', '', '0', '1', '1', '0', '-1', '0', '0', '0', '1', '1', '', '1009902497', '1009902497', '0', '-1') ) [2] => Array ( [error] => Unknown column 'rank_integral' in 'field list' ) [3] => Array ( [errno] => 1054 ) )
各位大侠帮帮忙，为什么我的ECSHOP后台一添加商品就出现上面的错误提示呢？商品添加不了，很急，怎么解决呢

回答：
提示表 ecs_goods缺少rank_integral该字段
表中添加该字段试下

哇， 好严重的问题呀

谢谢，可以了！我用两个不同级别的ECSHOP后台公用一个数据库测试，结果就出现了上面的问题了