Форум

SHOW GRANTS FOR <ЛОГИН>@<ХОСТ>

Module: statistic (4.0.4)
Class: CAllStatistic
File: /var/www/bitrix/modules/statistic/classes/general/statistic.php
Function: Stoplist
Line: 670
MySQL Query Error: SELECT ID, MESSAGE, MESSAGE_LID, SAVE_STATISTIC, URL_REDIRECT, TEST FROM b_stop_list WHERE ACTIVE='Y' and TEST='N' and (SITE_ID = 'ru' or SITE_ID is null or length(SITE_ID)<=0) and (DATE_START<=now() or DATE_START is null) and (DATE_END>=now() or DATE_END is null) and ((((MASK_1 & 10)=IP_1 and (MASK_2 & 77)=IP_2 and (MASK_3 & 16)=IP_3 and (MASK_4 & 201)=IP_4) or (IP_1 is null and IP_2 is null and IP_3 is null and IP_4 is null)) and (upper('Opera/8.50 (Windows NT 5.1; U; ru)') like concat('%',upper(USER_AGENT),'%') or length(USER_AGENT)<=0 or USER_AGENT is null) and (34=0 or USER_AGENT_IS_NULL<>'Y') and (upper('') like concat('%',upper(URL_FROM),'%') or length(URL_FROM)<=0 or URL_FROM is null) and (upper('/index.php') like concat('%',upper(URL_TO),'%') or length(URL_TO)<=0 or URL_TO is null) ) [Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp1251_general_ci,IMPLICIT) for operation 'like']

<?
    @mysql_query("SET collation_connection=cp1251_general_ci", $DB->db_Conn);
    @mysql_query("SET character_set_results=cp1251", $DB->db_Conn);
    @mysql_query("SET character_set_client=cp1251", $DB->db_Conn);
    @mysql_query("SET collation_database=cp1251_general_ci", $DB->db_Conn);
?>