DataBase Error, How to fix this..

I am getting this error.

Database error in vBulletin 3.8.7:

 Invalid SQL:

                SELECT * FROM icc_question_queue
                WHERE postdate = 0 AND status < 3
                AND forumid = 47
                ORDER BY RAND() LIMIT 1;

 MySQL Error   : Can't create/write to file '/tmp/#sql_7ece_1.MYD' (Errcode: 17)
 Error Number  : 1
 Request Date  : Sunday, January 1st 2012 @ 03:53:41 AM
 Error Date    : Sunday, January 1st 2012 @ 03:53:41 AM
 Script        : http://domain.com/forum/index.php
 Referrer      :
 IP Address    : 66.91.131.131
 Username      : Unregistered
 Classname     : vB_Database
 MySQL Version :

Code (markup):

How to fix this??

 

looks like your /tmp might be out of space
check that folder first

 

i did not get any tmp folder. where to look this?

 

is your forum on openvz vps or on xen vps server?

if you have xen or kvm or vmware vps other than OpenVZ vps, you can create partition tmp symlinked to /var/tmp and /tmp with e.g 10 GB and the forum will wok well

 

I contact my host and they solve my problem. Thanks lachrymologist for hint.