MySQL server error report

来源：百度知道 编辑：UC知道 时间：2024/05/05 14:32:16
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo > '', '1', '0') AS tag FROM `ecshop`.`ecs_brand`AS b, `ecshop`.`ecs_goods` AS g WHERE g.brand_id = b.brand_id AND is_show = 1 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC LIMIT 3 ) [2] => Array ( [error] => Can't create/write to file '\tmp\#sql5e8_102_3.MYI' (Errcode: 2) ) [3] => Array ( [errno] => 1 ) )

怎么回事. 帮忙看看啊. 谢谢啊.
引起此问题的原因：
1.数据库已经满了
2.相应目录具有可读写的权限。
解决方法：
1.增大服务器空间。
2.清理缓存目录、清空ecs_states表，目的都是为了增大可用空间。
3.还有些用户经常备份数据库，这样会造成data目录下的文件占用空间。建议用户备份数据库后将备份文件保存到本地，然后将服务器上的备份文件清除。
4.赋予相应的目录为可读写的权限。

在执行 SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo > '', '1', '0') AS tag FROM `ecshop`.`ecs_brand`AS b, `ecshop`.`ecs_goods` AS g WHERE g.brand_id = b.brand_id AND is_show = 1 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC LIMIT 3语句时无法在目录\tmp\中创建sql5e8_102_3.MYI临时索引。
你看看\tmp\目录mysql有没有写权限吧。

这些是代码