mysql数据库导出，搬家还原数据出错，求解

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

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT user_id, user_name, password, last_login, action_list, last_login, suppliers_id FROM `sjw`.`taste_admin_user` WHERE user_name = 'admin' AND password = '0192023a7bbd73250516f069df18b500' ) [2] => Array ( [error] => Unknown column 'suppliers_id' in 'field list' ) [3] => Array ( [errno] => 1054 ) )

这是后台登陆出错提示

Notice: unserialize() [function.unserialize]: Error at offset 27 of 13126 bytes in E:\APMServ5.2.6\www\htdocs\includes\lib_common.php on line 236
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT g.goods_id, g.goods_name, g.have_sold, g.goods_thumb,g.promote_price,promote_start_date,promote_end_date, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price FROM `sjw`.`taste_goods` AS g LEFT JOIN `sjw`.`taste_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('80','1','2','3','5','4','21','22','10','73','12','11','13','23','24','25','6','7','79','8','9','26','27','28','15','35','36','37','38','39','40','14','29','30','31','32','33','34','16','41','42','43','44','45','46','17','47','48','49','50','51','83','52','18','86','87','53','54','55','56','57','58','20','65','66','67','68','69','70','71','72','19','59','60','61','62','63','64','85','84','74','77','75','89') OR g.goods_id IN ('') ) ORDER BY g.have_sold DESC, g.goods_id DESC LIMIT 10 ) [2] => Array ( [error] => Unknown column 'g.have_sold' in 'field list' ) [3] => Array ( [errno] => 1054 ) )

这是首页登陆出错提示。。

回答：
很明显是缺少了字段表中suppliers_id
本人刚建了一个ecshop的qq群，欢迎大家进来讨论，互相学习交流，遇到问题可以帮忙给解决。
群号:95250464