Periodic errors in ejabberd.log

What is it?
=ERROR REPORT==== 2009-12-25 18:46:15 ===
Error in process <0.320.0> on node 'ejabberd@localhost' with exit value: {function_clause,[{mysql_conn,get_field_datatype,"Ж"},{mysql_conn,get_fields,4},{mysql_conn,get_query_response,3},{mysql_conn,loop,1}]}

=ERROR REPORT==== 2009-12-25 18:46:20 ===
** Generic server <0.319.0> terminating
** Last message in was {sql_cmd,
{sql_query,
["select t, value, action, ord, match_all, match_iq, match_message, match_presence_in, match_presence_out from privacy_list_data where id='",
"5","' order by ord;"]}}
** When Server state == {state,<0.320.0>,mysql}
** Reason for termination ==
** timeout

Ejabberd version is 2.1.1, OS version is FreeBSD 7.2

It seems you configured

It seems you configured ejabberd to use MySQL, and you have mod_privacy_odbc.

The error may mean: when ejabberd calls your MySQL database to get privacy list information of a user, the response is not of the expected format. In this case, it expects an integer between 0 and 255, but gets the character Ж.

And what is solution for

And what is solution for this?
P.S. I didn't find value with char 'Ж' in tables.
mysql> select * from privacy_list;
+-------------+----------------+----+---------------------+
| username | name | id | created_at |
+-------------+----------------+----+---------------------+
| zodiac | invisible | 21 | 2009-12-29 21:37:50 |
| zodiac | visible | 22 | 2009-12-29 21:37:50 |
| zodiac | visible list | 23 | 2009-12-29 21:37:50 |
| zodiac | invisible list | 24 | 2009-12-29 21:37:50 |
+-------------+----------------+----+---------------------+
4 rows in set (0.00 sec)

mysql> select * from privacy_list_data;
+------+---+-------+--------+-----+-----------+----------+---------------+-------------------+--------------------+
| id | t | value | action | ord | match_all | match_iq | match_message | match_presence_in | match_presence_out |
+------+---+-------+--------+-----+-----------+----------+---------------+-------------------+--------------------+
| 21 | n | | d | 1 | 0 | 0 | 0 | 0 | 1 |
| 22 | n | | a | 1 | 0 | 0 | 0 | 0 | 1 |
| 23 | n | | d | 1 | 0 | 0 | 0 | 0 | 1 |
| 24 | n | | a | 1 | 0 | 0 | 0 | 0 | 1 |
+------+---+-------+--------+-----+-----------+----------+---------------+-------------------+--------------------+
4 rows in set (0.00 sec)

Syndicate content