File: /var/www/html/bitrix/modules/search/classes/general/search.php Line: 188 MySQL Query Error:
SELECT
stags2.NAME
,COUNT(DISTINCT stags2.SEARCH_CONTENT_ID) as CNT
,MAX(sc.DATE_CHANGE) DC_TMP
,DATE_FORMAT(MAX(sc.DATE_CHANGE), '%d.%m.%Y %H:%i:%s') as FULL_DATE_CHANGE
,DATE_FORMAT(MAX(sc.DATE_CHANGE), '%d.%m.%Y') as DATE_CHANGE
FROM b_search_tags stags2
INNER JOIN b_search_content sc ON (stags2.SEARCH_CONTENT_ID=sc.ID)
INNER JOIN b_search_content_site scsite ON (sc.ID=scsite.SEARCH_CONTENT_ID AND stags2.SITE_ID=scsite.SITE_ID)
WHERE
((
EXISTS (
SELECT 1
FROM b_search_content_group scg
WHERE sc.ID = scg.SEARCH_CONTENT_ID
AND scg.GROUP_ID IN (2)
)) OR (EXISTS (
select 1
from
b_socnet_search_rights
INNER JOIN b_sonet_group ON
b_sonet_group.ID = b_socnet_search_rights.ENTITY_ID
INNER JOIN b_sonet_user2group ON
b_sonet_user2group.GROUP_ID = b_sonet_group.ID
LEFT JOIN b_sonet_features ON
b_sonet_features.ENTITY_TYPE = 'G'
AND b_sonet_features.ENTITY_ID = b_sonet_user2group.GROUP_ID
AND b_sonet_features.FEATURE = b_socnet_search_rights.FEATURE
LEFT JOIN b_sonet_features2perms ON
b_sonet_features2perms.FEATURE_ID = b_sonet_features.ID
and b_sonet_features2perms.OPERATION_ID = b_socnet_search_rights.OPERATION_ID
where
b_socnet_search_rights.ENTITY_TYPE = 'G'
AND sc.ID = b_socnet_search_rights.SEARCH_CONTENT_ID
AND (
(
b_sonet_features2perms.ROLE = 'N' AND b_sonet_group.VISIBLE = 'Y'
) OR (
b_sonet_user2group.USER_ID = 0
and ifnull(b_sonet_features2perms.ROLE, 'K') >= b_sonet_user2group.ROLE
)
)
) OR EXISTS (
select 1
from
b_socnet_search_rights
LEFT JOIN b_sonet_features ON
b_sonet_features.ENTITY_TYPE = b_socnet_search_rights.ENTITY_TYPE
AND b_sonet_features.ENTITY_ID = b_socnet_search_rights.ENTITY_ID
AND b_sonet_features.FEATURE = b_socnet_search_rights.FEATURE
LEFT JOIN b_sonet_features2perms ON
b_sonet_features2perms.FEATURE_ID = b_sonet_features.ID
and b_sonet_features2perms.OPERATION_ID = b_socnet_search_rights.OPERATION_ID
where
b_socnet_search_rights.ENTITY_TYPE = 'U'
AND sc.ID = b_socnet_search_rights.SEARCH_CONTENT_ID
AND (
(
b_socnet_search_rights.ENTITY_ID = 0
) OR (
b_sonet_features.FEATURE IS NULL
) OR (
b_sonet_features.FEATURE <> 'tasks'
and b_sonet_features2perms.ROLE = 'A'
) OR (
b_sonet_features.FEATURE = 'tasks'
and b_sonet_features2perms.ROLE = 'A'
and NOT EXISTS (
SELECT * from b_sonet_features2perms t0
WHERE t0.FEATURE_ID = b_sonet_features.ID
AND t0.OPERATION_ID = 'view'
AND t0.ROLE = 'Z'
)
)
)
)))
AND (1=1) AND
scsite.SITE_ID = 's1'
AND (
(
sc.MODULE_ID = 'forum')
)
GROUP BY
stags2.NAME
ORDER BY CNT DESC
LIMIT 50[Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=']
