求助!!ecshop整合discuz!x2问题

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

求助!!ecshop整合discuz!x2问题
整合之后,商品页面无法打开,报以下错误
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT gg.parent_id, ggg.goods_name AS parent_name, gg.goods_id, gg.goods_price, g.goods_name, g.goods_thumb, g.goods_img, g.shop_price AS org_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price FROM `xfnetwork`.`ecs_group_goods` AS gg LEFT JOIN `xfnetwork`.`ecs_goods`AS g ON g.goods_id = gg.goods_id LEFT JOIN `xfnetwork`.`ecs_member_price` AS mp ON mp.goods_id = gg.goods_id AND mp.user_rank = '0' LEFT JOIN `xfnetwork`.`ecs_goods` AS ggg ON ggg.goods_id = gg.parent_id WHERE gg.parent_id IN ('1957') AND g.is_delete = 0 AND g.is_on_sale = 1 ORDER BY gg.parent_id, gg.goods_id ) [2] => Array ( [error] => Table 'xfnetwork.ecs_group_goods' doesn't exist ) [3] => Array ( [errno] => 1146 ) )

求高手帮忙解决

回答:
ecs_group_goods 这个表不存在。你看是否少了什么数据库文件