转移新服务器数据出错。
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 看下数据库表是否完整 |
楼上高手 |
最近更新
常用插件
- ecshop按分类筛选销售排行
ecshop按分类筛选销售排行...
- ecshop供应商插件免费下载
ecshop供应商插件免费下载...
- ecshop二次开发售后维修卡
插件介绍: 本插件是用于专门从事电子,信息,软件等售后服务关键比...
- ecshop选择下单时间插件
ecshop选择下单时间插件主要是根据不同的下单配送要求,在ecshop购物车...
- ecshop快递发货单打印商品
ecshop快递发货单打印商品信息,大家都知道ecshop快递单打印的时候,只能...
ecshop热门问答
ecshop热门资料
ecshop书签
ecshop特价商品
ecshop供应链
ecshopHacker
ecshop经历
ecshop看官
ecshop折扣率
ecshop淘宝助手
ecshop工资
ecshop英文域名
ecshop提示信息
ecshop失败
ecshop出版社
ecshop商品咨询分类
ecshopGalaxy
ecshop双引号
ecshopNEWS
ecshop重金
ecshop性问题
ecshop商品页的title标题
编译redis
ecshop项目管理
ecshop相关商品
ecshop添加购物车
ecshop物品
ecshop更换
ecshop飘动
ecshop宝马5系
ecshop根源
zencart分类树