http://shop.qunor.com



MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT g.goods_id, g.goods_name, g.goods_img, SUM(og.goods_number) as goods_number FROM `qicome`.`qunorecs_goods` AS g, `qicome`.`qunorecs_order_info` AS o, `qicome`.`qunorecs_order_goods` AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND o.order_sn >= '20080621' AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND o.order_status = '1' AND (o.pay_status = '2' OR o.pay_status = '1') AND (o.shipping_status = '1' OR o.shipping_status = '2') GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT 10 ) [2] => Array ( [error] => Table 'o' is marked as crashed and should be repaired ) [3] => Array ( [errno] => 1194 ) )


望高手相助

[ 本帖最后由 qunor 于 2008-7-21 18:40 编辑 ]

用phpmyadmin修复下表 qunorecs_order_info  看看。

试试看，先谢过

通过版主的指导，已经恢复，谢谢，但是对于这种问题发生的原因还是很想探究下。

我也老出这种问题