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 _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
