+7(903)-085-48-32
demiks88@mail.ru
FILE: /sites/uspeh-1.rf/bitrix/modules/iblock/classes/mysql/iblocksection.php
LINE: 302
MySQL Query Error: SELECT DISTINCT BS.ID AS ID, BS.DEPTH_LEVEL AS DEPTH_LEVEL, BS.NAME AS NAME, B.SECTION_PAGE_URL AS SECTION_PAGE_URL, BS.CODE AS CODE, BS.XML_ID AS EXTERNAL_ID, B.IBLOCK_TYPE_ID AS IBLOCK_TYPE_ID, BS.IBLOCK_ID AS IBLOCK_ID, B.CODE AS IBLOCK_CODE, B.XML_ID AS IBLOCK_EXTERNAL_ID, BS.GLOBAL_ACTIVE AS GLOBAL_ACTIVE FROM b_iblock_section BS INNER JOIN b_iblock B ON BS.IBLOCK_ID = B.ID LEFT JOIN b_iblock_group IBG ON IBG.IBLOCK_ID=B.ID WHERE 1=1 AND ((((BS.IBLOCK_ID = '6')))) AND ((((BS.GLOBAL_ACTIVE='Y')))) AND ((((BS.DEPTH_LEVEL <= '3')))) AND ((((B.ID = '6')))) AND ((((B.ACTIVE='Y')))) AND ( IBG.GROUP_ID IN (2) AND IBG.PERMISSION >= 'R' AND (IBG.PERMISSION = 'X' OR B.ACTIVE = 'Y') ) ORDER BY BS.LEFT_MARGIN asc [Expression #1 of ORDER BY clause is not in SELECT list, references column 'uspeh_db.BS.LEFT_MARGIN' which is not in SELECT list; this is incompatible with DISTINCT]
LINE: 302
MySQL Query Error: SELECT DISTINCT BS.ID AS ID, BS.DEPTH_LEVEL AS DEPTH_LEVEL, BS.NAME AS NAME, B.SECTION_PAGE_URL AS SECTION_PAGE_URL, BS.CODE AS CODE, BS.XML_ID AS EXTERNAL_ID, B.IBLOCK_TYPE_ID AS IBLOCK_TYPE_ID, BS.IBLOCK_ID AS IBLOCK_ID, B.CODE AS IBLOCK_CODE, B.XML_ID AS IBLOCK_EXTERNAL_ID, BS.GLOBAL_ACTIVE AS GLOBAL_ACTIVE FROM b_iblock_section BS INNER JOIN b_iblock B ON BS.IBLOCK_ID = B.ID LEFT JOIN b_iblock_group IBG ON IBG.IBLOCK_ID=B.ID WHERE 1=1 AND ((((BS.IBLOCK_ID = '6')))) AND ((((BS.GLOBAL_ACTIVE='Y')))) AND ((((BS.DEPTH_LEVEL <= '3')))) AND ((((B.ID = '6')))) AND ((((B.ACTIVE='Y')))) AND ( IBG.GROUP_ID IN (2) AND IBG.PERMISSION >= 'R' AND (IBG.PERMISSION = 'X' OR B.ACTIVE = 'Y') ) ORDER BY BS.LEFT_MARGIN asc [Expression #1 of ORDER BY clause is not in SELECT list, references column 'uspeh_db.BS.LEFT_MARGIN' which is not in SELECT list; this is incompatible with DISTINCT]
|