Line: 218
MySQL Query Error: SELECT DISTINCT sc.ID ,sc.MODULE_ID ,sc.ITEM_ID ,sc.TITLE ,sc.TAGS ,sc.BODY ,sc.PARAM1 ,sc.PARAM2 ,sc.UPD ,sc.DATE_FROM ,sc.DATE_TO ,sc.URL ,sc.CUSTOM_RANK ,DATE_FORMAT(sc.DATE_CHANGE, '%d.%m.%Y %H:%i:%s') as FULL_DATE_CHANGE ,DATE_FORMAT(sc.DATE_CHANGE, '%d.%m.%Y') as DATE_CHANGE ,sc.USER_ID ,scsite.URL as SITE_URL ,scsite.SITE_ID ,1 as RANK FROM b_search_content sc INNER JOIN b_search_content_site scsite ON sc.ID=scsite.SEARCH_CONTENT_ID INNER JOIN b_search_tags stags ON (sc.ID = stags.SEARCH_CONTENT_ID) WHERE (( EXISTS ( SELECT 1 FROM b_search_content_right scg WHERE sc.ID = scg.SEARCH_CONTENT_ID AND scg.GROUP_CODE = 'G2' ))) AND scsite.SITE_ID = 's1' AND ( ( (sc.DATE_FROM IS NULL) OR sc.DATE_FROM <= '2023-03-26 00:19:57' ) AND ( (sc.DATE_TO IS NULL) OR sc.DATE_TO >= '2023-03-26 00:19:57' ) ) AND ( ( sc.MODULE_ID = 'iblock' AND sc.PARAM1 = 'site' AND sc.PARAM2 = '12') ) AND stags.NAME in ('����������������� ���� ����������������������������') GROUP BY sc.ID ,scsite.URL ,scsite.SITE_ID HAVING ( (sum(stags.name = '����������������� ���� ����������������������������')>0) ) ORDER BY CUSTOM_RANK DESC, RANK DESC, sc.DATE_CHANGE DESC LIMIT 500[Illegal mix of collations (cp1251_bin,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation '=']
Статьи /
File: /var/www/vhosts/ivanovka.org/httpdocs/bitrix/modules/search/classes/general/search.phpLine: 218
MySQL Query Error: SELECT DISTINCT sc.ID ,sc.MODULE_ID ,sc.ITEM_ID ,sc.TITLE ,sc.TAGS ,sc.BODY ,sc.PARAM1 ,sc.PARAM2 ,sc.UPD ,sc.DATE_FROM ,sc.DATE_TO ,sc.URL ,sc.CUSTOM_RANK ,DATE_FORMAT(sc.DATE_CHANGE, '%d.%m.%Y %H:%i:%s') as FULL_DATE_CHANGE ,DATE_FORMAT(sc.DATE_CHANGE, '%d.%m.%Y') as DATE_CHANGE ,sc.USER_ID ,scsite.URL as SITE_URL ,scsite.SITE_ID ,1 as RANK FROM b_search_content sc INNER JOIN b_search_content_site scsite ON sc.ID=scsite.SEARCH_CONTENT_ID INNER JOIN b_search_tags stags ON (sc.ID = stags.SEARCH_CONTENT_ID) WHERE (( EXISTS ( SELECT 1 FROM b_search_content_right scg WHERE sc.ID = scg.SEARCH_CONTENT_ID AND scg.GROUP_CODE = 'G2' ))) AND scsite.SITE_ID = 's1' AND ( ( (sc.DATE_FROM IS NULL) OR sc.DATE_FROM <= '2023-03-26 00:19:57' ) AND ( (sc.DATE_TO IS NULL) OR sc.DATE_TO >= '2023-03-26 00:19:57' ) ) AND ( ( sc.MODULE_ID = 'iblock' AND sc.PARAM1 = 'site' AND sc.PARAM2 = '12') ) AND stags.NAME in ('����������������� ���� ����������������������������') GROUP BY sc.ID ,scsite.URL ,scsite.SITE_ID HAVING ( (sum(stags.name = '����������������� ���� ����������������������������')>0) ) ORDER BY CUSTOM_RANK DESC, RANK DESC, sc.DATE_CHANGE DESC LIMIT 500[Illegal mix of collations (cp1251_bin,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation '=']
|