急求:网站打不开,提示MySQL server error report:Array

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

网站突然出现下面提示,打不开了,请大家一定指点我,谢谢
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT g.goods_id, g.is_best, g.is_new, g.is_hot, g.is_promote, b.brand_name,g.sort_order FROM `shop123`.`ecs_goods` AS g LEFT JOIN `shop123`.`ecs_brand` AS b ON b.brand_id = g.brand_id WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.is_best = 1 OR g.is_new =1 OR g.is_hot = 1) ORDER BY g.sort_order, g.last_update DESC ) [2] => Array ( [error] => Table 'g' is marked as crashed and should be repaired ) [3] => Array ( [errno] => 1194 ) )

回答:
数据库错误

Table 'g' is marked as crashed and should be repaired
g 这个表损坏

挺复杂的

ecs_goods这个表坏了,跟空间商索要MYSQL管理地址,或者自己通过FTP上传一个phpmyadmin ,

进入phpmyadmin管理界面 执行下面SQL语句即可

repair table ecs_goods

你直接修复下这个表就OK了。。

表损坏,需要修复