Подобрать товары
[Bitrix\Main\DB\SqlQueryException] Mysql query error: (1) Can't create/write to file '/tmp/MYyl5GtZ' (Errcode: 28 - No space left on device) (400) SELECT BEP.* FROM b_iblock B INNER JOIN b_lang L ON B.LID=L.LID INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID INNER JOIN b_iblock_element_prop_s29 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID left join b_catalog_product as PRD on (PRD.ID = BE.ID) INNER JOIN b_iblock_element_prop_s29 BEP ON BEP.IBLOCK_ELEMENT_ID = BE.ID WHERE 1=1 AND ( ((((BE.IBLOCK_ID = 29)))) AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL))) AND ((((BE.ACTIVE='Y')))) AND (((FPS0.PROPERTY_195 IN (32502353, 32527463, 30008831, 32305045, 32406805, 32457316, 32458069, 32458070, 32458072, 32458426, 32458505, 32470624, 32476253, 32478616, 32482555, 32487838, 32491177, 32492143, 32492394, 32492566, 32495831, 32496352, 32497124, 32497588, 32498210, 32498931, 32499873, 32500290, 32500632, 32500873, 32501458, 32501859, 32503592, 32503983, 32504100, 32504709, 32504917, 32505408, 32505645, 32508415, 32508416, 32508417, 32510441, 32510929, 32512747, 32512750, 32512846, 32513561, 32513685, 32513842, 32514642, 32515715, 32516193, 32516376, 32516455, 32517242, 32517835, 32517838, 32517840, 32517996, 32518000, 32518015, 32518037, 32519825, 32519826, 32520416, 32520612, 32520865, 32520868, 32521744, 32521848, 32521849, 32521972, 32521973, 32522140, 32522696, 32522697, 32523357, 32523425, 32523560, 32523562, 32524712, 32526014, 32526015, 32526016, 32527066, 32527464, 32527919, 32527921, 32527922, 32528451, 32529654, 32529784, 32530047, 32530701, 32531044, 32531556, 32533292, 32533475, 32534069, 32534230, 32534328, 32534806, 32534884, 32534946, 32535518, 32537250, 32537452, 32537748, 32538039, 32538040, 32538749, 32538932, 32539391, 32540027, 32540179, 32540831, 32541407, 32541408, 32541409, 32541513, 32541686, 32541791, 32543046, 32543099, 32543154, 32543155, 32543375, 32543755, 32543894, 32544194, 32544413, 32544491, 32544493, 32544494, 32544503, 32544722, 32544882, 32545106, 32545107, 32545246, 32545247, 32545252, 32545253, 32545254, 32545737, 32545914, 32546299, 32546451, 32547221, 32547781, 32548615, 32548907, 32548910, 32549031, 32549032, 32549348, 32550996, 32551161, 32551162, 32552012, 32552137, 32552138, 32552340, 32552343, 32552668, 32552794, 32553142, 32553143, 32553283, 32553635, 32553637, 32553817, 32553950, 32554747, 32554749, 32555888, 32556081, 32556085, 32556090, 32556096, 32556099, 32557281, 32557287, 32558390, 32559337, 32559338, 32559411, 32559927, 32560009, 32560319, 32560705, 32561009, 32561219, 32561284, 32561460, 32561727, 32562238, 32562353, 32562355, 32562554, 32562915, 32563211, 32563481, 32563828, 32564241, 32564521, 32564525, 32564874, 32564876, 32565138, 32565413, 32565523, 32565631, 32565721, 32565725, 32565959, 32566073, 32566371, 32568796, 32569301, 32570010, 32570766, 32572013, 32572436, 32620506, 32620521, 32620588, 32633164, 32633198, 32633250, 32633297, 32641639, 32642971, 32643181, 32643305, 32643700, 32643853, 32643969, 32644826, 32644827, 32645282, 32645283, 32645390, 32645564, 32645857, 32645872, 32647553, 32647606, 32648011, 32648012, 32648013, 32648067, 32648127, 32648150, 32648350, 32648752, 32648842, 32648848, 32650262, 32650341, 32650430, 32650564, 32650565, 32650997, 32651057, 32651170, 32651473, 32651901, 32658035, 32660905, 32663901, 32663998, 32680941, 32680942, 32680943)))) AND ((((PRD.AVAILABLE='Y')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) AND (B.ID IN ( SELECT IBLOCK_ID FROM b_iblock_group IBG WHERE IBG.GROUP_ID IN (2) AND IBG.PERMISSION >= 'R' AND (IBG.PERMISSION='X' OR B.ACTIVE='Y') )) ORDER BY BEP.IBLOCK_ELEMENT_ID /home/bitrix/www/bitrix/modules/main/lib/db/mysqlcommonconnection.php:417 #0: Bitrix\Main\DB\MysqlCommonConnection->createQueryException /home/bitrix/www/bitrix/modules/main/classes/general/database.php:670 #1: CAllDatabase->Query /home/bitrix/www/bitrix/modules/iblock/classes/general/iblockelement.php:6497 #2: CAllIBlockElement::GetPropertyValues /home/bitrix/www/local/components/bitrix/catalog.smart.filter/component.php:193 #3: include(string) /home/bitrix/www/bitrix/modules/main/classes/general/component.php:622 #4: CBitrixComponent->__includeComponent /home/bitrix/www/bitrix/modules/main/classes/general/component.php:105 #5: CBitrixComponent->executeComponent /home/bitrix/www/local/components/bitrix/catalog.smart.filter/class.php:138 #6: CBitrixCatalogSmartFilter->executeComponent /home/bitrix/www/bitrix/modules/main/classes/general/component.php:675 #7: CBitrixComponent->includeComponent /home/bitrix/www/bitrix/modules/main/classes/general/main.php:1192 #8: CMain->IncludeComponent /home/bitrix/www/local/templates/unify2.6/components/bitrix/catalog/bootstrap_v4/section_vertical.php:199 #9: include(string) /home/bitrix/www/local/templates/unify2.6/components/bitrix/catalog/bootstrap_v4/section.php:84 #10: include(string) /home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:842 #11: CBitrixComponentTemplate->__IncludePHPTemplate /home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:951 #12: CBitrixComponentTemplate->IncludeTemplate /home/bitrix/www/bitrix/modules/main/classes/general/component.php:791 #13: CBitrixComponent->showComponentTemplate /home/bitrix/www/bitrix/modules/main/classes/general/component.php:731 #14: CBitrixComponent->includeComponentTemplate /home/bitrix/www/bitrix/components/bitrix/catalog/component.php:330 #15: include(string) /home/bitrix/www/bitrix/modules/main/classes/general/component.php:622 #16: CBitrixComponent->__includeComponent /home/bitrix/www/bitrix/modules/main/classes/general/component.php:699 #17: CBitrixComponent->includeComponent /home/bitrix/www/bitrix/modules/main/classes/general/main.php:1192 #18: CMain->IncludeComponent /home/bitrix/www/catalog/index.php:320 #19: require(string) /home/bitrix/www/bitrix/modules/webdebug.seo/lib/page.php:716 #20: WD\Seo\Page::includeComponentScript /home/bitrix/www/bitrix/modules/webdebug.seo/lib/page.php:702 #21: WD\Seo\Page::checkIncludeComponentScript /home/bitrix/www/bitrix/modules/webdebug.seo/lib/page.php:258 #22: WD\Seo\Page::onProlog /home/bitrix/www/bitrix/modules/webdebug.seo/lib/eventhandler.php:54 #23: WD\Seo\EventHandler::onProlog /home/bitrix/www/bitrix/modules/main/tools.php:5273 #24: ExecuteModuleEventEx /home/bitrix/www/bitrix/modules/main/classes/general/main.php:3690 #25: CMain::PrologActions /home/bitrix/www/bitrix/modules/main/include/prolog_before.php:21 #26: require_once(string) /home/bitrix/www/bitrix/modules/main/include/prolog.php:10 #27: require_once(string) /home/bitrix/www/bitrix/header.php:1 #28: require(string) /home/bitrix/www/catalog/index.php:2 #29: include_once(string) /home/bitrix/www/bitrix/modules/main/include/urlrewrite.php:128 #30: include_once(string) /home/bitrix/www/bitrix/urlrewrite.php:2 ----------