[OpenSIPS-Users] MySQL Prepared Error

[ibrahim tunali]

Hello,

I got below DB error when re-registering with SVN build Opensips. I
would appreciate if you could check this issue

Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:usrloc:update_ucontact: exists callback for type=
UL_CONTACT_UPDATE
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location
set expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=?
where username=? AND contact=? AND callid=? AND domain=?|
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
successfully prepared
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
successfully set...
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement
run
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19;
buf=2009-01-30 14:17:18; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10;
buf=0.00      ; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=5;
buf=35581; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0;
is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64;
is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=21;
buf=Linksys/SPA2100-3.3.6; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24;
buf=sip:193.192.116.18:64314; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4;
buf=NULL; is_null=1
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=22;
buf=udp:81.21.166.171:5060; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4;
buf=5183; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19;
buf=2009-01-30 13:17:18; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_val2str_nq: unknown data type
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
(1)
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
ERROR:usrloc:db_update_ucontact: updating database failed
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
ERROR:usrloc:update_ucontact: failed to update database

Regards,
Ibrahim TUNALI