Can't create/write to file '/tmp/#sql127_811733_0.MYI' (Errcode: 28)

[Borter]

这个问题任何解决，
用的是lycos的空间，以前正常，其他的连表查询也正常。
是在这句SQL上停了下来：
$query = $OExesql->Query('select '.$Table['forum'].'.id as forum_id,'.$Table['forum'].'.status as forum_status,'.$Table['forum'].'.name as forum_name,'.$Table['forum'].'.description as forum_description,'.$Table['forum'].'.master as forum_master,'.$Table['forum'].'.thread as forum_thread,'.$Table['forum'].'.reply as forum_reply,'.$Table['forum'].'.last_post as forum_last_post,'.$Table['forum'].'.last_author as forum_last_author,'.$Table['forum'].'.last_goto as forum_last_goto,'.$Table['catalog'].'.id as catalog_id,'.$Table['catalog'].'.name as catalog_name from '.$Table['forum'].' left join '.$Table['catalog'].' on '.$Table['forum'].'.catalog='.$Table['catalog'].'.id order by '.$Table['catalog'].'.order_id,'.$Table['catalog'].'.id,'.$Table['forum'].'.order_id');

页面在http://membres.lycos.fr/borter/forum/index.php

[webmin]

是不能对mysql的数据库文件进行操作了。

[webmin]

If you get an error for some queries of type:

Can't create/write to file '\\sqla3fe_0.ism'.

this means that MySQL can't create a temporary file for the result set in the given temporary directory. (The above error is a typical error message on Windows, and the Unix error message is similar.) The fix is to start mysqld with --tmpdir=path or to add to your option file:

[mysqld]
tmpdir=C:/temp

assuming that the `c:\\temp' directory exists. See section 4.1.2 `my.cnf' Option Files.

Check also the error code that you get with perror. One reason may also be a disk full error;

shell> perror 28
Error code 28: No space left on device

这个你要联系系统管理员跟你解决了。