FILE: /home/admin/web/mstroy.ru/public_html/bitrix/modules/iblock/classes/mysql/iblock.php LINE: 235 MySQL Query Error:
SELECT DISTINCT
B.*
,B.XML_ID as EXTERNAL_ID
,DATE_FORMAT(B.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X
,L.DIR as LANG_DIR
,L.SERVER_NAME
FROM
b_iblock B
LEFT JOIN b_iblock_site BS ON B.ID=BS.IBLOCK_ID
LEFT JOIN b_lang L ON L.LID=BS.SITE_ID
WHERE 1 = 1
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')
)
OR (B.RIGHTS_MODE = 'E' AND B.ID IN (
SELECT IBLOCK_ID
FROM b_iblock_right IBR
INNER JOIN b_task_operation T ON T.TASK_ID = IBR.TASK_ID
INNER JOIN b_operation O ON O.ID = T.OPERATION_ID
INNER JOIN b_user_access UA ON UA.ACCESS_CODE = IBR.GROUP_CODE AND UA.USER_ID = 0
WHERE IBR.ENTITY_TYPE = 'iblock'
AND O.NAME in ('section_read', 'element_read', 'section_element_bind', 'section_section_bind')
))
)
AND ((((B.ACTIVE='Y')))) AND ((((BS.SITE_ID='s1')))) AND ((((B.IBLOCK_TYPE_ID LIKE '1c_catalog')))) AND ((((B.CODE LIKE 'catalog'))))
ORDER BY B.SORT asc , B.ID asc [[1021] Disk full (/var/tmp/#sql_42be_1); waiting for someone to free some space...]