Fatal error: Uncaught exception 'Exception' with message ' in /var/www/b2b/system/library/db/mysqli.php on line 40 Exception: Error: Disk full (/tmp/#sql_43a_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Error No: 1021
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 = '529' LEFT JOIN stocksort on stocksort.stockid = p.stockid INNER JOIN product_description d on p.stockid = d.stockid LEFT JOIN product_to_manufacturer on product_to_manufacturer.stockid = p.stockid 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 40 Call Stack: 0.0000 235624 1. {main}() /var/www/b2b/index.php:0 0.0017 353360 2. start() /var/www/b2b/index.php:45 0.0017 354944 3. require_once('/var/www/b2b/system/framework.php') /var/www/b2b/system/startup.php:130 0.0112 539920 4. Front->dispatch() /var/www/b2b/system/framework.php:116 0.0216 955784 5. Front->execute() /var/www/b2b/system/engine/front.php:28 0.0216 955784 6. Action->execute() /var/www/b2b/system/engine/front.php:33 0.0217 960504 7. call_user_func_array:{/var/www/b2b/system/engine/action.php:51}() /var/www/b2b/system/engine/action.php:51 0.0217 960936 8. ControllerStartupRouter->index() /var/www/b2b/system/engine/action.php:51 0.0219 961944 9. Action->execute() /var/www/b2b/catalog/controller/startup/router.php:36 0.0219 966864 10. call_user_func_array:{/var/www/b2b/system/engine/action.php:51}() /var/www/b2b/system/engine/action.php:51 0.0219 971384 11. ControllerProductCategory->index() /var/www/b2b/system/engine/action.php:51 0.0357 1456016 12. Proxy->getProducts() /var/www/b2b/catalog/controller/product/category.php:272 0.0357 1456368 13. Proxy->__call() /var/www/b2b/catalog/controller/product/category.php:272 0.0357 1457504 14. call_user_func_array:{/var/www/b2b/system/engine/proxy.php:25}() /var/www/b2b/system/engine/proxy.php:25 0.0357 1458680 15. Loader->{closure:/var/www/b2b/system/engine/loader.php:149-193}() /var/www/b2b/system/engine/proxy.php:25 0.0359 1460264 16. call_user_func_array:{/var/www/b2b/system/engine/loader.php:180}() /var/www/b2b/system/engine/loader.php:180 0.0359 1461096 17. ModelCatalogProduct->getProducts() /var/www/b2b/system/engine/loader.php:180 0.0361 1466880 18. DB->query() /var/www/b2b/catalog/model/catalog/product.php:641 0.0361 1467016 19. DB\MySQLi->query() /var/www/b2b/system/library/db.php:16