发新话题
打印

这个错误如何修改

这个错误如何修改

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, g.is_best, g.is_new, g.is_hot, g.is_promote, RAND() AS rnd FROM `um10s1_db`.`ecs_goods` AS g LEFT JOIN `um10s1_db`.`ecs_brand` AS b ON b.brand_id = g.brand_id LEFT JOIN `um10s1_db`.`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 (g.is_best = 1 OR g.is_new = 1 OR g.is_hot = 1 OR (g.is_promote = 1 AND promote_start_date <= '1215116413' AND promote_end_date >= '1215116413')) ORDER BY rnd ) [2] => Array ( [error] => Got error 12 from table handler ) [3] => Array ( [errno] => 1030 ) )

TOP

建议您先修复一下数据表,在ec后台数据库管理-〉SQL查询 ,或是登陆PHPMYADMIN 中执行sql语句:
repair table ecs_goods

TOP

修复了,仍是出这个错。

TOP

ecs_brand、ecs_member_price这个表也修复一下。

TOP

发新话题