Подобрать товары
[Bitrix\Main\DB\SqlQueryException] Mysql query error: (1) Can't create/write to file '/tmp/MYGrHXv4' (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 (32554070, 32557281, 32557293, 32558927, 32559039, 32559411, 32560009, 32560614, 32561284, 32561864, 32562072, 32562172, 32562354, 32562680, 32562681, 32562781, 32563095, 32563212, 32563402, 32563829, 32563834, 32563836, 32564242, 32565138, 32565260, 32565524, 32566073, 32566074, 32566153, 32566372, 32569770, 32572436, 32632968, 32633202, 32641796, 32641947, 32641989, 32643154, 32643396, 32644228, 32644367, 32645031, 32645123, 32645170, 32645742, 32645743, 32645744, 32645745, 32645796, 32645797, 32645837, 32645885, 32647345, 32647393, 32647443, 32647444, 32647445, 32647608, 32647610, 32647612, 32647984, 32647985, 32648011, 32648068, 32648069, 32648277, 32648278, 32648344, 32648348, 32648351, 32648508, 32648693, 32648848, 32649027, 32649314, 32649325, 32649343, 32650261, 32650262, 32650342, 32650420, 32650545, 32650546, 32650547, 32650634, 32650752, 32650753, 32650754, 32650755, 32650756, 32650757, 32650758, 32650863, 32650963, 32651082, 32651100, 32651101, 32651139, 32651140, 32651178, 32651193, 32651194, 32651195, 32651228, 32651253, 32651258, 32651338, 32651473, 32651487, 32651521, 32651530, 32651558, 32651580, 32651901, 32651922, 32652071, 32652089, 32652096, 32652097, 32652111, 32652144, 32658024, 32658094, 32658794, 32658795, 32658796, 32658797, 32658798, 32658799, 32658979, 32658980, 32659041, 32659050, 32659051, 32659067, 32659091, 32659126, 32659127, 32659128, 32659192, 32659193, 32659285, 32659331, 32659352, 32659362, 32659370, 32659371, 32659381, 32659389, 32659398, 32659430, 32659431, 32659452, 32659453, 32659454, 32659482, 32659509, 32659562, 32659606, 32659619, 32659627, 32659636, 32659637, 32659655, 32659662, 32659663, 32659688, 32659689, 32660119, 32660228, 32660613, 32660647, 32660654, 32660673, 32660761, 32660815, 32660816, 32660817, 32660854, 32660855, 32660905, 32660975, 32661005, 32661095, 32661134, 32661135, 32661182, 32661199, 32661220, 32661221, 32661274, 32661275, 32661291, 32661336, 32661347, 32661413, 32661478, 32661484, 32661494, 32661495, 32661517, 32661528, 32661529, 32661539, 32661540, 32661795, 32661796, 32661854, 32661855, 32661908, 32661909, 32661921, 32661922, 32661923, 32661981, 32661982, 32661992, 32661993, 32662150, 32662151, 32662166, 32662183, 32662191, 32662511, 32662646, 32662679, 32662690, 32662691, 32662692, 32662693, 32662694, 32662958, 32662965, 32663009, 32663017, 32663075, 32663086, 32663092, 32663098, 32663137, 32663145, 32663146, 32663158, 32663159, 32663177, 32663192, 32663207, 32663214, 32663264, 32663277, 32663278, 32663309, 32663325, 32663352, 32663444, 32663608, 32663633, 32663652, 32663668, 32663674, 32663675, 32663772, 32663871, 32663901, 32663902, 32663943, 32663950, 32663951, 32663998, 32664026, 32664503, 32664548, 32664549, 32664638, 32665110, 32665253, 32665254, 32665526, 32665528, 32735616, 32736269, 32742937)))) 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 ----------