После обновления до 11.0.10 при выборе сотрудника выскакивает ошибка...
File: C:\Program Files\Bitrix Environment\www\bitrix\modules\socialnetwork\classes\mysql\l og_comments.php
Line: 405
MySQL Query Error: SEL ECT LC.ID as ID, LC.LOG_ID as LOG_ID, LC.SOURCE_ID as SOURCE_ID, LC.ENTITY_TYPE as ENTITY_TYPE, LC.ENTITY_ID as ENTITY_ID, LC.USER_ID as USER_ID, LC.EVENT_ID as EVENT_ID, LC.LOG_DATE as LOG_DATE_X1, DATE_FORMAT(LC.LOG_DATE, '%d.%m.%Y %H:%i:%s') as LOG_DATE, LC.MESSAGE as MESSAGE, LC.TEXT_MESSAGE as TEXT_MESSAGE, LC.URL as URL, LC.MODULE_ID as MODULE_ID, G.NAME as GROUP_NAME, G.OWNER_ID as GROUP_OWNER_ID, G.VISIBLE as GROUP_VISIBLE, G.OPENED as GROUP_OPENED, G.IMAGE_ID as GROUP_IMAGE_ID, U.NAME as USER_NAME, U.LAST_NAME as USER_LAST_NAME, U.SECOND_NAME as USER_SECOND_NAME, U.LOGIN as USER_LOGIN, U.PERSONAL_PHOTO as USER_PERSONAL_PHOTO, U.PERSONAL_GENDER as USER_PERSONAL_GENDER, U1.NAME as CREATED_BY_NAME, U1.LAST_NAME as CREATED_BY_LAST_NAME, U1.SECOND_NAME as CREATED_BY_SECOND_NAME, U1.LOGIN as CREATED_BY_LOGIN, U1.PERSONAL_PHOTO as CREATED_BY_PERSONAL_PHOTO, U1.PERSONAL_GENDER as CREATED_BY_PERSONAL_GENDER, L.SITE_ID as LOG_SITE_ID, LC.RATING_TYPE_ID as RATING_TYPE_ID, LC.RATING_ENTITY_ID as RATING_ENTITY_ID, ifnull(RG.TOTAL_VALUE, 0) as RATING_TOTAL_VALUE, ifnull(RG.TOTAL_VOTES, 0) as RATING_TOTAL_VOTES, ifnull(RG.TOTAL_POSITIVE_VOTES, 0) as RATING_TOTAL_POSITIVE_VOTES, ifnull(RG.TOTAL_NEGATIVE_VOTES, 0) as RATING_TOTAL_NEGATIVE_VOTES, ifnull(RV.VALUE, 0) as RATING_USER_VOTE_VALUE FR OM b_sonet_log_comment LC LEFT JOIN b_sonet_log L ON (LC.LOG_ID = L.TMP_ID) LEFT JOIN b_sonet_group G ON (LC.ENTITY_TYPE = 'G' AND LC.ENTITY_ID = G.ID) LEFT JOIN b_user U ON (LC.ENTITY_TYPE = 'U' AND LC.ENTITY_ID = U.ID) LEFT JOIN b_user U1 ON LC.USER_ID = U1.ID LEFT JOIN b_rating_voting RG ON LC.RATING_TYPE_ID = RG.ENTITY_TYPE_ID AND LC.RATING_ENTITY_ID = RG.ENTITY_ID LEFT JOIN b_rating_vote RV ON LC.RATING_TYPE_ID = RV.ENTITY_TYPE_ID AND LC.RATING_ENTITY_ID = RV.ENTITY_ID AND RV.USER_ID = 1 WHERE ((((L.SITE_ID = 's1' )) OR ((L.SITE_ID IS NULL) OR (length(L.SITE_ID) <= 0) OR (L.SITE_ID = '' )))) AND ((((LC.LOG_DATE <= '2012-01-29 11:17:22')))) AND ((((LC.USER_ID = 1215 )))) AND ( EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_CB = 'N' AND SLE.ENTITY_ID = LC.ENTITY_ID AND SLE.EVENT_ID = LC.EVENT_ID AND ((SLE.VISIBLE = 'Y')) ) OR ( LC.ENTITY_TYPE IN ('G','U') AND EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_CB = 'Y' AND SLE.ENTITY_ID = LC.USER_ID AND SLE.EVENT_ID = LC.EVENT_ID AND ((SLE.VISIBLE = 'Y')) ) ) OR ( ( NOT EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_CB = 'N' AND SLE.ENTITY_ID = LC.ENTITY_ID AND SLE.EVENT_ID = LC.EVENT_ID ) OR EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_CB = 'N' AND SLE.ENTITY_ID = LC.ENTITY_ID AND SLE.EVENT_ID = LC.EVENT_ID AND SLE.VISIBLE = 'I' ) ) AND ( LC.ENTITY_TYPE NOT IN ('G','U') OR NOT EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_CB = 'Y' AND SLE.ENTITY_ID = LC.USER_ID AND SLE.EVENT_ID = LC.EVENT_ID ) OR EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_CB = 'Y' AND SLE.ENTITY_ID = LC.USER_ID AND SLE.EVENT_ID = LC.EVENT_ID AND SLE.VISIBLE = 'I' ) ) AND ( EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_CB = 'N' AND SLE.ENTITY_ID = LC.ENTITY_ID AND SLE.EVENT_ID = 'all' AND ((SLE.VISIBLE = 'Y')) ) OR ( LC.ENTITY_TYPE IN ('G','U') AND EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_CB = 'Y' AND SLE.ENTITY_ID = LC.USER_ID AND SLE.EVENT_ID = 'all' AND ((SLE.VISIBLE = 'Y')) ) ) OR ( ( NOT EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_CB = 'N' AND SLE.ENTITY_ID = LC.ENTITY_ID AND SLE.EVENT_ID = 'all' ) OR EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_CB = 'N' AND SLE.ENTITY_ID = LC.ENTITY_ID AND SLE.EVENT_ID = 'all' AND SLE.VISIBLE = 'I' ) ) AND ( LC.ENTITY_TYPE NOT IN ('G','U') OR NOT EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_CB = 'Y' AND SLE.ENTITY_ID = LC.USER_ID AND SLE.EVENT_ID = 'all' ) OR EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_CB = 'Y' AND SLE.ENTITY_ID = LC.USER_ID AND SLE.EVENT_ID = 'all' AND SLE.VISIBLE = 'I' ) ) AND ( ( EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_ID = 0 AND SLE.ENTITY_MY = 'N' AND SLE.EVENT_ID = LC.EVENT_ID AND ((SLE.VISIBLE = 'Y')) ) OR ( ( EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_ID = 0 AND SLE.ENTITY_MY = 'N' AND SLE.EVENT_ID = LC.EVENT_ID AND SLE.VISIBLE = 'I' ) OR NOT EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_ID = 0 AND SLE.ENTITY_MY = 'N' AND SLE.EVENT_ID = LC.EVENT_ID ) ) AND ( EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_ID = 0 AND SLE.ENTITY_MY = 'N' AND SLE.EVENT_ID = 'all' AND ((SLE.VISIBLE = 'Y')) ) OR EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_ID = 0 AND SLE.ENTITY_MY = 'N' AND SLE.EVENT_ID = 'all' AND SLE.VISIBLE = 'I' ) OR NOT EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_ID = 0 AND SLE.ENTITY_MY = 'N' AND SLE.EVENT_ID = 'all' ) ) ) ) ) ) ) )) AND EXISTS ( SELECT SLR.ID FR OM b_sonet_log_right SLR INNER JOIN b_user_access UA ON 0=1 OR SLR.GROUP_CODE = 'SA' OR (SLR.GROUP_CODE = 'AU') OR (SLR.GROUP_CODE = 'G2') OR (UA.ACCESS_CODE = SLR.GROUP_CODE AND UA.USER_ID = 1) WH ERE LC.LOG_ID = SLR.LOG_ID) ORDER BY LOG_DATE_X1 ASC [Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=']
Как быть ?
File: C:\Program Files\Bitrix Environment\www\bitrix\modules\socialnetwork\classes\mysql\l
Line: 405
MySQL Query Error: SEL ECT LC.ID as ID, LC.LOG_ID as LOG_ID, LC.SOURCE_ID as SOURCE_ID, LC.ENTITY_TYPE as ENTITY_TYPE, LC.ENTITY_ID as ENTITY_ID, LC.USER_ID as USER_ID, LC.EVENT_ID as EVENT_ID, LC.LOG_DATE as LOG_DATE_X1, DATE_FORMAT(LC.LOG_DATE, '%d.%m.%Y %H:%i:%s') as LOG_DATE, LC.MESSAGE as MESSAGE, LC.TEXT_MESSAGE as TEXT_MESSAGE, LC.URL as URL, LC.MODULE_ID as MODULE_ID, G.NAME as GROUP_NAME, G.OWNER_ID as GROUP_OWNER_ID, G.VISIBLE as GROUP_VISIBLE, G.OPENED as GROUP_OPENED, G.IMAGE_ID as GROUP_IMAGE_ID, U.NAME as USER_NAME, U.LAST_NAME as USER_LAST_NAME, U.SECOND_NAME as USER_SECOND_NAME, U.LOGIN as USER_LOGIN, U.PERSONAL_PHOTO as USER_PERSONAL_PHOTO, U.PERSONAL_GENDER as USER_PERSONAL_GENDER, U1.NAME as CREATED_BY_NAME, U1.LAST_NAME as CREATED_BY_LAST_NAME, U1.SECOND_NAME as CREATED_BY_SECOND_NAME, U1.LOGIN as CREATED_BY_LOGIN, U1.PERSONAL_PHOTO as CREATED_BY_PERSONAL_PHOTO, U1.PERSONAL_GENDER as CREATED_BY_PERSONAL_GENDER, L.SITE_ID as LOG_SITE_ID, LC.RATING_TYPE_ID as RATING_TYPE_ID, LC.RATING_ENTITY_ID as RATING_ENTITY_ID, ifnull(RG.TOTAL_VALUE, 0) as RATING_TOTAL_VALUE, ifnull(RG.TOTAL_VOTES, 0) as RATING_TOTAL_VOTES, ifnull(RG.TOTAL_POSITIVE_VOTES, 0) as RATING_TOTAL_POSITIVE_VOTES, ifnull(RG.TOTAL_NEGATIVE_VOTES, 0) as RATING_TOTAL_NEGATIVE_VOTES, ifnull(RV.VALUE, 0) as RATING_USER_VOTE_VALUE FR OM b_sonet_log_comment LC LEFT JOIN b_sonet_log L ON (LC.LOG_ID = L.TMP_ID) LEFT JOIN b_sonet_group G ON (LC.ENTITY_TYPE = 'G' AND LC.ENTITY_ID = G.ID) LEFT JOIN b_user U ON (LC.ENTITY_TYPE = 'U' AND LC.ENTITY_ID = U.ID) LEFT JOIN b_user U1 ON LC.USER_ID = U1.ID LEFT JOIN b_rating_voting RG ON LC.RATING_TYPE_ID = RG.ENTITY_TYPE_ID AND LC.RATING_ENTITY_ID = RG.ENTITY_ID LEFT JOIN b_rating_vote RV ON LC.RATING_TYPE_ID = RV.ENTITY_TYPE_ID AND LC.RATING_ENTITY_ID = RV.ENTITY_ID AND RV.USER_ID = 1 WHERE ((((L.SITE_ID = 's1' )) OR ((L.SITE_ID IS NULL) OR (length(L.SITE_ID) <= 0) OR (L.SITE_ID = '' )))) AND ((((LC.LOG_DATE <= '2012-01-29 11:17:22')))) AND ((((LC.USER_ID = 1215 )))) AND ( EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_CB = 'N' AND SLE.ENTITY_ID = LC.ENTITY_ID AND SLE.EVENT_ID = LC.EVENT_ID AND ((SLE.VISIBLE = 'Y')) ) OR ( LC.ENTITY_TYPE IN ('G','U') AND EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_CB = 'Y' AND SLE.ENTITY_ID = LC.USER_ID AND SLE.EVENT_ID = LC.EVENT_ID AND ((SLE.VISIBLE = 'Y')) ) ) OR ( ( NOT EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_CB = 'N' AND SLE.ENTITY_ID = LC.ENTITY_ID AND SLE.EVENT_ID = LC.EVENT_ID ) OR EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_CB = 'N' AND SLE.ENTITY_ID = LC.ENTITY_ID AND SLE.EVENT_ID = LC.EVENT_ID AND SLE.VISIBLE = 'I' ) ) AND ( LC.ENTITY_TYPE NOT IN ('G','U') OR NOT EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_CB = 'Y' AND SLE.ENTITY_ID = LC.USER_ID AND SLE.EVENT_ID = LC.EVENT_ID ) OR EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_CB = 'Y' AND SLE.ENTITY_ID = LC.USER_ID AND SLE.EVENT_ID = LC.EVENT_ID AND SLE.VISIBLE = 'I' ) ) AND ( EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_CB = 'N' AND SLE.ENTITY_ID = LC.ENTITY_ID AND SLE.EVENT_ID = 'all' AND ((SLE.VISIBLE = 'Y')) ) OR ( LC.ENTITY_TYPE IN ('G','U') AND EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_CB = 'Y' AND SLE.ENTITY_ID = LC.USER_ID AND SLE.EVENT_ID = 'all' AND ((SLE.VISIBLE = 'Y')) ) ) OR ( ( NOT EXISTS( SEL ECT ID FR OM b_sonet_log_events SLE WHERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_CB = 'N' AND SLE.ENTITY_ID = LC.ENTITY_ID AND SLE.EVENT_ID = 'all' ) OR EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_CB = 'N' AND SLE.ENTITY_ID = LC.ENTITY_ID AND SLE.EVENT_ID = 'all' AND SLE.VISIBLE = 'I' ) ) AND ( LC.ENTITY_TYPE NOT IN ('G','U') OR NOT EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_CB = 'Y' AND SLE.ENTITY_ID = LC.USER_ID AND SLE.EVENT_ID = 'all' ) OR EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_CB = 'Y' AND SLE.ENTITY_ID = LC.USER_ID AND SLE.EVENT_ID = 'all' AND SLE.VISIBLE = 'I' ) ) AND ( ( EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_ID = 0 AND SLE.ENTITY_MY = 'N' AND SLE.EVENT_ID = LC.EVENT_ID AND ((SLE.VISIBLE = 'Y')) ) OR ( ( EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_ID = 0 AND SLE.ENTITY_MY = 'N' AND SLE.EVENT_ID = LC.EVENT_ID AND SLE.VISIBLE = 'I' ) OR NOT EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_ID = 0 AND SLE.ENTITY_MY = 'N' AND SLE.EVENT_ID = LC.EVENT_ID ) ) AND ( EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_ID = 0 AND SLE.ENTITY_MY = 'N' AND SLE.EVENT_ID = 'all' AND ((SLE.VISIBLE = 'Y')) ) OR EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_ID = 0 AND SLE.ENTITY_MY = 'N' AND SLE.EVENT_ID = 'all' AND SLE.VISIBLE = 'I' ) OR NOT EXISTS( SELECT ID FR OM b_sonet_log_events SLE WH ERE SLE.USER_ID = 1 AND SLE.ENTITY_TYPE = LC.ENTITY_TYPE AND SLE.ENTITY_ID = 0 AND SLE.ENTITY_MY = 'N' AND SLE.EVENT_ID = 'all' ) ) ) ) ) ) ) )) AND EXISTS ( SELECT SLR.ID FR OM b_sonet_log_right SLR INNER JOIN b_user_access UA ON 0=1 OR SLR.GROUP_CODE = 'SA' OR (SLR.GROUP_CODE = 'AU') OR (SLR.GROUP_CODE = 'G2') OR (UA.ACCESS_CODE = SLR.GROUP_CODE AND UA.USER_ID = 1) WH ERE LC.LOG_ID = SLR.LOG_ID) ORDER BY LOG_DATE_X1 ASC [Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=']
Как быть ?