rand() not working?

[erikhillis]

Here is my error:
Invalid query (SELECT * FROM store ORDER BY rand() LIMIT 1) : Got error 28 from table handler

and here is my code:

$sql = "SELECT * FROM store ORDER BY rand() LIMIT 1";
if (!$result = mysql_query($sql)) {
    print "Invalid query ($sql) : " . mysql_error();
    exit;
}

[trex005]

error 28 means that the disk is full. Try optimizing tables. This often is a more serious problem especially with shared hosts, as you may not be able to remidy it. Often if the Mail Directory on a server is in the same partition as the MySQL tables a nasty virus attack can blow you out of the water.