File: /var/www/ph841707/data/www/1c-ka.ru/bitrix/modules/catalog/mysql/cataloggroup.php
Line: 437
MySQL Query Error: SELECT CG.ID as ID, CG.NAME as NAME, CG.BASE as BASE, CG.SORT as SORT, CGL.NAME as NAME_LANG, IF(CGG.ID IS NULL, 'N', 'Y') as CAN_ACCESS, IF(CGG1.ID IS NULL, 'N', 'Y') as CAN_BUY, CG.XML_ID as XML_ID, CG.MODIFIED_BY as MODIFIED_BY, CG.CREATED_BY as CREATED_BY, DATE_FORMAT(CG.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE, DATE_FORMAT(CG.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, COUNT( CG.ID) as CNT FROM b_catalog_group CG LEFT JOIN b_catalog_group_lang CGL ON (CG.ID = CGL.CATALOG_GROUP_ID AND CGL.LID = 'ru') LEFT JOIN b_catalog_group2group CGG ON (CG.ID = CGG.CATALOG_GROUP_ID AND CGG.GROUP_ID IN (2) AND CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CGG1 ON (CG.ID = CGG1.CATALOG_GROUP_ID AND CGG1.GROUP_ID IN (2) AND CGG1.BUY = 'Y') GROUP BY CG.ID, CG.NAME, CG.BASE, CG.SORT, CG.XML_ID, CG.MODIFIED_BY, CG.CREATED_BY, CG.DATE_CREATE, CG.TIMESTAMP_X, CGL.NAME[Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ph841707_site.CGG.ID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
Line: 437
MySQL Query Error: SELECT CG.ID as ID, CG.NAME as NAME, CG.BASE as BASE, CG.SORT as SORT, CGL.NAME as NAME_LANG, IF(CGG.ID IS NULL, 'N', 'Y') as CAN_ACCESS, IF(CGG1.ID IS NULL, 'N', 'Y') as CAN_BUY, CG.XML_ID as XML_ID, CG.MODIFIED_BY as MODIFIED_BY, CG.CREATED_BY as CREATED_BY, DATE_FORMAT(CG.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE, DATE_FORMAT(CG.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, COUNT( CG.ID) as CNT FROM b_catalog_group CG LEFT JOIN b_catalog_group_lang CGL ON (CG.ID = CGL.CATALOG_GROUP_ID AND CGL.LID = 'ru') LEFT JOIN b_catalog_group2group CGG ON (CG.ID = CGG.CATALOG_GROUP_ID AND CGG.GROUP_ID IN (2) AND CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CGG1 ON (CG.ID = CGG1.CATALOG_GROUP_ID AND CGG1.GROUP_ID IN (2) AND CGG1.BUY = 'Y') GROUP BY CG.ID, CG.NAME, CG.BASE, CG.SORT, CG.XML_ID, CG.MODIFIED_BY, CG.CREATED_BY, CG.DATE_CREATE, CG.TIMESTAMP_X, CGL.NAME[Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ph841707_site.CGG.ID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
|