title: 126:Incorrect key file for table error appearing
body: <p>I'm getting the following error:</p>
  
  <blockquote>
    <p>PHP Fatal error:  126:Incorrect key file for table '/dev/shm/#sql_c40_0.MYI'; try to repair it :: SELECT (SELECT p.products_price  FROM (products p, products_description pd, products_to_categories p2c ) ORDER BY p.products_price LIMIT 1) AS low, (SELECT p.products_price  FROM (products p, products_description pd, products_to_categories p2c ) ORDER BY p.products_price DESC LIMIT 1) AS high in /hsphere/local/home/xxxxx/includes/classes/db/mysql/query_factory.php on line 101</p>
  </blockquote>
  
  <p>I thought maybe the above SQL was incorrect but when developing on my localhost I wasn't getting any error of the sort. I've read on here and elsewhere that it could be a tmp table size problem on the server but by host says that it's unlikely to be a server error and want to charge me money to investigate</p>
  
  <p>I'm using a zencart 1.5 if that makes any difference at all.</p>
  
  <p>Does anyone have ideas on what I could try to do to fix this?</p>