紧急求助,请高手们多多帮忙呵!

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



我们网店打开就出现这样的情况:
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT g.goods_id, g.goods_name, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, g.promote_price, g.promote_start_date, g.promote_end_date, g.goods_thumb, g.goods_img, g.goods_brief, g.goods_type FROM `sq_hanbin`.`ecs_goods` AS g LEFT JOIN `sq_hanbin`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND (( 1 AND ((goods_name LIKE '%176%' OR goods_sn LIKE '%176%' OR keywords LIKE '%176%' )) ) ) ORDER BY goods_id DESC LIMIT 32 ) [2] => Array ( [error] => Table '.\sq_hanbin\ecs_member_price' is marked as crashed and should be repaired ) [3] => Array ( [errno] => 145 ) )


不知道是什么原因?该怎么解决,麻烦大家帮忙一下哈,谢谢谢谢

回答:
好像是少数据库表

好像是少数据库表
童叟无欺 发表于 2009-5-7 01:40
谢谢你,不过这样的情况,如果是少数据库表,该怎么改好阿?

你先通过phpmyadmin 把表都修复一下 。

你先通过phpmyadmin 把表都修复一下 。
qiyongdong 发表于 2009-5-7 02:21
谢谢,不过phpmyadmin这个哪里有哈?

表损坏了,如果不能修复,改库好了

表损坏了,如果不能修复,改库好了
赢... 发表于 2009-5-9 22:14
不知道怎么改啊?在那里改啊