Вход для профи
8 (812) 612-28-28
[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: (1055) Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hk.price.VALUE_NUM' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (400)

        SELECT
            gk_elem.ID as ID, price.VALUE_NUM AS PRICE, MIN(price.VALUE_NUM) AS PRICE
        FROM
            (SELECT ID, NAME FROM b_iblock_element WHERE IBLOCK_ID = 5 AND ACTIVE='Y') as iblock_element
        INNER JOIN b_iblock_element_prop_m5 price ON iblock_element.ID = price.IBLOCK_ELEMENT_ID and price.IBLOCK_PROPERTY_ID = 10
INNER JOIN b_iblock_element_prop_s5 new_building_prop ON iblock_element.ID = new_building_prop.IBLOCK_ELEMENT_ID
INNER JOIN b_iblock_element_prop_s6 gk_prop ON new_building_prop.PROPERTY_9 = gk_prop.IBLOCK_ELEMENT_ID
INNER JOIN (SELECT VALUE, IBLOCK_ELEMENT_ID FROM b_iblock_element_prop_m6 WHERE IBLOCK_PROPERTY_ID = 14)
                            as metro ON new_building_prop.PROPERTY_9 = metro.IBLOCK_ELEMENT_ID
INNER JOIN b_iblock_element gk_elem ON new_building_prop.PROPERTY_9 = gk_elem.ID

        WHERE
            price.VALUE_NUM >= '1438952' and price.VALUE_NUM <= '449587000' and gk_prop.PROPERTY_12 in ('3') and metro.VALUE in ('8') and gk_elem.ACTIVE = 'Y' 
        GROUP BY gk_elem.ID
        ORDER BY PRICE ASC
          LIMIT 0, 10
        
/var/www/hochukvartiru.ru/bitrix/modules/main/lib/db/mysqliconnection.php:137
#0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL)
	/var/www/hochukvartiru.ru/bitrix/modules/main/lib/db/connection.php:330
#1: Bitrix\Main\DB\Connection->query(string)
	/var/www/hochukvartiru.ru/local/components/hk.catalog/new_build_gk.list/class.php:55
#2: NewBuildingGkList->getQuery(object)
	/var/www/hochukvartiru.ru/local/components/hk.catalog/new_build_gk.list/class.php:143
#3: NewBuildingGkList->executeComponent()
	/var/www/hochukvartiru.ru/bitrix/modules/main/classes/general/component.php:638
#4: CBitrixComponent->includeComponent(string, array, NULL)
	/var/www/hochukvartiru.ru/bitrix/modules/main/classes/general/main.php:1038
#5: CAllMain->IncludeComponent(string, string, array)
	/var/www/hochukvartiru.ru/novostroyki_gk/index.php:34
#6: include_once(string)
	/var/www/hochukvartiru.ru/bitrix/modules/main/include/urlrewrite.php:159
#7: include_once(string)
	/var/www/hochukvartiru.ru/bitrix/urlrewrite.php:2