Fatal error: Uncaught exception 'Exception' with message ' in /var/www/b2b/system/library/db/mysqli.php on line 56

Exception: Error: Disk full (/tmp/#sql_3d2_3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<br />Error No: 1021<br />SELECT * , p.*,
				p.stockid ,p.image, manufacturer_id as mfgid ,
				(SELECT price FROM prices ps WHERE ps.stockid = p.stockid AND ps.typeabbrev = 'A1' AND ((ps.startdate = '0000-00-00' OR ps.startdate <= DATE(NOW())) AND (ps.enddate = '0000-00-00' OR ps.enddate > DATE(NOW()))) ORDER BY ps.price ASC LIMIT 1) AS special,
		 		(select price from prices where stockid = p.stockid and typeabbrev = 'A1' and  startdate <= DATE(NOW()) AND enddate  > DATE(NOW()) LIMIT 1 ) as price,
		 		 IF(stocksort.sort is null, 5000, stocksort.sort) as sorting
		 		  FROM product_to_category pc INNER JOIN stockmaster p on p.stockid = pc.stockid and pc.category_id = '59'  LEFT JOIN stocksort on stocksort.stockid = p.stockid  INNER JOIN product_description d on p.stockid = d.stockid  INNER JOIN product_to_manufacturer on product_to_manufacturer.stockid = p.stockid AND manufacturer_id='24'  WHERE 1    and p.image <> '' and discontinued ='0' and enabled='1' 

		 or (p.stockid like '%')
		  and (p.image <> '' and discontinued ='0' and enabled='1') 

		 GROUP BY p.stockid
		 having price > 0
		 OR (p.mbflag = 'C' and price is not NULL)
		  ORDER BY sorting asc, p.stockid asc, price  DESC  LIMIT 0,50 in /var/www/b2b/system/library/db/mysqli.php on line 56

Call Stack:
    0.0001     235728   1. {main}() /var/www/b2b/index.php:0
    0.0013     353232   2. start() /var/www/b2b/index.php:45
    0.0013     354816   3. require_once('/var/www/b2b/system/framework.php') /var/www/b2b/system/startup.php:130
    0.0093     539920   4. Front->dispatch() /var/www/b2b/system/framework.php:116
    0.0175     968600   5. Front->execute() /var/www/b2b/system/engine/front.php:28
    0.0175     968600   6. Action->execute() /var/www/b2b/system/engine/front.php:33
    0.0176     973312   7. call_user_func_array:{/var/www/b2b/system/engine/action.php:51}() /var/www/b2b/system/engine/action.php:51
    0.0176     973744   8. ControllerStartupRouter->index() /var/www/b2b/system/engine/action.php:51
    0.0177     974752   9. Action->execute() /var/www/b2b/catalog/controller/startup/router.php:36
    0.0178     980032  10. call_user_func_array:{/var/www/b2b/system/engine/action.php:51}() /var/www/b2b/system/engine/action.php:51
    0.0178     984648  11. ControllerProductCategory->index() /var/www/b2b/system/engine/action.php:51
    0.0320    1495904  12. Proxy->getProducts() /var/www/b2b/catalog/controller/product/category.php:287
    0.0320    1496256  13. Proxy->__call() /var/www/b2b/catalog/controller/product/category.php:287
    0.0320    1497392  14. call_user_func_array:{/var/www/b2b/system/engine/proxy.php:25}() /var/www/b2b/system/engine/proxy.php:25
    0.0320    1498568  15. Loader->{closure:/var/www/b2b/system/engine/loader.php:149-193}() /var/www/b2b/system/engine/proxy.php:25
    0.0322    1500152  16. call_user_func_array:{/var/www/b2b/system/engine/loader.php:180}() /var/www/b2b/system/engine/loader.php:180
    0.0322    1501056  17. ModelCatalogProduct->getProducts() /var/www/b2b/system/engine/loader.php:180
    0.0323    1506688  18. DB->query() /var/www/b2b/catalog/model/catalog/product.php:644
    0.0323    1506824  19. DB\MySQLi->query() /var/www/b2b/system/library/db.php:16