Out of resources when opening file './admin_avtohype/cscart_products.MYD' (Errcode: 24) (23)
SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, products.product_type, products.parent_product_id, 1 as instock_marker, IF( products.product_type = 'C', (SELECT MAX(amount) FROM cscart_products WHERE parent_product_id = products.product_id) > 0, IF( IF( products.tracking = 'O', (SELECT MAX(amount) FROM cscart_product_options_inventory s_inventory WHERE s_inventory.product_id = products.product_id) > 0, products.amount > 0 ), 1, IF( products.tracking = 'D', 1, 0 ) ) ) as instock_sorting FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ru' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id 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_categories.status IN ('A', 'H') LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'ru' WHERE 1 AND cscart_categories.category_id IN (711, 5071, 723, 722, 721, 720, 719, 718, 717, 716, 715, 2054, 2082, 2103, 2114, 2050, 2051, 2052, 2053, 2055, 2056, 2057, 2058, 2059, 2060, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2068, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2080, 2081, 2083, 2084, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2098, 2099, 2100, 2101, 2102, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2111, 2112, 2113, 2115, 2116, 2117, 2118, 2119, 2120, 2121, 2122, 2123, 2124, 2125, 2126, 10275, 10276, 10277, 10278, 10279, 10280, 13161) AND cscart_categories.company_id = 1 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 GROUP BY products.product_id ORDER BY instock_sorting DESC, product asc, products.product_id ASC LIMIT 624, 48
app/Tygh/Database/Connection.php, line: 1141
| File: | app/Tygh/Database/Connection.php |
| Line: | 504 |
| Function: | throwError |
| File: | app/Tygh/Database/Connection.php |
| Line: | 224 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 31 |
| Function: | getArray |
| File: | app/functions/fn.catalog.php |
| Line: | 7551 |
| Function: | db_get_array |
| File: | app/functions/fn.catalog.php |
| Line: | 7627 |
| Function: | {closure} |
| File: | app/controllers/frontend/categories.php |
| Line: | 105 |
| Function: | fn_get_products |
| File: | app/functions/fn.control.php |
| Line: | 679 |
| Function: | include |
| File: | app/functions/fn.control.php |
| Line: | 430 |
| Function: | fn_run_controller |
| File: | index.php |
| Line: | 25 |
| Function: | fn_dispatch |