转移新服务器数据出错。

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

转移到新服务器出错：
http://www.hwaus.com/

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number FROM `zhshopcn`.`ecs_goods` AS g, `zhshopcn`.`ecs_order_info` AS o, `zhshopcn`.`ecs_order_goods` AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('12','13','14','15','6','8','9','11','7','1','5','2','16','3','4') OR g.goods_id IN ('8','16','33') ) AND g.goods_number > 0 AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND (o.order_status = '1' OR o.order_status = '5') AND (o.pay_status = '2' OR o.pay_status = '1') AND (o.shipping_status = '1' OR o.shipping_status = '2') GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT 10 ) [2] => Array ( [error] => Can't find file: 'g' (errno: 2) ) [3] => Array ( [errno] => 1017 ) )


数据库是导入过来，程序是完全复制过来。
求解决方法，谢谢！

回答：
zhshopcn数据库是这个的么
用phpmyadmin 看下数据库表是否完整

楼上高手