Ошибка при работе не под администратором. Под администратором все работает нормально. Под зарегистрированным пользователем тоже такая же ошибка. Ошибка именно в просмотре Рабочих групп других ошибок нет.
File: /var/www/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 = 'socialnetwork') ) GROUP BY stags2.NAME ORDER BY CNT DESC LIMIT 150[Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=']
File: /var/www/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 = 'socialnetwork') ) GROUP BY stags2.NAME ORDER BY CNT DESC LIMIT 150[Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=']