求助!在后台数据表优化时出现这个,怎么办

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

商品后台不能编辑了,商品页和大多数页面也不能打开了


编辑商品显示:

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT user_rank, user_price FROM `whjht`.`ecs_member_price` WHERE goods_id = '1103' ) [2] => Array ( [error] => Table '.\whjht\ecs_member_price' is marked as crashed and should be repaired ) [3] => Array ( [errno] => 145 ) )



页面打不开显示:

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, goods_img, b.brand_name FROM `whjht`.`ecs_goods` AS g LEFT JOIN `whjht`.`ecs_brand` AS b ON b.brand_id = g.brand_id LEFT JOIN `whjht`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND is_best = 1 AND (g.cat_id IN ('13','21','22','23','26','24','25','27','29','30','37','36','35','34','33','32','31','38','40','39','41') OR g.goods_id IN ('') ) ORDER BY g.sort_order, g.last_update DESC LIMIT 3 ) [2] => Array ( [error] => Table '.\whjht\ecs_member_price' is marked as crashed and should be repaired ) [3] => Array ( [errno] => 145 ) )

回答:
数据表:
ecs_auto_manage0.00 KBTable '.\whjht\ecs_auto_manage' is marked as crashed and should be repaired

ecs_member_price0.00 KBTable '.\whjht\ecs_member_price' is marked as crashed and should be repaired

ecs_pay_log0.00 KBTable '.\whjht\ecs_pay_log' is marked as crashed and should be repaired

在线等阿,晓天老大帮帮忙阿

提示表需要修复
http://bbs.ecshop.com/thread-95341-1-1.html
42

你可以先修复下表试下