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

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

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