Database error: Disk full (/tmp/#sql_2b8_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (1021)
Invalid query: SELECT cscart_product_features_values.feature_id, COUNT(DISTINCT cscart_products.product_id) as products, cscart_product_features_values.variant_id as range_id, cscart_product_feature_variant_descriptions.variant as range_name, cscart_product_features.feature_type, cscart_product_filters.filter_id FROM cscart_product_features_values LEFT JOIN cscart_products ON cscart_products.product_id = cscart_product_features_values.product_id LEFT JOIN cscart_product_filters ON cscart_product_filters.feature_id = cscart_product_features_values.feature_id LEFT JOIN cscart_product_feature_variants ON cscart_product_feature_variants.variant_id = cscart_product_features_values.variant_id LEFT JOIN cscart_product_feature_variant_descriptions ON cscart_product_feature_variant_descriptions.variant_id = cscart_product_feature_variants.variant_id AND cscart_product_feature_variant_descriptions.lang_code = 'RU' LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_filters.feature_id LEFT JOIN (SELECT product_id, GROUP_CONCAT(cscart_product_features_values.variant_id) AS advanced_variants FROM cscart_product_features_values WHERE lang_code = 'RU' GROUP BY product_id) AS pfv_advanced ON pfv_advanced.product_id = cscart_products.product_id INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id LEFT JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id LEFT JOIN cscart_companies as companies ON companies.company_id = cscart_products.company_id WHERE cscart_product_features_values.feature_id IN (57, 129, 143, 162, 21, 142, 22, 24, 23, 144, 161, 173, 29) AND cscart_product_features_values.lang_code = 'RU' AND cscart_product_features_values.variant_id AND cscart_products_categories.category_id IN (419, 450, 451, 452, 453, 454, 606, 627, 628, 456, 457, 458, 459, 460, 461, 462, 491, 492, 499, 505, 511, 512, 515, 527, 559, 560, 561, 562, 563, 573, 577, 580, 581, 599, 630, 631, 533, 536, 537, 557, 564, 565, 566, 567, 568, 583, 584, 604, 605, 608, 610, 624, 569, 570, 571, 572, 578, 579, 582, 574, 575, 576, 586, 587, 588, 589, 590, 591, 598, 612, 613, 585, 592, 455, 593, 594, 595, 615, 616, 619, 596, 629, 600, 601, 602, 603, 614, 625, 626, 607, 609, 623, 611, 617, 618, 621, 622, 634, 299) AND ( FIND_IN_SET('1107', advanced_variants) OR FIND_IN_SET('1208', advanced_variants) OR FIND_IN_SET('1484', advanced_variants) OR FIND_IN_SET('1718', advanced_variants) OR FIND_IN_SET('1759', advanced_variants) OR FIND_IN_SET('1973', advanced_variants) OR FIND_IN_SET('1990', advanced_variants) OR FIND_IN_SET('2094', advanced_variants) OR FIND_IN_SET('2242', advanced_variants) OR FIND_IN_SET('2269', advanced_variants)) AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND (cscart_products.usergroup_ids = '' OR FIND_IN_SET(0, cscart_products.usergroup_ids) OR FIND_IN_SET(1, cscart_products.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_products.status IN ('A') AND (companies.status = 'A' OR cscart_products.company_id = 0) AND cscart_product_features.feature_type IN ('S', 'M', 'E') GROUP BY cscart_product_features_values.variant_id ORDER BY cscart_product_feature_variants.position, cscart_product_feature_variant_descriptions.variant
Backtrace:
File: | /var/www/html/extrabeers/core/fn.database.php |
Line: | 267 |
Function: | db_error |
File: | /var/www/html/extrabeers/core/fn.database.php |
Line: | 158 |
Function: | db_query |
File: | /var/www/html/extrabeers/core/fn.catalog.php |
Line: | 4592 |
Function: | db_get_hash_multi_array |
File: | /var/www/html/extrabeers/core/classes/bm/block.php |
Line: | 743 |
Function: | fn_get_filters_products_count |
File: | /var/www/html/extrabeers/core/classes/bm/render_manager.php |
Line: | 427 |
Function: | get_items |
File: | /var/www/html/extrabeers/core/classes/bm/render_manager.php |
Line: | 314 |
Function: | get_value |
File: | /var/www/html/extrabeers/core/classes/bm/render_manager.php |
Line: | 251 |
Function: | render_block_content |
File: | /var/www/html/extrabeers/core/classes/bm/render_manager.php |
Line: | 201 |
Function: | render_block |
File: | /var/www/html/extrabeers/core/classes/bm/render_manager.php |
Line: | 174 |
Function: | render_blocks |
File: | /var/www/html/extrabeers/core/classes/bm/render_manager.php |
Line: | 150 |
Function: | _render_grid |
File: | /var/www/html/extrabeers/core/classes/bm/render_manager.php |
Line: | 122 |
Function: | _render_container |
File: | /var/www/html/extrabeers/core/smarty_plugins/function.render_location.php |
Line: | 41 |
Function: | render |
File: | /var/www/html/extrabeers/var/cache/templates/customer/%%45^45E^45E480CD%%index.tpl.php |
Line: | 444 |
Function: | smarty_function_render_location |
File: | /var/www/html/extrabeers/lib/smarty/Smarty.class.php |
Line: | 1265 |
Function: | include |
File: | /var/www/html/extrabeers/lib/smarty/Smarty.class.php |
Line: | 1108 |
Function: | fetch |
File: | /var/www/html/extrabeers/core/classes/smarty_engine/core.php |
Line: | 168 |
Function: | display |
File: | /var/www/html/extrabeers/core/fn.control.php |
Line: | 580 |
Function: | display |
File: | /var/www/html/extrabeers/index.php |
Line: | 29 |
Function: | fn_dispatch |