Tygh\Exceptions\AException

Message

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

SELECT cscart_promotions.*, cscart_promotion_descriptions.name, cscart_promotion_descriptions.detailed_description, cscart_promotion_descriptions.short_description FROM cscart_promotions LEFT JOIN cscart_promotion_descriptions ON cscart_promotion_descriptions.promotion_id = cscart_promotions.promotion_id AND cscart_promotion_descriptions.lang_code = 'uk' LEFT JOIN cscart_storefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = cscart_promotions.promotion_id WHERE 1 AND IF(from_date, from_date <= 1573850111, 1) AND IF(to_date, to_date >= 1573850111, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' AND (storefronts_promotions.storefront_id = 1 OR storefronts_promotions.storefront_id IS NULL) ORDER BY cscart_promotions.priority asc

Error at

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

Backtrace

File:app/Tygh/Database/Connection.php
Line:491
Function:throwError
File:app/Tygh/Database/Connection.php
Line:249
Function:query
File:app/functions/fn.database.php
Line:44
Function:getHash
File:app/functions/fn.promotions.php
Line:186
Function:db_get_hash_array
File:app/functions/fn.promotions.php
Line:250
Function:fn_get_promotions
File:app/functions/fn.catalog.php
Line:784
Function:fn_promotion_apply
File:app/controllers/frontend/categories.php
Line:112
Function:fn_gather_additional_products_data
File:app/functions/fn.control.php
Line:664
Function:include
File:app/functions/fn.control.php
Line:415
Function:fn_run_controller
File:index.php
Line:25
Function:fn_dispatch