( ! ) Fatal error: Uncaught Exception: Error: Disk full (/tmp/#sql-temptable-338-5c917-55dff.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<br />Error No: 1021<br />SELECT DISTINCT (p2s.product_id), p.*, p2s.price as price, p2s.price_postavka as price_postavka,c.sort_order as sort_category, p2s.quantity as quantity, pts.seller_id, (SELECT GROUP_CONCAT(attribute_id) FROM huge_mebel_product_attribute pa WHERE pa.product_id = p.product_id) as attributes, (SELECT AVG(rating) AS total FROM huge_mebel_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1') AS rating, (SELECT price FROM huge_mebel_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM huge_mebel_product_special ps WHERE ps.product_id = p.product_id AND ps.custom in /var/www/huge-mebel.ru/system/library/db/mysqli.php on line 57 |
( ! ) Exception: Error: Disk full (/tmp/#sql-temptable-338-5c917-55dff.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<br />Error No: 1021<br />SELECT DISTINCT (p2s.product_id), p.*, p2s.price as price, p2s.price_postavka as price_postavka,c.sort_order as sort_category, p2s.quantity as quantity, pts.seller_id, (SELECT GROUP_CONCAT(attribute_id) FROM huge_mebel_product_attribute pa WHERE pa.product_id = p.product_id) as attributes, (SELECT AVG(rating) AS total FROM huge_mebel_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1') AS rating, (SELECT price FROM huge_mebel_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM huge_mebel_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) AND ps.store_id= '0' ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM huge_mebel_product p LEFT JOIN huge_mebel_product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN huge_mebel_category_path cp ON(cp.category_id = p2c.category_id)
LEFT JOIN huge_mebel_category c ON(c.category_id = p2c.category_id) LEFT JOIN huge_mebel_product_to_seller pts ON (pts.product_id = p.product_id) LEFT JOIN huge_mebel_manufacturer_to_store mts ON (mts.manufacturer_id = p.manufacturer_id) LEFT JOIN huge_mebel_product_attribute pa ON (p.product_id = pa.product_id) LEFT JOIN huge_mebel_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN huge_mebel_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = 1 AND p2s.price > 0 AND p.date_available <= NOW() AND p2s.store_id = '0' AND c.status = 1 AND mts.store_id = '0' AND cp.path_id = '429' ORDER BY sort_category ASC LIMIT 2640,24 in /var/www/huge-mebel.ru/system/library/db/mysqli.php on line 57 |
Call Stack |
# | Time | Memory | Function | Location |
1 | 0.0001 | 400016 | {main}( ) | .../index.php:0 |
2 | 0.0008 | 431928 | start( $application_config = 'catalog' ) | .../index.php:40 |
3 | 0.0008 | 433432 | require_once( '/var/www/huge-mebel.ru/system/framework.php ) | .../startup.php:102 |
4 | 0.0038 | 526192 | Router->dispatch( $action = class Action { private $id = 'startup/router'; private $route = 'startup/router'; private $method = 'index' }, $error = class Action { private $id = 'error/not_found'; private $route = 'error/not_found'; private $method = 'index' } ) | .../framework.php:162 |
5 | 0.0175 | 765832 | Router->execute( $action = class Action { private $id = 'startup/router'; private $route = 'startup/router'; private $method = 'index' } ) | .../router.php:56 |
6 | 0.0175 | 765832 | Action->execute( $registry = class Registry { private $data = ['config' => class Config { ... }, 'log' => class Log { ... }, 'event' => class Event { ... }, 'load' => class Loader { ... }, 'request' => class Request { ... }, 'response' => class Response { ... }, 'db' => class DB { ... }, 'session' => class Session { ... }, 'cache' => class Cache { ... }, 'url' => class Url { ... }, 'language' => class Language { ... }, 'document' => class Document { ... }, 'model_design_translation' => class Proxy { ... }, 'model_localisation_language' => class Proxy { ... }, 'customer' => class Cart\Customer { ... }, 'model_localisation_currency' => class Proxy { ... }, 'currency' => class Cart\Currency { ... }, 'tax' => class Cart\Tax { ... }, 'weight' => class Cart\Weight { ... }, 'length' => class Cart\Length { ... }, 'cart' => class Cart\Cart { ... }, 'encryption' => class Encryption { ... }, 'model_setting_event' => class Proxy { ... }, 'model_setting_store' => class Proxy { ... }, 'model_catalog_category' => class Proxy { ... }, 'model_catalog_product' => class Proxy { ... }, 'model_tool_image' => class Proxy { ... }, 'model_catalog_review' => class Proxy { ... }] }, $args = ??? ) | .../router.php:67 |
7 | 0.0176 | 766784 | ControllerStartupRouter->index( ) | .../action.php:79 |
8 | 0.0178 | 779984 | Action->execute( $registry = class Registry { private $data = ['config' => class Config { ... }, 'log' => class Log { ... }, 'event' => class Event { ... }, 'load' => class Loader { ... }, 'request' => class Request { ... }, 'response' => class Response { ... }, 'db' => class DB { ... }, 'session' => class Session { ... }, 'cache' => class Cache { ... }, 'url' => class Url { ... }, 'language' => class Language { ... }, 'document' => class Document { ... }, 'model_design_translation' => class Proxy { ... }, 'model_localisation_language' => class Proxy { ... }, 'customer' => class Cart\Customer { ... }, 'model_localisation_currency' => class Proxy { ... }, 'currency' => class Cart\Currency { ... }, 'tax' => class Cart\Tax { ... }, 'weight' => class Cart\Weight { ... }, 'length' => class Cart\Length { ... }, 'cart' => class Cart\Cart { ... }, 'encryption' => class Encryption { ... }, 'model_setting_event' => class Proxy { ... }, 'model_setting_store' => class Proxy { ... }, 'model_catalog_category' => class Proxy { ... }, 'model_catalog_product' => class Proxy { ... }, 'model_tool_image' => class Proxy { ... }, 'model_catalog_review' => class Proxy { ... }] }, $args = ??? ) | .../router.php:25 |
9 | 0.0178 | 780968 | ControllerProductCategory->index( ) | .../action.php:79 |
10 | 0.0979 | 919632 | Proxy->getProducts( ['filter_category_id' => 429, 'filter_sub_category' => TRUE, 'filter_filter' => '', 'filter_attr' => '', 'filter_quantity' => '', 'sort' => 'sort_category', 'order' => 'ASC', 'start' => 2640, 'limit' => '24'] ) | .../category.php:278 |
11 | 0.0979 | 920008 | Proxy->__call( $key = 'getProducts', $args = [0 => ['filter_category_id' => 429, 'filter_sub_category' => TRUE, 'filter_filter' => '', 'filter_attr' => '', 'filter_quantity' => '', 'sort' => 'sort_category', 'order' => 'ASC', 'start' => 2640, 'limit' => '24']] ) | .../category.php:278 |
12 | 0.0979 | 920784 | Loader->{closure:/var/www/huge-mebel.ru/system/engine/loader.php:220-262}( $args = [0 => ['filter_category_id' => 429, 'filter_sub_category' => TRUE, 'filter_filter' => '', 'filter_attr' => '', 'filter_quantity' => '', 'sort' => 'sort_category', 'order' => 'ASC', 'start' => 2640, 'limit' => '24']], [0 => ['filter_category_id' => 429, 'filter_sub_category' => TRUE, 'filter_filter' => '', 'filter_attr' => '', 'filter_quantity' => '', 'sort' => 'sort_category', 'order' => 'ASC', 'start' => 2640, 'limit' => '24']] ) | .../proxy.php:47 |
13 | 0.0981 | 921816 | ModelCatalogProduct->getProducts( $data = ['filter_category_id' => 429, 'filter_sub_category' => TRUE, 'filter_filter' => '', 'filter_attr' => '', 'filter_quantity' => '', 'sort' => 'sort_category', 'order' => 'ASC', 'start' => 2640, 'limit' => '24'] ) | .../loader.php:248 |
14 | 0.0981 | 923864 | DB->query( $sql = 'SELECT DISTINCT (p2s.product_id), p.*, p2s.price as price, p2s.price_postavka as price_postavka,c.sort_order as sort_category, p2s.quantity as quantity, pts.seller_id, (SELECT GROUP_CONCAT(attribute_id) FROM huge_mebel_product_attribute pa WHERE pa.product_id = p.product_id) as attributes, (SELECT AVG(rating) AS total FROM huge_mebel_review r1 WHERE r1.product_id = p.product_id AND r1.status = \'1\') AS rating, (SELECT price FROM huge_mebel_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.cus'... ) | .../product.php:386 |
15 | 0.0981 | 923864 | DB\MySQLi->query( $sql = 'SELECT DISTINCT (p2s.product_id), p.*, p2s.price as price, p2s.price_postavka as price_postavka,c.sort_order as sort_category, p2s.quantity as quantity, pts.seller_id, (SELECT GROUP_CONCAT(attribute_id) FROM huge_mebel_product_attribute pa WHERE pa.product_id = p.product_id) as attributes, (SELECT AVG(rating) AS total FROM huge_mebel_review r1 WHERE r1.product_id = p.product_id AND r1.status = \'1\') AS rating, (SELECT price FROM huge_mebel_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.cus'... ) | .../db.php:45 |