网站出大问题了.. 求助！！ MySQL错误

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

在后台点击广告列表就出现下面的错误提示，看不明白 ....

请给个解决方法..

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT COUNT(*) FROM `youmaila`.`shop_ad` AS ad WHERE 1 ) [2] => Array ( [error] => Table 'youmaila.shop_ad' doesn't exist ) [3] => Array ( [errno] => 1146 ) )


---------------------------

访问前台商品链接也出现下面的错误信息

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT a.ad_id, a.position_id, a.media_type, a.ad_link, a.ad_code, a.ad_name, p.ad_width, p.ad_height, p.position_style, RAND() AS rnd FROM `youmaila`.`shop_ad` AS a LEFT JOIN `youmaila`.`shop_ad_position` AS p ON a.position_id = p.position_id WHERE enabled = 1 AND a.position_id = '2' AND start_time <= '1263280777' AND end_time >= '1263280777' ORDER BY rnd LIMIT 1 ) [2] => Array ( [error] => Table 'youmaila.shop_ad' doesn't exist ) [3] => Array ( [errno] => 1146 ) )

回答：
广告表 ..字段出现问题

提示表不存在
你可以看
http://bbs.ecshop.com/thread-95341-1-1.html
6