+7 (812) 38-955-38
0 Сравнение
0 Избранное
0 В корзине пока пусто

Каталог товаров

[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
			GROUP BY property_name, code, use_synonym2, val1' at line 6 (400)
SELECT `property_name`, `code`, `use_synonym2`, COUNT(*) as cnt, 
       			CASE 
       			    WHEN `use_synonym2` = 1 THEN `synonym2` 
       			    ELSE `val` 
       			END AS val1 
			FROM `sf_props_from_1c` WHERE `filter2` = 1 AND `offer_id` IN ()
			GROUP BY property_name, code, use_synonym2, val1
/home/d/derom/28032019/public_html/bitrix/modules/main/lib/db/mysqliconnection.php:137
#0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL)
	/home/d/derom/28032019/public_html/bitrix/modules/main/lib/db/connection.php:330
#1: Bitrix\Main\DB\Connection->query(string)
	/home/d/derom/28032019/public_html/local/templates/dresscodeV2/components/bitrix/catalog.smart.filter/serfed/result_modifier.php:127
#2: include(string)
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component_template.php:877
#3: CBitrixComponentTemplate->__IncludeMutatorFile(array, array)
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component_template.php:784
#4: CBitrixComponentTemplate->IncludeTemplate(array)
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:735
#5: CBitrixComponent->showComponentTemplate()
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:683
#6: CBitrixComponent->includeComponentTemplate()
	/home/d/derom/28032019/public_html/bitrix/components/bitrix/catalog.smart.filter/component.php:947
#7: include(string)
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:594
#8: CBitrixComponent->__includeComponent()
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:102
#9: CBitrixComponent->executeComponent()
	/home/d/derom/28032019/public_html/bitrix/components/bitrix/catalog.smart.filter/class.php:130
#10: CBitrixCatalogSmartFilter->executeComponent()
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:638
#11: CBitrixComponent->includeComponent(string, array, boolean)
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/main.php:1064
#12: CAllMain->IncludeComponent(string, string, array, boolean)
	/home/d/derom/28032019/public_html/bitrix/templates/dresscodeV2/components/bitrix/catalog/.default/section.php:230
#13: include(string)
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component_template.php:720
#14: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string)
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component_template.php:815
#15: CBitrixComponentTemplate->IncludeTemplate(array)
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:735
#16: CBitrixComponent->showComponentTemplate()
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:683
#17: CBitrixComponent->includeComponentTemplate(string)
	/home/d/derom/28032019/public_html/bitrix/components/bitrix/catalog/component.php:172
#18: include(string)
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:594
#19: CBitrixComponent->__includeComponent()
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:653
#20: CBitrixComponent->includeComponent(string, array, boolean)
	/home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/main.php:1064
#21: CAllMain->IncludeComponent(string, string, array, boolean)
	/home/d/derom/28032019/public_html/catalog/index.php:729
#22: include_once(string)
	/home/d/derom/28032019/public_html/bitrix/modules/main/include/urlrewrite.php:159
#23: include_once(string)
	/home/d/derom/28032019/public_html/bitrix/urlrewrite.php:2