上传空间后出问题，麻烦高手指教一下

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

上传空间后输入网址，提示：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.nt_shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number FROM `Zsir0598`.`ecs_goods` AS g, `Zsir0598`.`ecs_order_info` AS o, `Zsir0598`.`ecs_order_goods` AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND g.goods_number > 0 AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND o.order_status = '1' 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] => Unknown column 'g.nt_shop_price' in 'field list' ) [3] => Array ( [errno] => 1054 ) )
麻烦高手帮忙指教一下哪里出问题了，在下感激不尽。

回答：
提示goods 表中的nt_shop_price字段不存在
你在表中添加太字段试下

是啊。数据库字段不匹配

已解決，謝謝各位！！！

一般下载数据库备份时最好可以先把网站关闭使用。这样数据就不会出现丢失不完全的现象了。
如果搬家的话，其实可以请空间商直接把你数据库完整复制到目的空间服务器上的。