Tygh\Exceptions\AException

Message

Out of resources when opening file './highload_demo_mv/cscart_product_descriptions.MYD' (Errcode: 24 - Too many open files) (23)

SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id 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') WHERE 1 AND cscart_categories.category_id IN (311, 312, 313, 332, 356, 467, 468, 469, 471, 490, 504, 505, 507, 513, 531, 537, 541, 555, 643, 648, 651, 656, 657, 690, 691, 718, 753, 781, 783, 784, 790, 852, 853, 897, 940, 950, 959, 972, 974, 984, 1023, 1040, 1041, 1048, 1049, 1076, 1081, 1100, 1129, 1139, 1201, 1256) AND companies.status = 'A' 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.approved = 'Y' AND products.product_type != 'D' GROUP BY products.product_id ORDER BY products.timestamp desc, products.product_id ASC LIMIT 96, 12

Error at

app/Tygh/Database/Connection.php, line: 1139

Backtrace

File:app/Tygh/Database/Connection.php
Line:503
Function:throwError
File:app/Tygh/Database/Connection.php
Line:236
Function:query
File:app/functions/fn.database.php
Line:31
Function:getArray
File:app/functions/fn.catalog.php
Line:7460
Function:db_get_array
File:app/functions/fn.catalog.php
Line:7536
Function:{closure}
File:app/controllers/frontend/categories.php
Line:105
Function:fn_get_products
File:app/functions/fn.control.php
Line:665
Function:include
File:app/functions/fn.control.php
Line:423
Function:fn_run_controller
File:index.php
Line:25
Function:fn_dispatch