Поиск выдает ошибку:
File: /home/nomet/WWW/bitrix/modules/search/classes/general/search .php
Line: 201
MySQL Query Error: SELECT sc.ID ,sc.MODULE_ID ,sc.ITEM_ID ,sc.LID ,sc.TITLE ,sc.TAGS ,sc.BODY ,sc.SEARCHABLE_CONTENT ,sc.PARAM1 ,sc.PARAM2 ,sc.UPD ,sc.DATE_FROM ,sc.DATE_TO ,L.DIR ,L.SERVER_NAME ,sc.URL as URL ,stt.TF as RANK ,scsite.URL as SITE_URL ,scsite.SITE_ID ,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 FROM b_search_content sc INNER JOIN b_search_content_site scsite ON sc.ID=scsite.SEARCH_CONTENT_ID INNER JOIN b_lang L ON scsite.SITE_ID=L.LID INNER JOIN ( select st0.search_content_id, st0.TF, st0.TF RANK from b_search_content_stem st0 where st0.language_id = 'ru' and st0.stem in ('12') and st0.TF >= 0.23 ) stt ON sc.id = stt.search_content_id WHERE ((1=1)) AND scsite.SITE_ID = 's1' AND ( ( (sc.DATE_FROM IS NULL) OR sc.DATE_FROM <= '2011-01-19 14:36:53' ) AND ( (sc.DATE_TO IS NULL) OR sc.DATE_TO >= '2011-01-19 14:36:53' ) ) AND ( ( sc.MODULE_ID = 'main' AND (((sc.URL LIKE '/%' OR scsite.URL LIKE '/%')))) OR( sc.MODULE_ID = 'iblock' AND sc.PARAM1 = 'special') ) ORDER BY CUSTOM_RANK DESC, RANK DESC, sc.DATE_CHANGE DESC LIMIT 500[Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=']
Может кто-нибудь знает от чего это происходит?
Используется стандартный компонент поиска.
File: /home/nomet/WWW/bitrix/modules/search/classes/general/search
Line: 201
MySQL Query Error: SELECT sc.ID ,sc.MODULE_ID ,sc.ITEM_ID ,sc.LID ,sc.TITLE ,sc.TAGS ,sc.BODY ,sc.SEARCHABLE_CONTENT ,sc.PARAM1 ,sc.PARAM2 ,sc.UPD ,sc.DATE_FROM ,sc.DATE_TO ,L.DIR ,L.SERVER_NAME ,sc.URL as URL ,stt.TF as RANK ,scsite.URL as SITE_URL ,scsite.SITE_ID ,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 FROM b_search_content sc INNER JOIN b_search_content_site scsite ON sc.ID=scsite.SEARCH_CONTENT_ID INNER JOIN b_lang L ON scsite.SITE_ID=L.LID INNER JOIN ( select st0.search_content_id, st0.TF, st0.TF RANK from b_search_content_stem st0 where st0.language_id = 'ru' and st0.stem in ('12') and st0.TF >= 0.23 ) stt ON sc.id = stt.search_content_id WHERE ((1=1)) AND scsite.SITE_ID = 's1' AND ( ( (sc.DATE_FROM IS NULL) OR sc.DATE_FROM <= '2011-01-19 14:36:53' ) AND ( (sc.DATE_TO IS NULL) OR sc.DATE_TO >= '2011-01-19 14:36:53' ) ) AND ( ( sc.MODULE_ID = 'main' AND (((sc.URL LIKE '/%' OR scsite.URL LIKE '/%')))) OR( sc.MODULE_ID = 'iblock' AND sc.PARAM1 = 'special') ) ORDER BY CUSTOM_RANK DESC, RANK DESC, sc.DATE_CHANGE DESC LIMIT 500[Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=']
Может кто-нибудь знает от чего это происходит?
Используется стандартный компонент поиска.