Can\'t create/write to file \'/var/tmp(err

[Anon]

Hi All,
I am getting the below error on my site.

"Can't create/write to file '/var/tmp/#sql119ea_d8b_c.MYI' (Errcode: 24)."

Mine is a B2B portal using php and MySql.
This error is temporary and vanishes after 5 mins.

I have contacted the web server people and i have increased my web space also but there was no difference.

Pls help me as i am unable to find out the reason.

Thanks.

[Anon]

Here is a link to the mysql manual where it tells you what the error means

http://www.mysql.com/doc/C/a/Cannot_create.html

[Anon]

Thanks.I went thru the link and read.It says that it couldn't create temporary file for the resultset means is my query wrong or is it the problem of the mysql?