Question

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error )

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `test`.`ecs_goods` (stock_price, goods_name, goods_name_style, goods_sncat_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 ( '43' ,'dv', '+', 'vvvvv', '1', '', '59', '70.8', '0','0', '0', '0', '', '', '', '', '', '', '0', '1', '1', '0', '-1', '0', '0', '0', '1', '1', 0, '', '1305930787', '1305930787', '0', '-1', '0') ) [2] => Array ( [error] => Column count doesn't match value count at row 1 ) [3] => Array ( [errno] => 1136 ) ) 什么意思,那错了,我增加了个商品价格就变成这样的了,ECshop,请高手解答下,谢谢,怎么操作,恢复正常,谢谢!

Answer 1

Column count doesn't match value count at row 1这句话的意思是你所存储的数据与数据库表的字段类塌镇轿型定义不相匹配.
看看你的字段类型是否正确, 是否旅桐越界, 有无团肆把一种类型的数据存储到另一种数据类型中.